• State Verified Answer
  • Locked Locked
  • Replies 5 replies
  • Subscribers 96 subscribers
  • Views 3447 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

ITShop %useruid% Use in Organizational Attributes

joshua fellers
over 6 years ago

I am trying to get the uid of the current logged in user in a filter in Employee -> Organizational Attributes under Configure Project. 

I have a lengthy filter that works great if I manually add my guid such as ... WHERE uid_person ='manuallyaddedloggedinguidhere' AND...

But if I try to use the variable ... WHERE uid_person ='%useruid%' AND... it does not work as expected. I suspect it is resolving to NULL/empty. I also tried

WHERE uid_person = (select top 1 uid_person from User) and it fails to compile, though the query syntax is valid. I tried several other ideas and avenues with no luck. I am guessing this query is executed server side and does not have access to the client side data? What do I need to do to be able to filter by the logged in user uid from Organizational Attributes?

 

Parents
  • 0 over 6 years ago

    Hi,

    It's not very clear where you are trying to use this filter...but you can try wrapping it with the variable() function to force an evaluation of the variable  as in the example below:

      format(LastName like '%{0}%' and uid_person='{1}'", FROM Vars SELECT var1, variable('%useruid%')) from Vars select var1

    hth,

    Rob.

Reply
  • 0 over 6 years ago

    Hi,

    It's not very clear where you are trying to use this filter...but you can try wrapping it with the variable() function to force an evaluation of the variable  as in the example below:

      format(LastName like '%{0}%' and uid_person='{1}'", FROM Vars SELECT var1, variable('%useruid%')) from Vars select var1

    hth,

    Rob.

Children