Im storing Different types of Notes inside the SmartStore , currently im able to retrieve all the data from the smartnote table , but i need to use the Where condition to Retrieve a type of note. so i tried using

QuerySpec.buildSmartQuerySpec("select {Note:type} from {Note}" Where type='Uncategorized'", 1) but its not working im getting null value as result, so i tried using

                    "Note","type","Uncategorized","type", QuerySpec.Order.ascending,1),0);

but im getting null as result , What am i doing wrong ?

1 Answer 1


Ok this Query Works to select using Where Condition

'JSONArray result1 = smartStore.query(QuerySpec.buildSmartQuerySpec
                ("select {Note:subject},{Note:note} from {Note} WHERE {Note:Type}='Uncategorized'", 2000), 0);'

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .