Hi - I'm in the process of building a series of asset listings / sql data queries that will help us keep an eye on our CMS. These live on a dev server so i need to resort to sql queries to a different installation. The one I'm stuck on is getting a page that will list all the user groups and a bullet list of users for each one.
My first query gives me the user groups:
select distinct name, assetid from sq_ast WHERE type_code = 'user_group' order by name;
Then the second query takes the assetid via a get variable called user from above:
select minorid, majorid from sq_shdw_ast_lnk WHERE majorid = %%user%%;
The first query is then put into an asset listing page - on the group format i nest the second query via another asset listing page. The problem comes with trying to use the data source variable (%ds__assetid%) into the GET variable of the nested listing. I can hard code a assetid and everything works (of course i get the same user list for each group).
Is there anyway to reuse this variable within a nested div on the group format page?
Or is there a better approach? I don't want to put these type of pages/queries on our production server.