cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

4 Comments
Tanzanite

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

Newbie

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.

Tanzanite

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.

Tanzanite