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

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

Avatar

1 badge earned

Collect

Participate in fun challenges

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

Challenges
Coins

Gift kudos to your peers

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

Recognition
Ribbon

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!

Leaderboard

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
4,465,051
Community Members
 
Community Events
176
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

Hi

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

customerCars.transform(carInsurances.transform(insuranceStatus.id).asList):*1*

Hope it helps

Alex

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. 

https://marketplace.atlassian.com/apps/1211860/confiforms-data-forms-workflows?hosting=cloud&tab=support 

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

Have a good day!

Thanks,

Srinath T

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events