Not understanding how to use EJBQL in a regular expression using Seam

[mikjall77]

I'm trying to look for two values within a column using EJBQL and a regular expression using a radio button. I am able to find single values but more than that I'm having problems. My working code for the single values are:

"personData.status in (#{personSortDataList.statusChoice == 'A' ? "
     + "personSortDataList.statusChoice : null})", 
             

"personData.status in (#{bullSortDataList.statusChoice == 'I' ? " 
     + "personSortDataList.statusChoice : null})", 

The personSortDataList is my session bean, statusChoice is a Character type with a getter and setter, and personData is my entity bean.

For my main problem, my code that I been trying to make work is:

"#{personSortDataList.statusChoice == 'B' ? " 
     + "(personData.status in ('A', 'I')) : null}",

along with several other tries.

My code from my .xhtml page is:

<h:selectOneRadio layout="lineDirection" 
   value="#{bullSortDataList.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>

Any help with this is greatly appreciated!

[lvdberg]

Hi,

have you (1) tried to solve this directly with an EntityQuery in components.xml and (2) how do you trigger additional searches. You should have ajax involved, or do you use a manual submit ?

Leo

[mikjall77]

Thanks for the reply Leo!

We use a manual submit (although on another part of the page, I will be using ajax but feel it's not needed for this part as it.) I have not tried to solve directly with components.xml and not sure if it's feasible. Thanks for the idea though! I think I may try this and it also may prove useful with another problem we're having with another component.

Thanks again!

Mike

[mikjall77]

My coworker found a solution:

"not (personData.status not in (#{personSortDataList.statusChoice == 'B' ? " 
    + "'A' : null})",
                       
"personData.status not in (#{personSortDataList.statusChoice == 'B' ? " 
    + "'I' : null}))",

Which, as of now, works great!