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

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?

Top Replies

joshua fellers over 6 years ago in reply to joshua fellers +3 verified

I was able to get a solution from another quest employee:

Adjust your query based on example below:

format("from user select firstname where uid_person = '{0}'", GetUser())

GetUser(…

Parents

0 Robert Byrne 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.
Cancel
Up 0 Down

Cancel
0 joshua fellers over 6 years ago in reply to Robert Byrne

Not sure if the image thing will work if not see it here https://imgur.com/a/3ZoCYdn

I tried your idea with no luck. You can see the error in the screenshot when I tried your idea (but the query shown is my original).
Cancel
Up 0 Down

Cancel

Reply

0 joshua fellers over 6 years ago in reply to Robert Byrne

Not sure if the image thing will work if not see it here https://imgur.com/a/3ZoCYdn

I tried your idea with no luck. You can see the error in the screenshot when I tried your idea (but the query shown is my original).
Cancel
Up 0 Down

Cancel

Children

0 Hanno Bunjes over 6 years ago in reply to joshua fellers

Use the original (shown on the left), and look at the SQL log to find out whether the %useruid% variable is being replaced.
Cancel
Up 0 Down

Cancel
0 joshua fellers over 6 years ago in reply to Hanno Bunjes

The variable is not being evaluated. It shows up as the string useruid with percents around it (this forum wont let me post the SQL or percents for some reason anymore and the insert code tool says I don't have permission).
Cancel
Up 0 Down

Cancel
+1 joshua fellers over 6 years ago in reply to joshua fellers

I was able to get a solution from another quest employee:

Adjust your query based on example below:

format("from user select firstname where uid_person = '{0}'", GetUser())

GetUser() would return the UID you need.

also consider SQLInWithFormat() function for your WHERE clause.
Cancel
Up +3 Down

Cancel