I am using the DNNSharp ActionGrid and would like to filter the Grid using a Token Value. Using DotNet Nuke version 9.2 I have created 2 custom profile fields. One is a text box and I can use this in the SQL where clause using the Token [Profile:Agency]. The second profile field is a list when I try to use this list with the Token [Profile:AgencyList] I get no data returned from the SQL table. When I inspect the SQL query in a trace the Token value being passed to the SQL server is '********' Why can I not get the value of that Profile list?
Turns out the problem was a typo in the query string. Apparently trying to access a non existing profile field will return the ******** string.