Forum Discussion

shong's avatar
shong
Adept
8 years ago

undefined collection: solutions_data

Hello  I am using API browser to execute this LiQL: select * from solutions_data   But it returns the following error: { "status" : "error", "message" : "undefined collection: solutions_data",...
  • darrenSP's avatar
    darrenSP
    8 years ago

    Worked perfect for me. Added a where so I only get accepted solutions back.

    SELECT solution_data,is_solution FROM messages WHERE is_solution = true

     

    Thanks!

VikasB's avatar
VikasB
Boss

Hi shong

It's empty means they did not get accepted as a solution yet.  

Try below query you will get false.

select solution_data,is_solution from messages

 

darrenSP's avatar
darrenSP
Mentor
8 years ago

Worked perfect for me. Added a where so I only get accepted solutions back.

SELECT solution_data,is_solution FROM messages WHERE is_solution = true

 

Thanks!

  • VikasB's avatar
    VikasB
    Boss
    8 years ago

    Hope it worked for shong also. 

    • TalendCommunity's avatar
      TalendCommunity
      Ace
      8 years ago

      thanks for you help, it works!