Hello everyone. I am using sqlite to create a web application. I am currently in the process of writing reports using Agata.I had created views because i had some tables whose rows i had to concatenate in order for the reports to make any sense.
But the problem i have now is that Agata does not want to see or query from the views. Can anyone help me with creating temporary tables in place of the views, which are available during runtime, which have the same fields and data as my view such that when one table is updated, the results are appended to the temporary table