Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Confiforms: Need Help with nested asFilteredBy (smart multi-selects)

Assume I have three forms: Customers, Cars, Insurance.

In Customers, I have fields "customerName" (string) and "customerCars" (smart multi-select to Cars)

In Cars, I have fields "carName" (string) and "carInsurances" (smart multi-select to Insurances)

In Insurances, I have fields "insuranceName" (string) and "insuranceStatus" (dropdown 1:active, 0:inactive). 

Now, what I would like to do is create a TableView on "Customers", that

(1) Shows only customers that have at least one car with at least one active insurance.

(2) has a column "insuredCars" showing only the cars of that customer that have active insurance.

For (1), I can solve this by using the filter "!customerCars.carInsurances.asFilteredBy(insuranceStatus:1):[empty]", or what I also found working, but less intuitive: "customerCars.carInsurances.insuranceStatus:*1*"

For (2), I am somewhat out of ideas. I believe it could be possible with "asFilteredBy". So, I would suspect to start with customerCars.asFilteredBy(...)? Is that the right direction?


Every input on the problem would be very appreciated.


2 answers


Let me try to help you here... But this one is very tricky as it has multi-value having another multi-value field and those are not simple values, but the smart fields... so

So a "view" over "Customers" form with the filter expression to be something like


Hope it helps


0 votes
Srinatha T Atlassian Team Jul 25, 2022

Hi @Jan Sürmeli ,

Welcome to community. 

I would recommend you to write to Coniforms support also as they might have a solution handy for you. 

Mean while if any of our community members are aware of this , they will also try to help here. 

Have a good day!


Srinath T

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events