I have to solve a tricky problem, but i think it is not altogether a rarity..
We have some webuser organized in webusergroups in GAS.
With a GAD projekt we want to send a mail to this user (webgoup by webgroup). The send mail task should use a dynamic var for the 'to' field. If the webuser admin change the GAS webuser as member of webuser group the script should still work for all new and updated users too.
Now I have develop a 'dirty' solution. Because we use the embbeded derby db,
- we copy the derby files with OS task
- then we have access to the user tables from GAS within a GAD database ressource
- then we can pick up the wished mailadresses with a query into a rowset
- with a 'ForEachLoop' and the rowset data we can add the mailadresses to a var for 'Sendmail'
My question is. see you a more elegantly way to do so? Or it is better to use a external db for the config data of GoAnywhere?