How to make a LIKE query.

Question

Hi I am trying to query for mobile numbers. +919000000000 or 9000000000 i.e %9000000000

Query qMobile=QueryBuilder.build(ModelUserData.KEY_DATA+"."+ModelPhone.KEY_MOBILE, "%"+mobile, Operator.LIKE);

It is not working.

Please help.

Answer 1

Hello,

Thanks for sharing build statement to resolve this, you need to remove the "%" operator from query. It will work for you. If you still face any issue, then please share the sample JSON and internal logs of findDocumentByQuery method which you are using. It will help us to provide better support from our end.

To print the intenal logs, put the below line of code before making a fetch call:

App42Log.setDebug(true);

Regards,

Himanshu Sharma