Save custom query
This is an excellent idea and much needed. At the very least it would be nice to be able to load a sql statement in a text file from the file system like the old version could do.
Vote up!
Great shout. We use lots of custom queries for our accounts etc. This would make it alot easier than having lots of text files with our queries saved in.
To extend this even further... the ability to use saved queries throughout the system, for example in scheduled exports, custom dashboards, maybe rules engine?
would love to see this feature.
Pretty sure this is already possible (in .net at least)...
Setings -> Export Data -> New Export -> Export Type = 'Custom' -> Paste SQL -> Select export location/fields to export/schedule/etc
Good Luck!
Yes, I would like to see this feature too.
It would be a great feature to be able to save your customer Scripts in the drop down for the query data report. I know you can create an export but we dont give that functionality to all our staff.
Jack Nord
Also, a way of mapping input variables into this would be good, because the people who use the custom queries are often not the people who write them.
2 people like this idea