Hi all,
Wondering if anyone can help with this....
I have a Picker Control which works fine when a User has just one account (E1234567), however if the user has multiple accounts (E1234567W) or (E1234567PM) then the picker control says "Unable to resolve".
To address this issue, I only ever want to filter on the normal account a user has i.e (E1234567)
So can I do a filter in the "Populate Picker List Control with Data" Rule to only filter users with just E and several numbers and not any accounts with a W, PM or a letter on the end?
In the Picket List control filter, you only get a few operators like begins with or ends with. How can i do a filter which only displays with E and seven numbers only??
Would i need an expression? If so, how would i construct it for what i need?
Thanks as always....