Combine multiple where clauses referencing component values

[vipul]

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).

[maxkatz]

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

[Illya Stepanov]

Hi Bahar,

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

[bahar.wadia]

When I run a Test

[Maryna Brodina]

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

[bahar.wadia]

Got it! Thank you so much.

[Maryna Brodina]

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.

[bahar.wadia]

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.

[Maryna Brodina]

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

[bahar.wadia]

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