https://www.augforums.com/forums/augsql/saved-sql-queries

Currently, in the SQL Command field on the AugSQL (QQ900001) screen, you can use SQL like this:

DECLARE @MyParam1 VARCHAR(20)
SET @MyParam1='AACUSTOMER'
DECLARE @MyParam2 VARCHAR(20)
SET @MyParam2='ABARTENDE'
SELECT AcctCD, AcctName
FROM BAccount
WHERE CompanyID=2 AND AcctCD IN (@MyParam1,@MyParam2)

Which returns results like this:

What if you put the SQL Code above in the SQL Command field on the AugSQL Saved Queries (QQ900003) screen and save it.

Then, what if you could populate the @MyParam1 and @MyParam2 values at runtime in the URL. There would also need to be a parameter that tells the query to run. Maybe something like this:

https://mycompany.acumatica.com/Main?CompanyID=SalesDemo&ScreenId=QQ900003&Action=RunQuery&MyParam1=MyValue1&MyParam2=MyValue2

That would be interesting. Actually, that would change my approach to the Schedule Queries Idea (click here) so I'm going to add to that Discussion with another idea.