Hello, I am attempting to design a report to collect order totals per product for a week. This being said I am not sure how to structure OQL queries to call all orders based on the products connection on the orderlines table. I will also want to constrain the report based on the previous week or month time length. Would this be best applied by using the date parameter inputs on the reporting grid? Is there any additional OQL tutorial resources that you recommend, beyond the standard Mendix information pages? Thank you in advance.
Sure, there is the playground at service.mendixcloud.com. Plenty of examples including a nice domainmodel to practise with.
Furthermore quite recent an add-on module has been released to the marketplace called ‘SaferOQL’. Very useful. Making it easier to create OQL’s