Review Request 122643: Fix support for LIKE operator in Kexi Query Designer

Jarosław Staniek staniek at kde.org
Fri Feb 20 20:44:08 GMT 2015


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://git.reviewboard.kde.org/r/122643/
-----------------------------------------------------------

(Updated Feb. 20, 2015, 8:44 p.m.)


Status
------

This change has been marked as submitted.


Review request for Calligra, Andrius da Costa Ribas, Friedrich W. H. Kossebau, Adam Pigg, Roman Shtemberko, Radosław Wicik, and Wojciech Kosowicz.


Repository: calligra


Description
-------

Fix support for LIKE operator in Kexi Query Designer

- support both LIKE and NOT LIKE
- works well with strings and query parameters [...]
- properly interacts with the SQL view
- existing code refactored so LIKE can be easily added


Diffs
-----

  kexi/plugins/queries/kexiquerydesignerguieditor.cpp 86bc6de6afb604a93ac01425a5cc2c0bc821e2a2 

Diff: https://git.reviewboard.kde.org/r/122643/diff/


Testing
-------

Queries with LIKE and NOT LIKE work in all views.

Example test:
For table foo with column c of text type, try:

SELECT * FROM foo WHERE c LIKE '%a%'

(should show all rows where c contains 'a')

and 

SELECT * FROM foo WHERE c NOT LIKE '%a%'

(should show all rows where c does not contain 'a')

and 

SELECT * FROM foo WHERE c LIKE [Enter filter]

(should show all rows where c mathes the filter specified interactively -- don't forget to prepend/append %)


Thanks,

Jarosław Staniek

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/calligra-devel/attachments/20150220/bc9b765e/attachment.htm>


More information about the calligra-devel mailing list