Hello,
I've been following the instructions on how to crate a filtered list box. https://community.emc.com/docs/DOC-10899
On step 3: creating the adaptor the DQL part
select user_name from dm_user where user_name like '${username}%' AND '${username}' != ''
Note: It is important to limit the number of possible values, for performance as well as usability reasons. In the query above, the condition ${username} != '' is there to ensure that all users in the repository are not displayed even if the filter is blank. In a large repository this might not be enough and you will need to add a DQL hint as well, limiting the number of possible values to, for example, 100 at most: ENABLE (RETURN_TOP 100).
this does not work "AND '${username}' != ''" it appears to work when the form loads, but once a value is entered it still doesn't work. I can get the form to work without the != statement but that's not what I want.
Had anyone gotten this to work?
Thanks.
