How can I query a field to be equal to the current user
I want to query a field where assigned to is equal to the current user. like API_DoQuery&query={12.EX.Current User} any idea how I could achieve this?
Forum Discussion
Hmm. I'm using it on a code page and _curuser_ is not working
- https://help.quickbase.com/api-guide/index.html#samplequeries.html
try the version in the example wtih TV (true value) and single quotes:
{'5'.TV.'_curuser_'}
- Very nice that worked thanks!
- For some reason, this is making me the current user even when someone is logged in. My goal is when the user logs into QuickBase my query string makes them the current user. "https://***.quickbase.com/db/bk*******kvs?a=API_DoQuery&query={'9'.TV.'_curuser_'}AND{12.XEX.Comple}...
- If you are the one that is issuing that HTTP request, you are the one QuickBase considers to be logged in. Other users may also be logged in simultaneously but they are not the ones issuing that HTTP request.
- Ahhh! know of any fix?
