jannaton
|
| Posted: 07/29/2002, 6:46 PM |
|
I want to use the postgresql function 'ilike' which is non case sensitive.
It does not appear in the drop down list selection in Data Source/Parameters - Conditions whereas contains(like'%..%') does. So do I access the function???
On the same note: how do regular expressions work in CCS.
I basically want to use '~*' to do a similar search as above but do not know how to pass the users search para(URL) to it. So my question is how to incorporate regular expressions into search parameters.
|
|
|
 |
Ron
|
| Posted: 07/31/2002, 4:18 AM |
|
Hello,
About ilike operation.
You can add custom part to Where clause via Table Parameters dialog. Just select Expression from Condition Type and type in the condition like:
project_name like '%". CCGetParam("s_project_name") . "%'
It is example for parameter passed through URL.
|
|
|
|
jannaton
|
| Posted: 07/31/2002, 5:32 PM |
|
Thanks for the tip!!
Worked fine.
Just a small addition, the CCGetParam function askes for a second argument as the default value so just add an empty string as default to correct it.
(project_name ilike '%". CCGetParam("s_project_name","") . "%'
|
|
|
|
|
