Loading Profile...
How do you use text-filter to report on only those records that match?
I want to use text filter to select records to report on. In this example I only want to report the records where Role-delivery = Service Director
{report-table}
{text-filter:data:Role-delivery|include=Service Director|required=true/false}
{local-reporter:data:ValueFlows}
{report-column:title=From}{report-info:data:Role-delivery}{report-column}
{report-column:title=To}{report-info:data:Role-receiving}{report-column}
{report-column:title=Deliverable}{report-info:data:Deliverable}{report-column}
{report-column:title=Description/Example}{report-info:data:Description/Example}{report-column}
{report-column:title=Tangible or Intangible}{report-info:data:Tangible or Intangible}{report-column}
{report-column:title=Cost/Risk to deliver}{report-info:data:Cost/Risk to deliver}{report-column}
{report-column:title=Potential value received}{report-info:data:Potential value received}{report-column}
{report-column:title=Current Performance}{report-info:data:Performance}{report-column}
{report-table}
This still reports all the records except in the "From" column I get a blank field when Role-delivery is not Service Director
Doesn't make any difference if I put the text-filter before or after local-reporter.
{report-table}
{text-filter:data:Role-delivery|include=Service Director|required=true/false}
{local-reporter:data:ValueFlows}
{report-column:title=From}{report-info:data:Role-delivery}{report-column}
{report-column:title=To}{report-info:data:Role-receiving}{report-column}
{report-column:title=Deliverable}{report-info:data:Deliverable}{report-column}
{report-column:title=Description/Example}{report-info:data:Description/Example}{report-column}
{report-column:title=Tangible or Intangible}{report-info:data:Tangible or Intangible}{report-column}
{report-column:title=Cost/Risk to deliver}{report-info:data:Cost/Risk to deliver}{report-column}
{report-column:title=Potential value received}{report-info:data:Potential value received}{report-column}
{report-column:title=Current Performance}{report-info:data:Performance}{report-column}
{report-table}
This still reports all the records except in the "From" column I get a blank field when Role-delivery is not Service Director
Doesn't make any difference if I put the text-filter before or after local-reporter.
1
person has this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
-
Inappropriate?The {text-filter} has to be inside the {local-reporter} in order to filter the whole set of results. Otherwise, it is just filtering the next {report-column} (in this case the 'From' column).
Also, 'required' should be either 'true' or 'false', not the 'slash' combo. But in this case you don't need it anyway.
Try this:
{report-table}
{local-reporter:data:ValueFlows}
{text-filter:data:Role-delivery|include=Service Director}
{local-reporter}
{report-column:title=From}{report-info:data:Role-delivery}{report-column}
etc...
{report-table}
-
Inappropriate?Tks for the prompt reply David. I had put the text-filter in both places but it seems the second {local-reporter} after the text-filter is what has made the difference.
I’m happy
EMPLOYEE
