I'm trying to come up with an Expression that will find two values within a column. I'm using JBoss 4.2.2, JSF 1.2, RichFaces 3.3.
In these two single examples:
"personData.status in (#{personSortDataList.statusChoice == 'A' ? "
+ "personSortDataList.statusChoice : null})",
"personData.status in (#{personSortDataList.statusChoice == 'I' ? "
+ "personSortDataList.statusChoice : null})",
It works great. When I try to combine them:
"#{personSortDataList.statusChoice == 'B' ? "
+ "(personData.status in (A, I) : null})", // Done this several different ways
I can't figure out what type of expression to use to pull in both A and I. These queries are attached to h:selectOneRadio:
<h:panelGrid columns="2">
<b>#{messages['Status']}: </b>
<h:selectOneRadio layout="lineDirection"
value="#{personSortDataList.statusChoice}">
<f:selectItem itemLabel="#{messages['Active']}" itemValue="A" />
<f:selectItem itemLabel="#{messages['Inactive']}" itemValue="I" />
<f:selectItem itemLabel="#{messages['Active and Inactive']}" itemValue="B" />
</h:selectOneRadio>
</h:panelGrid>
For the bean, I have (other than the queries):
@Name("personSortDataList")
public class PersonSortDataList extends EntityQuery<PersonData>
{
private static final long serialVersionUID = 1L;
...
private Character statusChoice;
...
private static final String EJBQL = "Select personData From PersonData personData";
private static final String[] RESTRICTIONS =
{
...
"personData.status in (#{personSortDataList.statusChoice == 'A' ? "
+ "personSortDataList.statusChoice : null})",
"personData.status in (#{personSortDataList.statusChoice == 'I' ? "
+ "personSortDataList.statusChoice : null})",
"#{personSortDataList.statusChoice == 'B' ? "
+ "(personData.status in (A, I) : null}",
...
};
public CIMinMax ciMinMax;
public CIMinMax getCiMinMax()
{
return ciMinMax;
}
public void setCiMinMax(CIMinMax ciMinMax)
{
this.ciMinMax = ciMinMax;
}
private PersonData personData;
public PersonSortDataList()
{
personData = new PersonData();
personData.setId(new PersonDataId());
ciMinMax = new CIMinMax();
setEjbql(EJBQL);
setRestrictionExpressionStrings(Arrays.asList(RESTRICTIONS));
setMaxResults(Integer.valueOf(300));
}
public PersonData getPersonData() {
return personData;
}
public void setPersonData(PersonData personData) {
this.personData = personData;
}
@Override
protected String getCountEjbql()
{
setUseWildcardAsCountQuerySubject(true);
return super.getCountEjbql();
}
...
public void setStatusChoice(Character statusChoice) {
this.statusChoice = statusChoice;
}
public Character getStatusChoice() {
return statusChoice;
}
}
Any help is greatly appreciated!
