Forum Discussion

arnantoakbar's avatar
arnantoakbar
Contributor
9 years ago

How to get latest Idea based on Status using LIQL?

Hi Guys,   I want to create some widget that retrieve list of latest Ideas based on their statuses using LIQL. So I start with this query to begin:   SELECT subject, view_href, status.name FROM ...
  • OlivierS's avatar
    OlivierS
    9 years ago

    arnantoakbar yes, status.name is part of messages, but you can't use it as a constraint (e.g. in a WHERE clause). The only workaround I can think is to loop through your result and do what you have to do when status.name = 'Baru'

OlivierS's avatar
OlivierS
Lithium Alumni (Retired)
9 years ago

arnantoakbar yes, status.name is part of messages, but you can't use it as a constraint (e.g. in a WHERE clause). The only workaround I can think is to loop through your result and do what you have to do when status.name = 'Baru'

  • arnantoakbar's avatar
    arnantoakbar
    Contributor
    9 years ago
    Oh I see, thank you for the explanation @OliverS :)