current.UserKey parameter to a Query

How do I?
1

Hello, what is the proper way pass the current user key to a Query?
I looked at these both threads Expression in SQL query - #2 by shweta and Live Query Not Working - #7 by Abu_Bakr_Siddique but they are not any help.

Here is my query
SELECT
iUser.iUserKey,
iUser.UserID,
iUser.FullName,
iUser.iUserRecordKey
FROM
iUser
WHERE iUserKey = ?

Here is my parameter

image
image513×400 11.3 KB

I tried {{five.current.UserKey()}} and {{five.stack.iUser.iUserKey}} with no success.
with and without brackets. The user’s role has permission to read iUser table.
In Five Inspector , the string is still empty.

image
image223×252 8.66 KB

What am I doing wrong? Thanks,
Jean

2

Hi @JeanXXIV,

You can use five.currentUserKey() to get it.

Refer to the document for more details:
currentUserKey() | Five | Low-Code For Real Developers

3

No sorry, does not work :frowning:

image
image269×231 7.79 KB

The query works when I replace the ‘?’ by the iUserKey in the query itself…
SELECT
iUser.iUserKey,
iUser.UserID,
iUser.FullName,
iUser.iUserRecordKey
FROM
iUser
WHERE iUser.iUserKey = “f2ce88dd-29e1-4da0-99e6-88246ff8040c”

4

If {{five.currentUserKey()}} is not working as expected, you can set as a variable and use {{five.variable.UserKey}} in the parameters

Sample function to set variable which can be assigned to the Application’s Do Logon event or any other relevant event

function ApplicationDoLogon(five, context, result) {
    five.setVariable("UserKey", five.currentUserKey());
    return five.success(result);
}
5

Ok yes! Now it works, thanks for your quick reply.