Filtering on columns does not fetch correct records when using Row Span

[Viji Palanisamy]

1.Filtering on columns does not fetch correct records in scenarios like when we have merged column. I have used rowSpan to merge rows. But I need to filter when one of the row  matches and get both the records filtered.


Notes:

1.When applying filter on merged rows, For example on wshp-01, can we get merged column (with both results). 

2.Works as expected when doing search option . It fetches  the corresponding pairs of it.

    queryCellInfo = args => {

        const filteredColumns = ['student', 'status', 'details']

        var data = args.data

        if (filteredColumns.includes(args.column.field) && (data.rowSpan === true) && (data.status === 'Clash' || data.status === 'Problem')) {

            args.rowSpan = 2

        }

    }

[Vigneshwaran Sankar]

Hi Viji Palanisamy,

Greetings from Syncfusion support.

Currently we are validating your query "Filtering on columns does not fetch correct records when using Row Span" we will provide further details on or before 29th February 2024. We appreciate your patience and understanding until then.

Regards,

Vigneshwaran Sankar.

[Vigneshwaran Sankar]

Hi Viji Palanisamy,

 

We checked your query "Filtering on columns does not fetch correct records when using Row Span" indicates that you may be encountering problem while filtering records with merged rows. We've examined a sample based on your provided code example and observed that both filtered and searched records return the same records in the same format. 

 

By default, the searching action occurs based on the contains operator, whereas the filtering action occurs based on the type of the column. Could you please clarify whether you prefer the records in a merged state or as individual records. Additionally, it would be helpful if you could share the complexity of the problem you faced and provide a sample along with a video demonstration for further validation.

 

Sample Link:  https://stackblitz.com/edit/react-jvazyg-sggjnd?file=index.js,index.html

 

Regards,

Vigneshwaran Sankar.

[Viji Palanisamy]

Hi,

I prefer the records in a merged state to be filtered. For example, When we filter the a column unit in stock)using filter says, 125.It should gets me both the merged records. I need the result as below.

I need both the rows with row span as it is always needed to interpret that records. Can This be acheived using Syncfusion. If so can you gives me  a sample code on how to make this logic to work.

Note:

In my case, sometime I may have a row with row span and without row span. 

[Vigneshwaran Sankar]

Hi Viji Palanisamy,

 

Thanks for your patience.

 

Based on the details provided we checked row span is intended for UI customization, whereas Grid data operations such as Paging, Sorting, Filtering, etc., should be executed based on the dataSource. So we suggest that it filters only the selected value from the dataSource. Even if the row is spanned for merging, it does not impact filtering. Therefore, we cannot filter the rows based on the rowSpan.

 

Please feel free to get back us for further assistance.

 

Regards,

Vigneshwaran Sankar.

[Viji Palanisamy]

Hi  Vigneshwaran Sankar,

     Can this feature be added by you in any later versions. Please let me know, so it would be easy for us to make some decision. As we feel, that feature is important to us for interpreting some data.

Thanks.

[Vigneshwaran Sankar]

Hi Viji Palanisamy,

 

Sorry for this inconvenience,

We suggest that rowSpan will be utilized for UI-level purposes only, as filtering operations are typically based on data. For example, if you filter a value and the filtered result is only one row, in this case it will not gives merged with this rows. Therefore, data actions should remain separate from UI actions. Customizing data solely for UI purposes, such as cell merging, should not involve acquiring additional data. Expected to get another data for cell merging is not a valid case.

 

Please feel free to get back us for further assistance.

 

Regards,

Vigneshwaran Sankar.

[Viji Palanisamy]

Thanks  Vigneshwaran Sankar for the update.

[Getsy Edwin]

Hi Viji,

Please feel free to contact us if you need any other assistance.

Regards,

Getsy