Forum | Appery.io

My problem is that i am not able to pass current date in the Date column. Is there any way (may be with the use of datepicker) to get current date(todays date).

To get today's date, you can run a basic JavaScript. Is that what you are asking?

Hi Bahar,

Where are you getting this error message?
Can you post the screenshot of actual query that you are trying to run?

When I run a Test

Hello! If you select using _id there is no need to use $inQuery ($inQuery is used while selection by field in dependent table).

Got it! Thank you so much.

Hello! If I understand correctly you need values in which in pointer column OwnerID is not 5235ecccxxxxxxxxxxx1bb7bb0? Try this way pre{ "$and": [ {"MyItemName":{"$regex":"\bwat.*", "$options":"im"}}, { "OwnerID": {"$ne":{"collName":"detail", "_id":"5235ecccxxxxxxxxxxx1bb7bb0"}}} ]} /prewhere detail - collection name which is specified by pointer OwnerID.

Sweet! That works nicely.

For future reference, can you please help me understand why "inQuery" generates error?

Thank you so much for your help.

You guys are the best tech support I have experienced.

You can't run inQuery in $and. structure.

Thanks, are there any other limitations. Is there a document somewhere that describes these limitations.