You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
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
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!