Skip to main content
R
Rohaan14-Alexandrite
14-Alexandrite
November 5, 2024
Solved

Lifecycle State - Condition to item picker baseWhereClause

  • November 5, 2024
  • 2 replies
  • 716 views

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>

 

 

Best answer by vnamboodheri

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.

2 replies

D
Daniel_Ada13-Aquamarine
13-Aquamarine
November 6, 2024

请尝试使用这个

 

(state.state='IN PROGRESS')

 

 

    V
    vnamboodheriCommunity ManagerAnswer
    Community Moderator
    November 12, 2024

    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.

    Terms & ConditionsCookie settingsAccessibility statement