Filter rows if one column has empty/null entries

  • 1
  • Problem
  • Updated 2 years ago
I have a scaffold table where users update and overwrite the rows on a monthly basis. On the same page I have a report with returns the changes made, however it can return empty cells if we Edit page and I want to add a filter to remove these entries.

Confluence: 5.7.5
Scaffolding: 8.4.1
Reporting: 6.4.1
Table Filter: 3.3.1


Input Table

{table-data:name=initiative}

||Alliance/Partner||Initiative||Phase||MBO - Status||Activity||Health Status||Stakeholders||Target Completion date||Sales Rev Impact||Consumer Rev Impact||
|
{list-data:atlassian-macro-output-type=BLOCK|name=partner|separator=pipe}
{content-options:labels=directed_partner, alliance|limit=99|parent=GSA:Alliance Partners|spaces=GSA}
{content-options}
{list-data}
|
{list-data:atlassian-macro-output-type=BLOCK|name=initiative|separator=pipe}
{content-options:ancestor=GSA:Alliance Partners|labels=gsap_initiative|limit=99|spaces=GSA}
{content-options}
{list-data}
|
{list-data:atlassian-macro-output-type=INLINE|name=phase}
{list-option:label=Initiation|sortValue=a|value={status:colour\=Green\|title\=Initiation\|subtle\=true}}{status:colour=Grey|subtle=true|title=Initiation}{list-option}

{list-option:label=Discovery|sortValue=b|value={status:colour\=Yellow\|title\=Discovery\|subtle\=true}}{status:colour=Red|subtle=true|title=Discovery}{list-option}

{list-option:label=Plan|sortValue=c|value={status:colour\=Red\|title\=Plan\|subtle\=true}}{status:colour=Yellow|subtle=true|title=Plan}{list-option}

{list-option:label=Build|sortValue=d|value={status:colour\=Red\|title\=Build\|subtle\=true}}{status:colour=Green|subtle=true|title=Build}{list-option}

{list-option:label=Test/Stabilize|sortValue=e|value={status:colour\=Red\|title\=Test/Stabilize\|subtle\=true}}{status:colour=Blue|subtle=true|title=Test/Stabilize}{list-option}

{list-option:label=Deploy|value={status:colour\=Red\|title\=Deploy\|subtle\=true}}{status:colour=Blue|subtle=true|title=Deploy}{list-option}

{list-option:label=Maintain & Iterate|sortValue=f|value={status:colour\=Red\|title\=Maintain & Iterate\|subtle\=true}}{status:subtle=true|title=Maintain & Iterate}{list-option}

{list-option:label=On Hold|sortValue=f|value={status:colour\=Red\|title\=On Hold\|subtle\=true}}{status:subtle=true|title=on hold}{list-option}

{list-option:label=Closed|sortValue=f|value={status:colour\=Red\|title\=Closed\|subtle\=true}}{status:subtle=true|title=closed}{list-option}
{list-data}
|
{list-data:atlassian-macro-output-type=BLOCK|name=mbo|separator=newline}
{report-block:atlassian-macro-output-type=BLOCK}\\
{local-reporter:data:mbolist|source=~taylorr:My MBO List} {local-reporter}

{report-body:injected=true}
{list-option:value=%data:mbolist%} {list-option}

{report-body}

{report-block}
{list-data} 
- {list-data:atlassian-macro-output-type=BLOCK|name=mbostatus}
{list-option:label=Completed|sortValue=c|value={status:colour\=Green\|title\=Completed}}{status:colour=Green|title=completed}{list-option}

{list-option:label=In Progress|sortValue=b|value={status:colour\=Yellow\|title\=In Progress}}{status:colour=Yellow|title=In Progress}{list-option}

{list-option:label=Deleted|sortValue=a|value={status:colour\=Red\|title\=Deleted}}{status:colour=Red|title=Deleted}{list-option}
{list-data}
|
{text-data:atlassian-macro-output-type=INLINE|name=activity}
{text-data}
|
{list-data:atlassian-macro-output-type=INLINE|name=health}
{list-option:label=Green|sortValue=c|value={status:colour\=Green\|title\=Green}}{status:colour=Green}{list-option}

{list-option:label=Amber|sortValue=b|value={status:colour\=Yellow\|title\=Amber}}{status:colour=Yellow}{list-option}

{list-option:label=Red|sortValue=a|value={status:colour\=Red\|title\=Red}}{status:colour=Red}{list-option}
{list-data}

{text-data:atlassian-macro-output-type=INLINE|name=healthdetails}
{text-data}
|
{text-data:atlassian-macro-output-type=INLINE|name=stakeholders}
{text-data}
|
{date-data:atlassian-macro-output-type=INLINE|format=dd/MMM/YYYY|name=due date} {date-data}
|
{list-data:atlassian-macro-output-type=INLINE|name=Sales}
{list-option:label=Yes|sortValue=c|value={status:colour\=Green\|title\=Yes\|subtle\=true}}{status:colour=Green|subtle=true|title=yes}{list-option}

{list-option:label=Influence|sortValue=a|value={status:colour\=Red\|title\=Influence\|subtle\=true}}{status:colour=Yellow|subtle=true|title=Influence}{list-option}

{list-option:label=No|sortValue=a|value={status:colour\=Red\|title\=No\|subtle\=true}}{status:colour=Red|subtle=true|title=No}{list-option}
{list-data}
|
{list-data:atlassian-macro-output-type=INLINE|name=Consumer}
{list-option:label=Yes|sortValue=c|value={status:colour\=Green\|title\=Yes\|subtle\=true}}{status:colour=Green|subtle=true|title=yes}{list-option}

{list-option:label=Influence|sortValue=a|value={status:colour\=Red\|title\=Influence\|subtle\=true}}{status:colour=Yellow|subtle=true|title=Influence}{list-option}

{list-option:label=No|sortValue=a|value={status:colour\=Red\|title\=No\|subtle\=true}}{status:colour=Red|subtle=true|title=No}{list-option}
{list-data}
|
{table-data}

Version History Wiki

{report-table:injected=true}

{local-reporter:content:version history}
{date-sort:content:modification date|order=descending}{boolean-filter:%data:activity>text:is empty%|value=true}{local-reporter}

{report-column:title=Date}
{report-info:content:modification date|format=MMM dd yyyy HH:mm}{report-column}

{report-column:title=Modified By}
{report-info:content:modifier}{report-column}

{report-column:title=Status}
{report-on:data:initiative|atlassian-macro-output-type=INLINE}{report-info:data:phase|render=wiki}{report-on}
{report-column}

{report-column:title=Activities}
{report-on:data:initiative|atlassian-macro-output-type=INLINE}{report-info:data:activity|render=richtext}{report-on}
{report-column}

{report-empty:trim=true}
_No version history available._{report-empty}

{report-table}
Photo of Con

Con

  • 17 Posts
  • 0 Reply Likes

Posted 2 years ago

  • 1

There are no replies.