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.