Document report - using text mode for owner team name

Question

I have a document report set up to list documents. It is filtered to show documents within a specific folder (text mode from this post: Document Report to Identify Number of Files in a Specific Folder) and project status is set to planning and current : folders:name=final
folders:name_Mod=cicontains
project:status=CPL	CUR
project:status_Mod=inWhich works, but it shows ALL documents in ALL projects.I need an extra filter to show owner home team. In another document report, I have project status set to planning and current and also filtered by owner home team:owner:homeTeamID=abc123
owner:homeTeamID_Mod=in
project:status=CPL	CUR
project:status_Mod=inThis also works but doesn't show me the file I want in the specific folder, as per first example. When I put the text mode together, i.e.:owner:homeTeamID=abc123owner:homeTeamID_Mod=inproject:status=CPL CURproject:status_Mod=infolders:name=finalfolders:name_Mod=cicontains I get nothing showing up. Where am I going wrong? Thank you for any help

skyehansen · Accepted Answer

Sorry, I think I am confusing myself. Using the first text mode, I added in the extra column you suggested which helps. I can work with this report but would now like to filter or show in column by project owner or even owner home team. I am not sure if this is possible.

it looks like you already know the text mode to change the ID to a name. I see a "project | owner ID" column you can pull in and do exactly that same thing.

Then, once you have it working, just copy the column and where you have the ":name" make it a ":homeTeam:name" instead.

skyehansen · Answer

In your first report, can you put one more column into the view? Add the owner's home team ID as a column.

Once the results come up, just check and see if any of the home team IDs are "abc123".

If there are line items where the home team IDs are abc123, there's something wrong with your code. If no line items exist, then there's nothing wrong with your code.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded