topic Re: Lifecycle State - Condition to item picker baseWhereClause in Windchill Customization

Lifecycle State - Condition to item picker baseWhereClause

Rohaan — Tue, 05 Nov 2024 04:10:32 GMT

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>

Re: Lifecycle State - Condition to item picker baseWhereClause

Daniel_Ada — Wed, 06 Nov 2024 03:48:26 GMT

请尝试使用这个

(state.state='IN PROGRESS')

Re: Lifecycle State - Condition to item picker baseWhereClause

vnamboodheri — Tue, 12 Nov 2024 05:40:05 GMT

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.