Is there any way to make ig grid support full-text search? | Infragistics Forums

State Suggested Answer
Replies 3 replies
Answers 1 answer
Subscribers 15 subscribers
Views 1169599 views
Users 0 members are here

igGrid

510

Is there any way to make ig grid support full-text search?

Spark posted over 12 years ago

Is there any way to make ig grid support full-text search?

Parents

No Data

Reply

23953

Suggested Answer
Offline Martin Pavlov posted over 12 years ago
Hi,

Full-text search is not supported out of the box, but you can easily implement it yourself.

Here is what you should do:

1.Hide the filter, so there is no filtering UI available. Use igGridFiltering.toggleFilterRowByFeatureChooser method.

2.Create your custom filter UI, for example simple input field and "Find" button.

3.Use the public igGridFiltering.filter method to initiate filtering. You should define filtering expression for each field in your grid. Take into account the type of the columns in the grid.

Here is an example implementation of a full-text filtering function:

Code Snippet

function fullTextFiltering(searchTerm) {

    var $grid = $("#grid1");

    var filterExpressions = [];

    var cols = $grid.data("igGrid").options.columns;

    for(var i = 0; i < cols.length; i++) {

        if (cols[i].dataType === "string")

            filterExpressions.push({fieldName: cols[i].key, expr: searchTerm, cond: "contains", logic: "OR"});

    }

    $grid.igGridFiltering("filter", filterExpressions, false);

}

Hope this helps,

Martin Pavlov

Infragistics, Inc.
Cancel
Reply

Reject Answer

Cancel

Children

40

DougS posted over 11 years ago in reply to Martin Pavlov

Hi,

I was having a similar question and I noticed your example. I have it working great except I cannot for the life of me be able to hide the filtering UI.

Here is my code, what am i doing wrong?

        $("#grid1").igGridFiltering("toggleFilterRowByFeatureChooser", null);
 
        $('#btnSearch').click(function () {
            var searchTerm = $("#searchTerm").val();
            var $grid = $("#grid1");
            var filterExpressions = [];
            var cols = $grid.data("igGrid").options.columns;
            for(var i = 0; i < cols.length; i++) {
                if (cols[i].dataType === "string")
                     filterExpressions.push({fieldName: cols[i].key, expr: searchTerm, cond: "contains", logic: "OR"});
               }
            $grid.igGridFiltering("filter", filterExpressions, false);
 
        });

@(Html.Infragistics().Grid<UsersViewModel>()
       .ID("grid1")
       .AutoGenerateColumns(false)
       .Columns(col =>
           {
               col.For(x => x.FullName).DataType("string").HeaderText("Name").Width("200");
               col.For(x => x.UltiProManagerName).DataType("string").HeaderText("Ultimate Manager").Width("150");
               col.For(x => x.ManagerName).DataType("string").HeaderText("Approving Manager").Width("150");
               col.For(x => x.Email).DataType("string").HeaderText("Email").Width("150");
               col.For(x => x.LastLoginDateString).DataType("string").HeaderText("Last Login").Width("150");
           })
        .Features(features =>
            {
                features.Paging().PageSize(50).Type(OpType.Local);
                features.Selection().Mode(SelectionMode.Row);
                features.Filtering().RenderFilterButton(false).RenderFC(false).FilterSummaryAlwaysVisible(false).;
            })
            
       .RowTemplate("<tr><td>${FullName}</td><td>${UltiProManagerName}</td><td>${ManagerName}</td><td>${Email}</td><td>${LastLoginDateString}</td></tr>")       
       .DataSourceUrl(Url.Action("BindGrid"))
       .PrimaryKey("ID")
       .DataBind()
       .Render()
 )