Hi,
I was wondering is it possible to do something like the following. Basically i want to exclude a set of id's from the result
// get a 604 response
SELECT * FROM messages WHERE id != '1'
// couldn't find anything in the docs that support this
SELECT * FROM messages WHERE id NOT IN ('1, '2')
Cheers
benassi -
Not operator is not supported in lithium LIQL. You need to check using freemarker <#if> <#else> condition.
Thanks for the quick response.
I don't know alot about LIQL, freemarker but this needs to be called via the API from an external source.
Am i correct that freemarker wouldn't work in this scenario?
Cheers
benassi -
Yes, freemarker wouldn't work in this scenario. However, this can be done in any language.
e.g you need to fetch messages expect 13.
SELECT * FROM messages
if( msg.id != 13){
//Do something here
}Also, if this case is only for few messages e.g 10,20. You can use where in query.
SELECT * FROM messages where id in ('1','2','3' and so on)
Thanks Tariq,
Unfortunately doing that select (SELECT * FROM messages) would not be performant as we'd have to pull down all messages and then query. Might have to look at importing the data from community periodically instead and then do our queries.
Cheers
