cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The PTC Community email address has changed to community-mailer@ptc.com. Learn more.

Report Builder: Allow more than one default value for parameters in where clause using 'IN' operator

Report Builder: Allow more than one default value for parameters in where clause using 'IN' operator

Status: Archived Submitted by 1-Newbie on ‎Jul 28, 2015 07:55 AM
5 Comments (5 New)

in_op.jpg

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".

See more ideas labeled with:
5 Comments
Marco_Tosin
20-Turquoise
20-Turquoise
‎Jul 28, 2015 08:06 AM
‎Jul 28, 2015 08:06 AM

Bertram,

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).

Marco

kallheinz
1-Newbie
1-Newbie
‎Jul 28, 2015 08:45 AM
‎Jul 28, 2015 08:45 AM

Hi Marco,

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 ....

sc3.png

.... you end up with multiple lines in the report excluding each other, so not finding anything.

sc1.jpg

sc2.jpg

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.

Marco_Tosin
20-Turquoise
20-Turquoise
‎Jul 28, 2015 09:03 AM
‎Jul 28, 2015 09:03 AM

Bertram,

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.

Marco_Tosin
20-Turquoise
20-Turquoise
‎Jul 28, 2015 09:13 AM
‎Jul 28, 2015 09:13 AM

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

olivierlp
Community Manager
Community Manager
‎Jan 05, 2022 11:20 AM
‎Jan 05, 2022 11:20 AM
Status changed to: Archived

Hello,

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.