Forum Discussion

PatoSalazar's avatar
PatoSalazar
Ace
9 years ago

URL QUERY BUILD V2

Hi,    I am trying to build a url that fetches SELECTS everything FROM messages WHERE subject MATCHES the word pay AND depth=0 and language='FR'   This is what I have but gives me a 604 error. If...
  • ChhamaJ's avatar
    ChhamaJ
    9 years ago

    Hi PatoSalazar,

     

    Your query below doesn't work because we do not support a filter for language in LiQL.  Most of our customers usually have one community for each language or they have a particular board or category set up for a particular language.

     

    In case where you have a community set up in a particular language, you can just do 

    select * from messages where subject matches 'pay' and depth=0

    In case when you have a board/category set up in a particular language, you can do 

    select * from messages where subject matches 'pay' and depth=0 and board.id ='test'

select * from messages where subject matches 'pay' and depth=0 and category.id = 'test'

    Hope this helps.

     

    Regards,
    Chhama

ChhamaJ's avatar
ChhamaJ
Khoros Staff
9 years ago

Hi PatoSalazar,

 

Your query below doesn't work because we do not support a filter for language in LiQL.  Most of our customers usually have one community for each language or they have a particular board or category set up for a particular language.

 

In case where you have a community set up in a particular language, you can just do 

select * from messages where subject matches 'pay' and depth=0

In case when you have a board/category set up in a particular language, you can do 

select * from messages where subject matches 'pay' and depth=0 and board.id ='test'

select * from messages where subject matches 'pay' and depth=0 and category.id = 'test'

Hope this helps.

 

Regards,
Chhama