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,363,588
Community Members
 
Community Events
168
Community Groups

Confiforms Matrixview - Can the grouped filed with 0 record be hidden from the left menu?

Hello, 

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?

 

Thanks,

Patrick

 

Capture1.PNG

 

Capture.PNG

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?

 

Alex

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)

Alex

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.

 

Thanks,

Patrick

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

Alex

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?

 

Thanks,

Patrick

 

 

Capture3.PNGCapture4.PNG

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events