Page 1 of 1
Database query
Posted: Thu May 22, 2014 1:06 pm
by Joe Bohen
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
Database query
Posted: Thu May 22, 2014 1:47 pm
by Evgene Karachevtsev
Hello Joe,
Please take a look at this link: http://devcenter.appery.io/documentat...
Database query
Posted: Thu May 22, 2014 2:39 pm
by Joe Bohen
Hi, that's the document I referenced, but I am not able to get the code to work!
Database query
Posted: Thu May 22, 2014 3:20 pm
by Joe Bohen
Hi Sorry Evgene, I had missed the regex operator now everything is good thank you.
Database query
Posted: Thu May 22, 2014 3:47 pm
by Kateryna Grynko
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.
Database query
Posted: Thu May 22, 2014 3:49 pm
by Kateryna Grynko
Hi Joe,
Thank you for the update! Glad it's working.