String comparison by SQL query

[Kasia K]

Hi guys!

Since few last days I'm wondering if there is a possibility to check by executing sql query whether string expression does not contain only a part of the another string instead of giving the full string value. I'm trying to exclude those elements from the collection.

For example I have:

String title = "abcdefg";

1) Select * from collection where (title not in ('cde') - I would like to filter out this element

2) Select * from collection where (title not in (' abcdefg') - It works but in my case user can fill in only a part of the string.

By using CQNParser query like: not(contains(element,value)) it works perfectly but in my case it would be much easier to use sql.

Cheers!

Kasia

[Niall Gallagher]

If I understand correctly, you could use SQL LIKE for this. Maybe try that and let me know if you have problems.

Best regards,

Niall

--
-- You received this message because you are subscribed to the "cqengine-discuss" group.
http://groups.google.com/group/cqengine-discuss
---
You received this message because you are subscribed to the Google Groups "cqengine-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cqengine-discu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/cqengine-discuss/a72dc8c8-753c-45f1-a1e7-de03f0cfdcd2n%40googlegroups.com.

[Kasia K]

What I need is to apply NOT LIKE query from sql.

As you suggested, like query won't work because it will return too many records.

I would expect for qiven values

title "abcde"

title "fghij"

receive only second value like during query

Select * from collection where title NOT LIKE '%cde%'

[Niall Gallagher]

Can you try:

NOT (title LIKE '%foo%')

I think the SQL parser will prefer that, rather than this:

title NOT LIKE '%foo%'

To view this discussion on the web visit https://groups.google.com/d/msgid/cqengine-discuss/52a2d2d5-65b6-4501-b00b-ef7ee98ca40an%40googlegroups.com.

[Kasia K]

Great, it works!

Thanks a lot Niall!