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 Matrixview - Can the grouped filed with 0 record be hidden from the left menu?


I am using Confiforms MatrixView to filter records in a form named as f grouped by filed f1 with filtered data (f2:2).

My question is that is there any way that I can only show f1 that have records associated. In the example below, when f2:2, f1 only has 2 records 2 & 3. However, the left menu shows all f1s anyway. Is it possible to only show 2 & 3 on the left menu?








2 answers

1 accepted

0 votes
Answer accepted

Of course you should not have a limit parameter. 

the TableView inside should be showing what exactly? May be you need to have a dynamic filter for it?



I will try the dynamic filter then. Thank you, Alex.

The table view inside shows the data filtered by the checked value on the left menu. If I don't set the limit parameter, the tableview is duplicated for n times depending on n items are showing on the left menu.

Hi @Patrick Liang 

The values you can see on the right are only the ones that ARE available in the form

So, there must be the value 1 in your dataset for field f1

(unless it is a select/radio group or multi-value field)


Hi Alex, 

Value f1:1 is in the database but I have the filter applied to the matrix view and the table view with f2:2 so the first record on the screenshot (f1:1 & f2:1) is filtered to be hidden.


In this case is there anyway to not show f1:1 on the menu? (since the tableview to the right doesn't have anything with f1:1 based on the filtered data.




Yes, there is an option in the macro parameters to show only “relevant options”. You need to enable that


Thank you again for your prompt response. I tried "relevant options" as well.

However, it will only show one checkbox (2 in the example below) instead of both 2 & 3 because that I limit the number of the records to be returned, which is needed for the tableview to only show once.

If I remove the limit 1 from the matrixview, then the tableview will show twice as shown on the screenshot below.

How can I show the checkboxes to the left without duplicating the tableview to the right?







Suggest an answer

Log in or Sign up to answer

Atlassian Community Events