You need to sign in to do that
Don't have an account?
unable to get data from SOSL query on Knowledge Objects
hi,
i am trying to retrieve the search result data but i always end up with some exception
query1:
FIND 'map*' IN ALL FIELDS RETURNING Developer__kav (id)
Compile Error: line 1, column 14: Implementation restriction: When querying or searching the Developer__kav object, you must filter using the following syntax: Id = [single ID], Id IN [list of ID's] or PublishStatus = [status]. In addition PublishStatus is only permitted in a top-level AND condition.
now i have added the PublishStatus='Online'
query2:
system.debug([FIND 'map*' IN ALL FIELDS RETURNING Developer__kav (id) where PublishStatus='Online' ]);
Compile Error: line 1, column 70: expecting right square bracket, found 'where'
i have configured my sandbox demo in the eclipse and tried to access the data from the article object
but i get this error
unable to open SchemaBrowser.
Reason:Malformed_query - Implementation restriction: When querying or searching the Developer__kav object, you must filter using the following syntax: Id = [single ID], Id IN [list of ID's] or PublishStatus = [status]. In addition PublishStatus is only permitted in a top-level AND condition.
please help me fix this
Put the "Where" Clause on the inside of the parenthesis. So, like this:
FIND 'map*' IN ALL FIELDS RETURNING Developer__kav (id where PublishStatus='Online')
All Answers
Put the "Where" Clause on the inside of the parenthesis. So, like this:
FIND 'map*' IN ALL FIELDS RETURNING Developer__kav (id where PublishStatus='Online')
thanks a lot it worked :)