This is a simple ListX that shows how to implement lxExpander client utility. It allows dynamic expansion of a row to show and hide table rows beneath the parent row. Basically a group by function.

Files in CarsGroup.zip

CreateCarsTable.SQL - USE ONLY IF YOU HAVE NOT INSTALLED THE MyFirstListX sample in this forum. Run this script with a query tool or from HOST>SQL, to install the application table to your DNN database.

PopulateCars.SQL - USE ONLY IF YOU HAVE NOT INSTALLED THE MyFirstListX sample in this forum. Follow same procedure as CreateCarsTable.SQL

CarGrouping.xml - the ListX module. Add a new page to your site. Add a ListX module. From the module menu choose View Options. Click the XML icon. Replace ALL text in the XML text field with the contents of this file. Click the LOAD link. Click the SAVE CONFIGURATION link.

**NOTE** the Link column in the ListX results will not work until you set the tabid in the ACTION statement to the record edit page on your site for the MyFirstListX sample.

Hello,
I am running into issues that have been very confusing with regard to these queries until I realized that they relate to the child portal I am trying them in. Is there a system tag such as [ModuleId,System] for the identification of which portal you are running from I attempted [PortalId,System] but it didn't work.
eg.

<select name=""flddnnownerid"">
\{SUBQUERY,
Name=""qry_flddnnownerid"",
Query=""SELECT username, userid from users union
select '*Select' as username, 0 as userid ORDER BY 1"",
Format=""<option value= '[userid]'>[username]</option>"",
SelectedFormat=""<option value='[userid]' SELECTED>[username]
</option>"",
SelectedField=""userid"",
SelectedItems=""[FORMAT,[flddnnownerid,Form],{ISEMPTY:
[dnnownerid]}]"",
UseCache=""False""\}
</select>

I added the join criteria for identifing the child portal "8" in this query, and made sure they were authorized.

<select name=""flddnnownerid"">
\{SUBQUERY,
Name=""qry_flddnnownerid"",
Query="SELECT U.UserID userid, UP.PortalId, U.Username
username, UP.Authorised
FROM dbo.Users AS U
LEFT OUTER JOIN dbo.UserPortals AS UP ON U.UserID = UP.UserId
where UP.PortalId = 8 and UP.Authorised = 'true'
union select 0 as userid, 8, '*Select' as username, 'true'
ORDER BY 1"",
Format=""<option value= '[userid]'>[username]</option>"",
SelectedFormat=""<option value='[userid]' SELECTED>[username]
</option>"",
SelectedField=""userid"",
SelectedItems=""[FORMAT,[flddnnownerid,Form],{ISEMPTY:
[dnnownerid]}]"",
UseCache=""False""\}
</select>

although this still doesn't work

What's the debug error?

Well with this part there is no error, just every user from every portal is listed in the dropdowns, I need to select just the active users from this child portal, and then beyond this point I will need to display just those users who fit a particular role.

Also I realize that this should all be in the "Inline Record Editor With AJAX" thread

What id the ACTUAL sql in debug for the SubQuery Debug link?

Maybe you need to set the General option Use Explicit System Variables?

Hello Paul

What does the header [make] do?

Hello Michelle,
Can you please expand a little on your question?
Thanks,
Robert Chumley
R2Integrated

It's ok. I find it out. Thanks for the answer.

[make] is the database field I can put it as a header.

That's also a nice exemple for grouping data.

ok great! Let me know if I can help at all.
Thanks,
Robert Chumley
R2Integrated