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 metr...
  • 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>

saikumarn's avatar
saikumarn
Advisor
7 years ago

Hi,

I think this document would be helpful to you. 

Ex : ${datesupport.now.friendlyDateAsString}

  • 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