I guess I'm confused by the filter expression. I'm using Dnn 5.0.1 with forms & Lists 5.0. The ? next to the field states "Use SQL Where clause syntax" but the manual 3.5.1 states use DataColumn.Expression syntax for the filter expression. Regardless, what I have been attempting hasn't been working.
Here's what I'm attempting to do (maybe my thinking is way off base):
The Boss wants (yesterday) privately registered users to see a list of Natural Gas Wells with their operational status. They should only see the wells they are invested in through an investment program. I have made the "Program" names into security groups.
I've loaded the UDT with Well status data with the following columns Program, WellName and OperationalStatus (all text fields) A well belongs to only 1 Program. The Program column values are the same as the security role names. The Program/role names are never overlapping - that is it you search a delimited list, you will never find a Program as a substring of a another program/role name. (theres no need to wrap a search value n commas)
Each registered user may be a member of multiple security roles. i'd like to have a single list of wells that is filtered instead of maintaining 250 lists.
I have yet to get the DataColum expressions to work in the filter statement field and I'm not exactly clear as to what is going on behind the scenes. Since my filter expression isn't working referencing the [user:roles] token I'm thinking maybe I can use a calulated coumn to test whether the [Program] field value is IN the [User:Roles] delimited list. If it is, the calculated value returns 1 else 0. Then my Filter expression would be [CalulatedFieldName] = 1
Well that's my thought on my new approach. I hope this makes more sense.
CalcCol: tIIF([Program] IN [User:Roles], 1,0) or somehting like that.
FilterExpression: CalcCol = 1
Sorry to be such a pain. If this works, others my be able to use the same approach to get a relationship between users and a UDT.