Skip to main content
D
DH_91668617-Bedrock
7-Bedrock
December 2, 2022
Solved

Product Tasks 'and' condition filter

  • December 2, 2022
  • 8 replies
  • 2328 views

Hello,

 

Wondering if anyone knows if it's possible via a wildcard or otherwise to filter 'product tasks' for specific 'and' conditions on tasks.

 

Currently using the product tasks section to get a live overview of change tasks that are open and who they are sat with.  Currently this gives an overview of the whole project but I was hoping I could filter this down to be able to have specific views for certain teams within a department.

 

So like the below, this would show me the required output for Joe Bloggs, but how could I add John Smith and others to this report to be able to filter on a smaller group of individuals?

 

DH_9166861_0-1669976875324.png

 

Any help much appreciated.

 

Regards

 

 

Daniel

 

Best answer by DH_9166861

Thank you all.

 

In the end my colleague identified continuing the use of 'Not equal to' for the assignee group also.

 

Unfortunately we have quite a large engineering community so quite a few names to populate but the outcome gives me the change related items I'm looking for as a live view.

 

 

8 replies

MarcoTosin
MarcoTosin21-Topaz I
21-Topaz I
December 2, 2022

You can use a report query builder.

 

I have a complete one for all the objects related to the changes.

 

It is quite complex and also has several attributes with text in Italian (but they should be easily translatable to find the names used in Windchill)

 

Below you can see the diagram of the used tables, joins and outer joins (to extract data even if one of the tables does not return any data with the imposed conditions).

 

Some tables are used multiple times to extract user names.

 

I may share it but you can hardly import it into your system without errors.

 

Marco_Tosin_0-1669978328126.png

 

These are the used criteria

 

Marco_Tosin_1-1669978566501.png

 

 

Marco
    D
    DH_91668617-BedrockAuthor
    7-Bedrock
    December 2, 2022

    Thank you Marco,

     

    I have a feeling we don't have the report query builder module, or atleast it's not accessible at woring level and may be more centrally controlled by our IT team.  I'll investigate further though so thanks again for the input.

     

    Regards

     

     

    Daniel

    S
    shussaini16-Pearl
    16-Pearl
    December 2, 2022

    You can also use the Reporting resource page in case you are new to Windchill Reporting.

     

    hope that helps.

     

    regards
    ~Syed

    joe_morton
    joe_morton18-Opal
    18-Opal
    December 6, 2022

    You could also look into making saved searches. 

    D
    DH_91668617-BedrockAuthorAnswer
    7-Bedrock
    January 9, 2023

    Thank you all.

     

    In the end my colleague identified continuing the use of 'Not equal to' for the assignee group also.

     

    Unfortunately we have quite a large engineering community so quite a few names to populate but the outcome gives me the change related items I'm looking for as a live view.

     

     

    Terms & ConditionsAccessibility statement