For example, if I have forms: * F1* name1: Smart Dropdown from F2 * info: Text * F2* name2: Text and I want to make a TableView with the following: * F2.name2 * table of unique F1 info values where name1==entry.id. I tried the following, but it seems it doesn't seem to work: id.queryAndRender(F1:@self;name1:[entry.id];info;table).uniqueBy(info) Is it possible to distinct filter a queryAndRender tableview?

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; } } }

Can queryAndRender function be distinct filtered to show unique results only?

Demolag

For example, if I have forms:

F1
- name1: Smart Dropdown from F2
- info: Text
F2
- name2: Text

and I want to make a TableView with the following:

F2.name2
table of unique F1 info values where name1==entry.id.

I tried the following, but it seems it doesn't seem to work:

id.queryAndRender(F1:@self;name1:[entry.id];info;table).uniqueBy(info)

Is it possible to distinct filter a queryAndRender tableview?

Accepted answers

Alex Medved _ConfiForms_

What should be unique? The value in the “info” field?

All comments

Alex Medved _ConfiForms_

What should be unique? The value in the “info” field?

Demolag

yea

Demolag

a possible solution I thought of would be using an expression instead of a field on the fields list:

queryAndRender(<formName:pageId>;<FILTER>;<FIELDS_OR_EXPRESSIONS>;<VIEW_TYPE>)

but for some reason it doesn't recognize expressions when I put them there.
Am I missing something regarding the usage of that function?

Whenever I try to put an expression there, no matter how simple the expression is, it just render the whole table, ignoring the fields.

Alex Medved _ConfiForms_

What expressions "it doesn't recognize "?

Alex Medved _ConfiForms_

No, not with the queryAndRender

I think you will need to have something like a ListView with a nested and dynamically filtered TableView/CardView (where you can use distinct parameter)

Demolag

for example, I tried to put info.asCount() just to test it out also ([_count]), ([entry.)_count]) (_count).

queryCount doesn't fit there at all since there is a semicolon in it.

Demolag

Thanks

but how would you configure that?
If I make the ListView for F2 and the nested TableView for F1, it won't show F2 values which are not used in F1.

Demolag

I've seen now on another question that it is bugged on older versions of confiform.

Welcome!

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

Quick Links

Find more posts tagged with

confluence

data-center

addon-com.vertuna.confluence.plugins.confiforms

confiforms

confluence-data-center