Joe Bohen
Posts: 0
Joined: Wed Nov 28, 2012 11:28 am

Database query

Hi, I am attempting to query a data base to find a record(s) where the string field jobnum contains 130233 the query looks like { "jobnum" : {"$in":['130233']}} when I attempt the query I get a success shown but no data is returned. The record I am wishing to return is 130233:1Del. Is my query incorrect?

Regards,
Joe

Evgene Karachevtsev
Posts: 12
Joined: Mon Apr 28, 2014 1:12 pm

Database query

Hello Joe,

Please take a look at this link: http://devcenter.appery.io/documentat...

Joe Bohen
Posts: 0
Joined: Wed Nov 28, 2012 11:28 am

Database query

Hi, that's the document I referenced, but I am not able to get the code to work!

Joe Bohen
Posts: 0
Joined: Wed Nov 28, 2012 11:28 am

Database query

Hi Sorry Evgene, I had missed the regex operator now everything is good thank you.

Kateryna Grynko
Posts: 0
Joined: Thu Nov 15, 2012 9:13 am

Database query

Hi Joe,

Your query looks right. Do you have a permission to read this row?
http://devcenter.appery.io/documentat...
Please post the screenshot of this row in your collection.

Kateryna Grynko
Posts: 0
Joined: Thu Nov 15, 2012 9:13 am

Database query

Hi Joe,

Thank you for the update! Glad it's working.

Return to “Issues”