Forum Discussion

hayata's avatar
hayata
Ace
4 years ago

Additional subscription fields in LiQL.

I need to get a list of subscription for a user. I am using the below query. SELECT target,target.id,target.subject,target.board.title,target.post_time,target.last_post_time,target.user_context.rea...
Parshant's avatar
Parshant
Boss
4 years ago

hayata,

For Target field value is different for each target.type in subscription:

Like:

WHERE target.type='conversation'

will return only these types of attributes for target

"target" : {
        "type" : "conversation",
        "id" : "123",
        "view_href" : "/t5/posturl",
        "style" : "blog",
        "thread_style" : "blog",
        "messages_count" : 2,
        "solved" : false,
        "last_post_time" : "2020-07-14T07:27:54.963-07:00",
        "last_post_time_friendly" : "07-14-2020",
        "last_posting_activity_time" : "2020-07-14T07:27:54.963-07:00"
      }

 For message it will be

"target" : {
        "type" : "message",
        "id" : "123",
        "href" : "/messages/123",
        "view_href" : "/t5/message_url"
      },

 

Similarly it will be different for each of the following:

 

  • message
  • thread
  • board
  • category
  • grouphub
  • product
  • label