Forum Discussion

ethanede's avatar
ethanede
Helper
7 years ago

Translate Freemarker to LiQL query?

Hello all, First time poster, new to Lithium, this is probably pretty basic, please be gentle. I did some searching but couldn't find anything directly addressing this question. Is it possible to c...
  • Parshant's avatar
    Parshant
    7 years ago

    ethanede

    If the page is associated with a user, then "context.user" returns a user context object, otherwise returns null.

    ${page.context.user.id}


    You can chain calls on the user object from this method. We can use this in MyProfilePage (only when an admin is editing another user's profile.) and ViewProfilePage on viewign other's profile information.

    <#assign page_user_id = page.context.user.id />
    <#assign custom-profile-field = profile.agent_id />

    Using V1:

    <#if page_user_id??>
      <#assign allowed=rest("/users/id/${page_user_id?c}/profiles/name/${custom-profile-field}/allowed").value />
      <#if allowed?trim == "true">
          <#assign value = rest("/users/id/${page_user_id}/profiles/name/${custom-profile-field}").value />
          <span>${value?string}</span>
      </#if>
    </#if>

    Using V2:

    Select * from users where id='${page_user_id?c}'

luk's avatar
luk
Boss

ethanede The question is, what information do you actually need?

Generally the profile information of the currently logged in user could be fetched from the API by utilizing the FreeMarker "user" context object, which is not only available on the profile page, but everywhere, there you'll have the user.id or user.login from which you could build the API query needed. But if you want to do something specific with the agent_id this might not work...

ethanede's avatar
ethanede
Helper
7 years ago

Thank you for your response.

I was simply trying to display the user ID.  The question was how to access that same information using a LiQL query as I was not able to see the agent_id in the returned json string for the LiQL query, so didn't understand from where it was pulling this data.

  • luk's avatar
    luk
    Boss
    7 years ago

    ethanede this "agent_id" field is not something I have encountered for a user object yet, so it could be possible that this is a custom "metadata" field for users in your community and therefore not returned by API v2, but that's just a guess in the dark. Would need more information on what this ID is (where is it coming from?)...

    • Parshant's avatar
      Parshant
      Boss
      7 years ago

      ethanede

      If the page is associated with a user, then "context.user" returns a user context object, otherwise returns null.

      ${page.context.user.id}


      You can chain calls on the user object from this method. We can use this in MyProfilePage (only when an admin is editing another user's profile.) and ViewProfilePage on viewign other's profile information.

      <#assign page_user_id = page.context.user.id />
      <#assign custom-profile-field = profile.agent_id />

      Using V1:

      <#if page_user_id??>
        <#assign allowed=rest("/users/id/${page_user_id?c}/profiles/name/${custom-profile-field}/allowed").value />
        <#if allowed?trim == "true">
            <#assign value = rest("/users/id/${page_user_id}/profiles/name/${custom-profile-field}").value />
            <span>${value?string}</span>
        </#if>
      </#if>

      Using V2:

      Select * from users where id='${page_user_id?c}'

      • ethanede's avatar
        ethanede
        Helper
        6 years ago

        Thanks much for your help, Parshant + others!