Hi,
I have one IGHierarchicalGrid. for that grid I want to apply filters for more than one column.
eg.
filter by PersonID : I have 3 values for personID 2,5,8 and I want filter by using all 3 values at a time. like in Queries in SQL server.
at the same time I have to add another filter for name start with 'B'.
Thanks in Advance
Hello gshontz,
I am currently looking into your questions and will keep you posted of any available information.
Hi Petar,
have you got any solution for this IGGrid filter problem?
Also we have implemented load on demand functionality for the same grid. But those filters are not applied to the data which is coming on demand. We have to apply the filter again. Do we have any solution to avoid that.
Also I want to change alignment of IGGrid columns. I need some columns to be right. or some columns to be left. and others should be in center.
Can we implement this using IGGrid.
Thanks in advance.
Thank you for your patience while we were looking into this for you.
What I can suggest for combining multiple filters is the advanced filtering mode. When advanced filtering mode is configured, advanced filtering button is rendered next to column header call. Once advanced button is clicked the "advanced" filtering dialog appears where complex filtering conditions are available to the user. In this dialog you could set multiple filters for a single column. This type of filtering exposes "AND" and "OR" operators in order to combine multiple filters. Some further reference about filtering could be found at:
http://help.infragistics.com/doc/jQuery/2014.1/CLR4.0/?page=igGrid_Filtering.html
Additionally, a working sample demonstrating the advanced filtering feature could be found at:
http://igniteui.com/grid/filtering
Regarding your second requirement, what I can recommend is applying a text-align CSS rule to the respective TD elements of each row in the igGrid.dataRendered event. For example:
dataRendered: function (evt, ui) { ui.owner.element.find("tr td:nth-child(1)").css("text-align", "right"); ui.owner.element.find("tr td:nth-child(4)").css("text-align", "right"); }
dataRendered: function (evt, ui) {
ui.owner.element.find("tr td:nth-child(1)").css("text-align", "right");
ui.owner.element.find("tr td:nth-child(4)").css("text-align", "right");
}
A sample illustrating my suggestion could be found at:
http://www.igniteui.com/grid/configure-text-alignment
I hope you find this information helpful.
Please let me know if you have any additional questions regarding this matter.
Please feel free to contact me if you need any further assistance with this matter.