I am trying to use a filter tag in combination with a LIKE statement (Oracle database). Where I am having trouble is with wildcard searches.
I have looked at both the example and the documentation and I am still confused...
The example shows only a LIKE which is used in a full search ( n LIKE ?). I can get wildcard searches running by having the user input the search criteria along with the appropriate % character. I don't like this technique very much!
After having read the documentation both in the source code and in the guide, I understand that I should be able to add the % characters within the FilterCondition tag. Unfortunately, when I do this, I get a ORA-01006: bind variable does not exist. Here is my code:
<db:filter>
<db:filterCondition label="Name starts with:">
name like '%?%'
<db:filterValue type="text" label="nameLike"/>
</db:filterCondition>
</db:filter>
Has anybody got this working?
