AnsweredAssumed Answered

application collections

Question asked by Lincoln Psaila on Sep 27, 2018
Latest reply on Oct 2, 2018 by Marek Lotocki

Thought I would run something past you all

  

I am trying to account collect a slightly complicated application:

 

I am using the following SQL

Select NTUsername, Forename, Surname, EmailAddress, 'group' =

case                                                                                               

when permissions like '%<isSystem>true</isSystem>%' then 'LON'

else 'nogroup'

end

from User1

where IsActive=1

and NTUsername like '%ABC\%'

 

 

But Aveksa is translating it to

 

Select distinct

'group' =

case 

when permissions like '%true%' then 'LON'

else 'nogroup'

end

from User1

where IsActive=1

and NTUsername like '%ABC\%'

 

 

 

Any idea how I stop MAL removing the surrounding text?

Outcomes