That's exactly what I have. I have a custom DocType of Person that I use to extend data in the Users table. I understand that I can add custom fields to the Users table (and I have) but sometimes there's data that isn't applicable to all users or needs to be used in place of the data in the users table. My Person DocType has a UserName field that matches the UserName field in the Users table. I then extend the Person DocType to specific types of Persons that have unique characteristics.

To join my docType back to the Users table I have a custom query. That part works and is fine and it has all the data I want. I use a basic repeater and tie it to a datasource with my custom query. On my Item Transformation I display basic user info, on my selected item transformation I want to display extended user info. All of this information is in my custom query. Using GetDocumentUrl() I am able to generate a link that directs to my selected item. However, the Selected Item transformation is never called.


So using your example above.

People page (transformation is used)
---Person 1
---Person 2
---Person 3

Those are all documents and I can click and get to them so my url looks like /People/Person1.aspx but the Selected Transformation does not render. It always uses the Item Transformation.

I could do this without a custom query and just use a repeater on the DocType and then use custom functions and GetUserInfo to resolve all of the fields. However, that seems like it would be a database lookup on every field and that doesn't seem very efficient when I can issue one query call and get all my data.

Please advise.