confiform view on records with smart multi row

[Maximilian Herbert]

Hey there,

I have a form that has the identical function as in the example provided on the confiform documentation. (Picture beneath)

It has a field that is a smart multi row (getting the fields of form2).

What I want to know: Is it possible to analyse and visualize the records individually grouped by the data of the smart multi row field.

So referencing the example in the picture I would like to make a table view that shows me every record in which the name of the participant is Alex. 

I know I could just make a view on the data of Form 2 where the records get saved as well but there I have no field that connects the record to the Testname of Form1.
Any ideas or approaches to solve that?
Greetings Max

[Alex Medved _ConfiForms_ · Accepted solution]

You can have a filtered data, yes

Multiple options and expressions.. for example using this as a filtering expression

participants.asFilteredBy(Name:Alex).asCount:>0

Re: Based on the forms configured in this tutorial

Alex

[Maximilian Herbert]

Is this working when I put it in the Table view of the "testsForm" from the example you linked?
Or do I have to put it in a Tableview on the participantsForm ?

[Alex Medved _ConfiForms_]

Yes, that is the filtering expression to put over the views that are configured over the "testsForm"

Alex

[Maximilian Herbert]

It seems like this is not working for me... But I am not sure if Im missing something. 

Main Form = CRCTest

Second Form (for Multi Row input) = OS 

(I hope it is okay if I add the Source Code here.. Probably its easier to find a solution then.)

<p class="auto-cursor-target">
<br/>
</p>
<ac:structured-macro ac:macro-id="cf75128c-6851-4fc4-bc04-acb636b91484" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">CRCTest</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="f8f9b10c-81c3-4899-8888-b65c064cf871" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">PName</ac:parameter>
<ac:parameter ac:name="fieldLabel">PName</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="56d67033-5baa-45a0-94d2-be6023468675" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">participants</ac:parameter>
<ac:parameter ac:name="fieldLabel">participants</ac:parameter>
<ac:parameter ac:name="values">[324136445:OS]Amount,Size,Typ,</ac:parameter>
<ac:parameter ac:name="extras">table</ac:parameter>
<ac:parameter ac:name="type">smartmultirow</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<ac:structured-macro ac:macro-id="181b58ca-bfc4-415d-8bdb-f5b1575241c7" ac:name="confiform-entry-register" ac:schema-version="1">
<ac:parameter ac:name="formName">CRCTest</ac:parameter>
<ac:parameter ac:name="type">Embedded</ac:parameter>
<ac:parameter ac:name="regControlLayout">true</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="a4290318-0f79-4f38-9844-768827d17460" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">PName</ac:parameter>
<ac:parameter ac:name="withLabel">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="4208268c-3fd5-4a25-9dcf-c0bd642adb61" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">participants</ac:parameter>
<ac:parameter ac:name="withLabel">true</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<br/>
</p>
<ac:structured-macro ac:macro-id="7997be99-41ab-448e-8190-eb2afa587de3" ac:name="confiform-table" ac:schema-version="1">
<ac:parameter ac:name="filter">participants.asFilteredBy(Typ:Windows).asCount:&gt;0</ac:parameter>
<ac:parameter ac:name="enableFilterSupport">true</ac:parameter>
<ac:parameter ac:name="formName">CRCTest</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<br/>
</p>

[Maximilian Herbert]

-

[Maximilian Herbert]

Unfortunatly this is not working for me somehow.. I guess im missing something.

When I put in the filter it still shows every record with every subrecord.

The first record (Test1) should only contain the line with amout 4, size XL, Typ Windows with that filter applied.

[Alex]

What field type is your “Size” field?

[Maximilian Herbert]

Size is a Text field
Amount is Numeric

Typ is Dopdown

[Maximilian Herbert]

So I took over the example with the participants now 1:1 and made a table view with the filter. Again every record, and every name shows up. Is there something I need to additionally configure / take care of in the field defintions / in the form definitions? 

[Alex Medved _ConfiForms_]

Hard to tell - this is working for me just fine.

Share your complete configuration and may be we can spot the issue

[Maximilian Herbert]

How can I share the configuration? You mean the full Storage Format?

[Maximilian Herbert]

I dont know why but now it is working perfectly fine. I didnt change anything to the Configuration. Maybe it was kind of a "bug"?

Just have a Tableview Merger that flattens the entries and then applied the filter created exactly the view i needed.
Thanks tho for the support again Alex!