Forum Discussion

clemensw's avatar
clemensw
Guide
7 years ago

LiQL view_friendly_date of post_time

Dear Community,

we are using a LiQL query like that:

<#assign mostviewedMessages = restadmin("2.0", "/search?q=" + ("SELECT * FROM messages where conversation.style='blog' AND depth=0 ORDER BY metrics.views DESC limit 5")?url).data.items![] />

Is it possible to get the post_time of the messages also in view_friendly format like “2 weeks ago”? How?

${mostviewedMessage.post_time } shows “Jul 8, 2016 12:34:13 PM”
${mostviewedMessage.post_time@view_friendly_date} is not working

Thank you, best
Clemens

  • saikumarn's avatar
    saikumarn
    7 years ago

    Hi clemensw

    increase the days in below option:
    Admin > System > Date and Time > Number of days to use relative dates
    Ex:1500

    Code:

    <#assign query="SELECT * FROM messages where conversation.style='blog' AND depth=0 ORDER BY metrics.views DESC limit 5"/>
    <#assign mostviewedMessages = restadmin("2.0", "/search?q=" +query?url).data.items/>
    <#list mostviewedMessages as mostviewedMessage>
    ${mostviewedMessage.post_time_friendly}<br>
    </#list>

7 Replies

Sort By
  • clemensw's avatar
    clemensw
    Guide
    7 years ago

    Hi saikumarn

    thank you for your reply, but unfortunately I don't know how to use it.

    How can I get the friendly version of ${mostviewedMessage.post_time} ?

    do I need something like:
    <#assign datesupport.setDate({mostviewedMessage.post_time}) />
    ${datesupport.friendlyDateAsString} ?

    Thanks,
    Clemens

  • Parshant's avatar
    Parshant
    Boss
    7 years ago

    clemensw

    Use below code to fetch post friendly time using your query.

    ${mostviewedMessage.post_time_friendly}

     

     

  • clemensw's avatar
    clemensw
    Guide
    7 years ago

    Hi Parshant

    unfortunately it's not working:

    when we use: ${mostviewedMessage.post_time_friendly}
    we get:

    The following has evaluated to null or missing:
==> mostviewedMessage.post_time_friendly  [in template "preview" at line 38, column 75]

    when we use:

    <#if mostviewedMessage.post_time_friendly??>
    ${mostviewedMessage.post_time_friendly}
    <#else>
    ${mostviewedMessage.post_time?datetime?string}
    </#if>

     we get e.g.: Jul 8, 2016 12:34:13 PM

    It seems that ${mostviewedMessage.post_time_friendly} is empty.
    How can we convert it to a friendly version?
    How can we convert it to a version without time, only date?

    Regards,
    Clemens

  • Parshant's avatar
    Parshant
    Boss
    7 years ago

    clemensw,

    Update these settings in your community from Community Admin:

    Admin >  System > Date and Time > Display dates as

    relative_time.PNG

     

     

  • saikumarn's avatar
    saikumarn
    Advisor
    7 years ago

    Hi clemensw

    increase the days in below option:
    Admin > System > Date and Time > Number of days to use relative dates
    Ex:1500

    Code:

    <#assign query="SELECT * FROM messages where conversation.style='blog' AND depth=0 ORDER BY metrics.views DESC limit 5"/>
    <#assign mostviewedMessages = restadmin("2.0", "/search?q=" +query?url).data.items/>
    <#list mostviewedMessages as mostviewedMessage>
    ${mostviewedMessage.post_time_friendly}<br>
    </#list>