How to sort grouping dataset within ConfiForms MatrixView

[Markisio]

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

thanks 

[Alex Medved _ConfiForms_ · Accepted solution]

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]

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_]

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]

it works! thanks @Alex Medved _ConfiForms_ 

[Markisio]

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_]

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

[Markisio]

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_]

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]

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_]

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