Question
Add condition to item picker baseWhereClause
I have an item picker in my JSP Page where it will retrieve all the plans from all the contexts.
Wanted to filter all the plans based on 2 attributes.
lets say
Attribtue1 is having string value as "COMPLETED".
Attribute2 is having array of values like {"value1","value2","value3","value4"....}
Written a condition for Attribute1 where I'm able to get all the Plans with Attribute1 value as "COMPLETED".
Need help in writing for condition2 where
I'm searching for all plans which holds "value2" in its array of values of Attribute2.
<wctags:itemPicker
id="planPicker"
baseWhereClause="(Attribute1='COMPLETED') & (<???Condition2???>)"
showTypePicker="false"
objectType="WCTYPE|com.ptc.projectmanagement.plan.Plan|org.ProjectPlan"
componentId="IdPicker"
searchResultsViewId="testPicker.view"
label="* Project Number"
pickerTitle="Plan Picker"
pickerCallback="PickerCallback1"
displayAttribute="Attr1,Attr2,Attr3"/>