Hello All,
I have some components generated by seamgen, specifically the EntityQuery Lists
that relate to a list of entity objects. The seam generated search form allows
the restrictions to be passed to the query:
| public class StatusList extends EntityQuery {
|
| private static final String[] RESTRICTIONS =
{"lower(status.description) like concat('%',
concat(lower(#{statusList.status.description}),'%'))",};
| ...
| private Status status = new Status();
|
| @Override
| public String getEjbql() {
| return "select status from Status status order by
status.sortOrder";
| }
| ...
The query works well if no parameters are passed to the restrictions, the list
is returned in the correct order, however if I pass a parameter to the
restrictions clause the predicates of where/order are mixed up and invalid SQL
is executed, which of course produces an error.
What is the correct way to approach this?
Thanks in advance!
MG
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4098380#4098380
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4098380
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
