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",
"data" : {
"type" : "error_data",
"code" : 602,
"developer_message" : "",
"more_info" : ""
},
"metadata" : { }
}

 

According to the API V2,

https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collection=solutions_data

I can see the description of solutions_data collection, what's wrong?

 

Regards

Mike

  • 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!

7 Replies

Sort By
  • him_varma's avatar
    him_varma
    Advisor
    8 years ago

    shong

    According to the document that you have mentioned it states that we can fetch attribute "solution_data" from messages. The query will be as below.

    select solution_data from messages

    Which will return the "solution_data" value for all the messages.

    Please give KUDOS and mark as solution if this was helpful

  • shong's avatar
    shong
    Adept
    8 years ago
    Hi him_varma
    Thanks for your reply. I execute the LiQL as you said, it returns the result like this;
    {
    "status" : "success",
    "message" : "",
    "http_code" : 200,
    "data" : {
    "type" : "messages",
    "list_item_type" : "message",
    "size" : 3,
    "items" : [ {
    "type" : "message",
    "solution_data" : { }
    }, {
    "type" : "message",
    "solution_data" : { }
    }, {
    "type" : "message",
    "solution_data" : { }
    } ]
    },
    "metadata" : { }
    }

    No detailed information about solution_data, what's wrong?

    Regards
    Shong
  • VikasB's avatar
    VikasB
    Boss
    8 years ago

    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!