Custom Query
The Custom Query action is a powerful tool in database management that allows users to retrieve specific data from a table by crafting customized queries. With this action, you can precisely define the criteria and conditions for data extraction, ensuring that you retrieve only the information that matters to your needs.
For example, to create a chart for a management report, we need to get the previous 12 months of data. We limit the query to 13 records and in descending (DESC) order. That way the first record is the current one and the last one is the same month for last year.
Here we are collecting the Select fields: ID, Period, Sales, Billed Hours, Income, Expenses and Profit
With the condition Where the field ID is less than or equal to the current record ID
