Home› Analyst Portal

User Query

David_AllenDavid_Allen Partner Advanced IT Monkey ✭✭✭
in Analyst Portal

Hello,

The default User Query defined in the portal settings is 'DisplayName LIKE '%' + @Query + '%' OR UserName LIKE '%' + @Query + '%''.

Does anyone know the best way to update this to restrict the users returned to be only from a specific domain and not include an underscore in the username?

Thanks,
David

Best Answer

  • Jeff_LangJeff_Lang Customer Ninja IT Monkey ✭✭✭✭
    Answer ✓
    @David_Allen you could try something like (modifying the DomainName in it)

    (DisplayName LIKE '%' + @Query + '%' OR UserName LIKE '%' + @Query + '%') AND UserName NOT LIKE '%_%' AND Domain = 'DomainName'


Answers

  • Jeff_LangJeff_Lang Customer Ninja IT Monkey ✭✭✭✭
    Answer ✓
    @David_Allen you could try something like (modifying the DomainName in it)

    (DisplayName LIKE '%' + @Query + '%' OR UserName LIKE '%' + @Query + '%') AND UserName NOT LIKE '%_%' AND Domain = 'DomainName'


  • David_AllenDavid_Allen Partner Advanced IT Monkey ✭✭✭
    That worked.. Thank you!
Sign In or Register to comment.