How to sort grouping dataset within ConfiForms MatrixView

Markisio December 17, 2022

I am trying to use ConfiForms MatrixView, and there is no option to sort the data grouping (left side). Please advise 

 

thanks 

1 answer

1 accepted

0 votes
Answer accepted
Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 17, 2022

Hi

It takes the same order as it discovers them, which means the order of the dataset MatrixView loads

You can sort that dataset to change the order of tags/labels on the left

Alex

Markisio December 18, 2022

Sorry @Alex Medved _ConfiForms_  how to change the order ? There is no option for it in the matrix view properties. I mean there is sort option on dataset but it doesn’t work and I think it’s for the dataset on the right only. 

unless you are telling me there is NO sort available for the list on the left side (dataset grouping) 

 

thanks 

Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 18, 2022

This will only work when you choose the option to show only relevant choices in the MatrixView macro

When it is selected the dataset is taken in the same order as you set it in the macro params and labels will be presented in the same order they are "discovered"

If this option is unchecked the values are taken in the same order as they are found in the fields parameters (in case of select and other option based fields) or from the order the records were entered in case the other field type is used for grouping

Markisio December 19, 2022

it works! thanks @Alex Medved _ConfiForms_ 

Markisio December 20, 2022

hi @Alex Medved _ConfiForms_ 

 

I noticed when I did above suggestions I have multiple sets of the result in the right side depending on how many grouping. Which is odd! 

 

I have TableView inside of MatrixView, TableView show the result on the right side and the MatrixView show the grouping on the left side

 

thanks 

Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 20, 2022

Why do you have a TableView inside a MatrixView? Is it filtered or shows all the records?

Markisio December 20, 2022

The goal to show the records on the right side by what filter on the left side, is there a better way ? 

Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 20, 2022

This is how the MatrixView is intended to be used https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+MatrixView+and+what+it+does

And yes, if you put a TableView inside then you need to filter it

id:[entry.id]

should work

And yes, you can have a filtered view built in another by using ConfiForms Filter Control - https://wiki.vertuna.com/display/CONFIFORMS/Using+and+configuring+ConfiForms+Dynamic+Filter+Control

Markisio December 20, 2022

Ok @Alex Medved _ConfiForms_  now I am exploring the filter option, I have ConfiForms ValueView at the bottom of the TableView to show sum of that tilter result but it only work on the original result which all the records, is there away dynamically show the value within ConfiForms ValueView depending on the filter result? 

 

thanks in advance! 

Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 20, 2022

Hard to tell without seeing the actual configuration, but certainly the ValueView needs to be filtered in order to show a filtered result

Most probably you will need to put everything into the ListView in order for it to be in a container and filterable by the filtering expression applied on a container 

Something we demonstrate in here https://wiki.vertuna.com/display/TEST/Dynamic+Filters+with+ListView+and+TableView

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events