The PTC Community email address has changed to firstname.lastname@example.org. Learn more.
What is the 'IN' operator for if you can not create a list of legal values?
Default value can only be one single value, even a sub-select will just be considered with the first returned value of the select.
Business Case (here): confine the possible values selectable during report generation for objects attribute "State".
take a look at this document Resource for reporting
In it you can find, as attachment, a presentation from PTC that, among other things, explain how to use more than one value for an attribute (see page 56 and following).
Thx for your answer and the link. I knew this valuable resource for reporting alright. Thx for this.
I already tried out what is described on page 56ff but it is not working in 10.2 M030
If you add multiple conditions ....
.... you end up with multiple lines in the report excluding each other, so not finding anything.
And as described in my inital post using a sub-select only the first value will be considered in the report instead of all values returned by the sub-select.
the behavior you have described in the second image started from version 10.0
Before Windchill 10.0, one of the purposes of criteria was to obtain filters.
This is no more necessary.
From Windchill UI you can search an attribute more times with different value.
Try to do the same things with query builder by selecting the same attribute more than once.
And maybe you can vote up this idea IBA columns are not available for search results view if different types have been chose for advanced search
We are archiving your idea as part of a general review. This action is based on the age of your idea and the total number of votes received, as per this announcement.
You can always post a new idea with all the details required in the form.
Thank you for your participation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.