cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

Translate the entire conversation x

Add condition to item picker baseWhereClause

Manoj_Dokku4
14-Alexandrite

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"/>

 

 

 

 


@HelesicPetr 

2 REPLIES 2

Hi Manoj_Dokku4,

Thank you for your question. 
I’d like to recommend to bring more details and context to your initial inquiry

It also helps to have screenshot(s) to better understand what you are trying to do in your process. 

This will increase your chances to receive meaningful help from other Community members. 

Regards,

Community Moderation Team.

Hi @Manoj_Dokku4 

You can try 

<jca:setComponentProperty key="baseWhereClause" value="(IBA|CISLO_VYK='yourValue')"/>

PetrH

Announcements
Top Tags