Completed
Last Updated: 02 Feb 2021 16:53 by ADMIN
Joshua
Created on: 26 Aug 2020 18:30
Category: Data Source
Type: Feature Request
0
Filter based on other column value

It would be nice to be able to specify in a datasource filter two fields and an operator for the sake of data reporting. For example, where "completed date" is greater than "promised date" or "Actual cost" is greater than "estimated cost."

This sort of thing can be accomplished by calculated fields; a filter of where "cost overage" is greater than 0. The down side of the calculated field approach is all comparisons need to be pre-defined. 

 

1 comment
ADMIN
Neli
Posted on: 02 Sep 2020 12:45

Hi Joshua,

Below you will find links to our Forum, where such an issue is discussed. In the links, there are different examples of how to filter by multiple fields or how to achieve a custom filtering:

- https://www.telerik.com/forums/custom-filtering-7b617857877c#prkw13DE9E2pMvYMcx-6Hg

- https://www.telerik.com/forums/multiple-filter-conditions

- https://www.telerik.com/forums/multiple-filters-on-datasource

I hope the provided example will be helpful for resolving the issue. In case the links are not helpful and you need further assistance on the matter, please elaborate a little bit more on the specific scenario and the desired result, so I could provide you appropriate assistance. 

Regards,
Neli
Progress Telerik

Five days of Blazor, Angular, React, and Xamarin experts live-coding on twitch.tv/CodeItLive , special prizes and more, for FREE?! Register now for DevReach 2.0(20).