Get your own customer support community
 

How to filter dynamically on a many-to-one basis?

I have some pages that I would like to link together using their respective scaffolding data with Reporting.

In page 1 I have a form which, among other information, allows the user to enter a Type. It can be Type A or B or C or D (only one though).

On page 2 I have a form which, among other information, allows the user to enter a Type. It can be Type A and/or B and/or C and/or D (multiple may be selected).

At the bottom of page 1, I show which page 2s match this page's Type by using a collection text-filter on Page 1's Type and where they match on Page 2's multiple selection Type.

For example:


{replace-and-render}
{replace-item:%type%}{get-data:instrumentType}{replace-item}
{replace-body}
{report-table}
{local-reporter:content:children|source=Analysis}
{collection-filter:data:applicableIssueType|matchItems=any}
{text-filter:reference:value|include=%type%}
{collection-filter}
{text-sort:content:title}
{local-reporter}
{report-column:title=Data Attribute|width=250px|link=true}{div:style=font-size:8pt}{report-info:content:title|link=true}{div}{report-column}
{report-table}
{replace-body}
{replace-and-render}


This works fine.

What I'm struggling with is doing it the other way around.

So, at the bottom of Page 2 (where the user can select multiple Types), I want to show where any of the Types they have selected matches with any Page 1s. Is it possible to iterate around the multiple types selected in Page 2, using replace and render or do I need to create multiple reports or is this an {expanding-report} (which I'm still trying to get my head around)?

Thanks in advance.
M
 
indifferent I’m nervous about the answer
Inappropriate?
1 person has this question

User_default_medium