By using this website, you agree to our Terms of Use (click here)
This idea would depend on the completion of this Saved SQL Queries idea:
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:
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.