I searched the forum but could not find a suitable solution.
I have a Collection where payments are stored.
I want to make some statistical calculations.
The most purchased product,
The highest amount,
I have to calculate these results based on variable filters.
- Start and End Date
- Payment Type
Date is mandatory for these filters,
Others are optional and can have several filters at once.
- Date range
- Date Range + Payment Type + Company
- Date Range + Person
I have used FQL with admiration thus far.
But I don’t know exactly how to prepare “Where” queries that we are used to from SQL.
I will be grateful if you could help me