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

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.

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

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.