I couldn't tell from the documentation, so I'm hoping you can answer here.

We've got a report with a complex query. I'm wondering if it's possible to only run that complex query after the user has clicked submit?

The parameter options are built using other, simpler queries.

Thank you!

Comments

nubeli created an issue. See original summary.

metzlerd’s picture

metzlerd CreditAttribution: metzlerd commented

If you make even one parameter required, without a default value, then the query will not be run until all required parameters are present.

I think that's the closest it gets.

Dave

nubeli’s picture

nubeli CreditAttribution: nubeli commented

Thanks Dave.

I can confirm what you said:

one parameter required, without a default value, then the query will not be run until all required parameters are present.

In our case, I was inquiring so we could try to reduce the report load time. We made an additional simple change which helped quite a bit in reducing our report load time. I changed the folder where frx files are stored so it was in its own folder rather than sites/default/files. On every report load Forena was scanning all the files and folders in sites/default/files so this change reduced the load time by quite a bit. This might be in the Forena guides which I overlooked.

metzlerd’s picture

metzlerd CreditAttribution: metzlerd commented
Status: Active » Closed (works as designed)

Makes sense. New defaults should have forena using a reports folder inside sites/default/files, so this is a bit of an artifact of a bug that existed with the version fo forena that you originally installed. Closing this case as it seems solved.