outsystems - Active directory user log in -

i working on module using active directory integration. if user logs in active directory credentials, username field in table of webpage populeted domain\username (eg: abc\username , abc domain name). new outsystems , module working on.

i have new requirement need select fields username doesnot start "abc\". tried create below query not working.it pulling records user, need records if username doesnot starts "abc\". not sure how abc\ gets added username.

 select {user}.[id],         {user}.[name],         {user}.[email],         {user}.[username]  {user}  {user}.[tenant_id] = @tenantid , {user}.[username] not 'abc\\\\%_'  

i tried filter respect email address below working fine

 select {user}.[id],         {user}.[name],         {user}.[email],         {user}.[username]  {user}  {user}.[tenant_id] = @tenantid , {user}.[email] not '_%@abc.com'  

please me this.

try this:

... , {user}.[username] not 'abc' + char(92) + '%'

the \ character being escaped outsystems before being sent database.