i installed viart for use as a school lunch ordering system at my daughters school.
 
they need to run reports based on each grade...ie: show how many lunches for grade 1, grade 2, etc.
 
grade was created as a custom field. is there any way to add "grade" as a filter option?
 
if no can i enter a sql query somewhere that would say...
 
<pseudocode>
 
select * from table where date range is XXXXX and payment_status = Paid ORDER by grade
 
</pseudocode>
 
any suggestions? thx

Hello,
 
For sure, you can add such kind of a report. Please, check the default order products report admin_orders_products_report.php where the information is grouped by products and you can add similar report with grouping using some field like grade.
 
With regards,
ViArt Support Team
 
 

can you elaborate a bit more on how/where i would do this....looking through the code is a bit confusing. thx

Hello,
 
We can help you to create such report for some extra fee. If it is interesting for you, could you please send the full details to our support team and we will calculate you the quote.
 
With regards,
ViArt Support Team