Lifecycle State - Condition to item picker baseWhereClause

[Rohaan]

Version: Windchill 12.0

Use Case: I have an Item Picker in my JSP Page where it will retrieve all the Change Notices's from specific context. Wanted to filter CN's based on State -> '(state=''IN PROGRESS') || (state='COMPLETE') Tried above condition but its not fetching the results based on State condition

Description:

<tr id="cnPickerRow"><wctags:itemPicker 
		id="CNPicker"
		baseWhereClause="(state='IN PROGRESS')"
		showTypePicker="true" 
objectType="WCTYPE|wt.change2.WTChangeOrder2" 
		componentId="cnPickerID" 
		label="* CN Number" 
		pickerTextBoxLength = "29"
		pickerTitle="CN Number Search" 
		containerRef="<%=coid%>"
		pickerCallback="cnPickerCallback" 
		multiSelect="false"
		displayAttribute="number"/></tr>

[Daniel_Ada]

请尝试使用这个

(state.state='IN PROGRESS')

[vnamboodheri · Accepted solution]

Hello @Rohaan,

It looks like you have a response from a community member. If it helped to answer your question please mark the reply as the Accepted Solution. 

Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.

Thanks,
Vivek N.
Community Moderation Team.