Skip to main content
Rohaan14-Alexandrite
14-Alexandrite
Nov 5, 2024 4:08 AM UTC
Solved

Lifecycle State - Condition to item picker baseWhereClause

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>

 

 

vnamboodheriAnswer
Emeritus
Nov 12, 2024 5:40 AM UTC

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.

View in thread

2 replies

Daniel_Ada13-Aquamarine
13-Aquamarine
Nov 6, 2024 3:45 AM UTC

请尝试使用这个

 

(state.state='IN PROGRESS')

 

 

Translate
    vnamboodheriEmeritusAnswer
    Emeritus
    Nov 12, 2024 5:40 AM UTC

    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.

    Translate
    Terms & ConditionsAccessibility statement