nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter expression based on a smart multi row field

Demolag

Hi,
I'm having trouble finding the syntax for filtering based on a smart multirow field.

Example:
I have two forms, F1 and F2, while F2 is used as smart multi-row field in F1 (lets name the field "smr").
I want to filter entries from F1 based on if their smr field contains a specific entry from F2.

What syntax should I use?

context: I want to use the queryAndRender function on merger table to show for each F2 entry a list of F1 entries on which their smr field contains a specific F2 entry, but I can't figure out the syntax for filtering based on a smart multi-row field.

 id.queryAndRender(F1:<pageID>;<filter????>;id;table)

Thanks.

Accepted answers

Alex Medved _ConfiForms_

Hi @Demolag

Probably something like this

id:[entry.smr.transform(id).join( OR id:)]

Alex

All comments

Alex Medved _ConfiForms_

Hi @Demolag

Probably something like this

id:[entry.smr.transform(id).join( OR id:)]

Alex

Demolag

I just found the following answer on another thread, but it seems it doesn't work for me:

smr.asFilteredBy(name:[entry.name]).asCount:>0

I'm trying to use the (custom) name field specifically and not id because I have several entries with the same name.

Demolag

Thanks for the response Alex.

Just to clarify,

F1 fields: name_f1(text), smr(smart multi row)
F2 fields: name_f2(text)

MergeTable: name_f2(field), queryAndRender(field), F2(table view)

in this case, wouldn't [entry] refer to the entries from F2?

Alex Medved _ConfiForms_

What is a "MergeTable"? What do you merge?

Demolag

I use it more for using expressions in fields and less for merging two tables (As they are already merged by the Smart Multi Row).
Am I using it wrong?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

data-center

confiforms

confluence-data-center