This is my test code -
This is what it returns -
“Orders.OrderDate >= 1664484402395 OR SellersFundraisers[Fundraisers].Orders.OrderDate >= 1664484402395---------0---------100”
The query to the table returns the max number of rows (100), and the query to get the object count returns 0.
If I change the distinct to false on the Get Object Count, I get 7xxx, which makes sense for a non-distinct count.
Is this not how this works?
Hi. Provide please the appId and the full db query (or where clause) you use.
In general – the distinct keyword says that the duplicates should be removed from the answer.
App ID EEE25B20-17FA-97DD-FF29-EC45A5072A00
The full WHERE is in the image above. Do you want me to provide a text version?
Yes, the text version which can be used in
Data -> Data Browser -> Search field.
“Orders.OrderDate >= 1664484402395 OR SellersFundraisers[Fundraisers].Orders.OrderDate >= 1664484402395”
For table Fundraisers.
Thanks for the provided data, I’ve created a ticket BKNDLSS-30097 to investigate the issue.