Discussions

Expand all | Collapse all

How can I query a field to be equal to the current user

  • 1.  How can I query a field to be equal to the current user

    Posted 02-05-2018 17:12
    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?


  • 2.  RE: How can I query a field to be equal to the current user

    Top
    Contributor
    Posted 02-05-2018 18:42
    you use the placeholder value "_curuser_"

    {12.EX._curuser_}


  • 3.  RE: How can I query a field to be equal to the current user

    Posted 02-05-2018 19:45
    Hmm. I'm using it on a code page and _curuser_ is not working


  • 4.  RE: How can I query a field to be equal to the current user

    Top
    Contributor
    Posted 02-05-2018 19:53
    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_'}
     


  • 5.  RE: How can I query a field to be equal to the current user

    Posted 02-05-2018 20:57
    Very nice that worked thanks!


  • 6.  RE: How can I query a field to be equal to the current user



  • 7.  RE: How can I query a field to be equal to the current user

    Top
    Contributor
    Posted 02-05-2018 22:47
    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.


  • 8.  RE: How can I query a field to be equal to the current user

    Posted 02-05-2018 22:51
    Ahhh! know of any fix?