Query Builder report - Need to fetch Reults specific to Context where the Report is viewed from

[Rohaan]

Version: Windchill 12.0

Use Case: I have created a custom Report template at ORG level, this query builder report will generate results for all Problem Reports which were "COMPLETED" in past 7 days,

Description:

I have also exposed this template as Reports in Library context, but when I run the report in any Library context, it gives me results from every context and not specific to the Library context where I am running this from.

Is there any way I can specify context specific search based on where I execute this report from?

[Marco_Tosin]

What you did was make a report, created at the organization level, visible in every single library.

This way, there is no context filter that needs to be created by adding the context table and linking it to the Problem Reports table and MANUALLY selecting the context you want the search to be performed on.

Something like what you see in the image below.

[joe_morton]

I haven't done this myself, but what comes to mind are the Macros in Query Builder. There's a default Macro for CURRENT_USER_NAME that you can use in a report so that it returns data for the user running the report. See: https://wctest.magicleapsystems.net:2443/Windchill-WHC/en/#page/Windchill_Help_Center/querybuilder/QBMacros.html#

Maybe there's a way to make a custom macro to do similar to detect the context where the report is being run from. It looks like it could be possible, but customization would be needed: https://www.ptc.com/en/support/article/CS260538?source=search

[vnamboodheri]

Hello @Rohaan, 

It looks like you have some responses from our community experts. If any of these replies helped you solve your question please mark the appropriate 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.