Wednesday, 15 May 2013

Writing dynamoDB "OR" condition query? -



Writing dynamoDB "OR" condition query? -

i want query dynamodb table boolean or status sql e.g. get me items attribute1 = "no" or attribute2="no"

i tried scanrequest.withscanfilter conditions performed doing boolean anding. how do boolean oring.?

you can set conditionaloperator of scanrequest "or". default value "and"

http://docs.aws.amazon.com/amazondynamodb/latest/apireference/api_scan.html

scanrequest scanrequest = new scanrequest("tablename"); scanrequest.setconditionaloperator(conditionaloperator.or); map<string, condition> scanfilter = new hashmap<string, condition>(); scanfilter.put("attribute1", new condition().withattributevaluelist(new attributevalue("no")).withcomparisonoperator(comparisonoperator.eq)); scanfilter.put("attribute2", new condition().withattributevaluelist(new attributevalue("no")).withcomparisonoperator(comparisonoperator.eq)); scanrequest.setscanfilter(scanfilter); scanresult scanresult = dynamo.scan(scanrequest); for(map<string, attributevalue> item : scanresult.getitems()) { system.out.println(item); }

amazon-dynamodb

No comments:

Post a Comment