Guriddo » Topic: Search is Using Index Field

Search is Using Index Field

Guriddo
search
Search is Using Index Field

Tagged: search

This topic has 3 replies, 3 voices, and was last updated 8 years, 4 months ago by tmondelli.

Creator

Topic
April 27, 2016 at 10:16 pm #125110

tmondelli
Participant

I am trying to add in the search feature into our grid implementation. We are using an index field to sort some of our columns on a different value that what is shown. The problem is that when the search is applied to that column, it searches on the index field rather than the field that is visible. I have created a jsfiddle: https://jsfiddle.net/tzgyvbLn/

Please let me know if I’m doing something wrong, thanks.
Creator

Topic

Viewing 3 replies - 1 through 3 (of 3 total)

Author

Replies

April 28, 2016 at 9:50 am #125113

guriddo.support

Participant

Hello,

Thank you for the code. I understand what you want to do.
You do nothing wrong. The behavior you describe is correct.

It is not possible to meet every user requirement, but fortunately we have created a lot of events and options where almost every problem can be solved.

One possible solution is to use a custom button. The idea is to chenge the index name before calling the search and put it back after the search dilog closes.

For this purpose we will use setColProp method and recreateFilter parameter set to tru so that every time the search is open the renaming can take effect. Bellow is a code snippet.
(You will need to disable the build in search in navigator search:false)

$("#list2").navButtonAdd("#pager", 
onClickButton : function() { 
   $("#list2").setColProp("StoreName_0", {index : "StoreName_0"});
   // do for the other you need
   $("#list2").jqGrid("searchGrid",{
      recreateFilter: true,
      multipleSearch: true,
      closeAfterSearch: true,
      onClose : function () {
          $("#list2").setColProp("StoreName_0", {index : "d0_key"});
          // do for the other you need
      }
   });
});

$("#list2").navButtonAdd("#pager",

onClickButton : function() {

$("#list2").setColProp("StoreName_0", {index : "StoreName_0"});

// do for the other you need

$("#list2").jqGrid("searchGrid",{

recreateFilter: true,

multipleSearch: true,

closeAfterSearch: true,

onClose : function () {

$("#list2").setColProp("StoreName_0", {index : "d0_key"});

// do for the other you need

}

});

Kind Regards,
Will

Guriddo Support Team

April 30, 2016 at 7:36 am #125119

tony

Keymaster

Hello,

It is a good idea to give us a feedback, if the answered problems are resolved, before to post many other questions.

Thank you.

Kind Regards

May 2, 2016 at 3:35 pm #125122

tmondelli

Participant

It will take time to put this into our application and test it, but it looks like a sufficient resolution to the problem. The other issues I posted are not associated with this issue or the resolution, I don’t agree that I should have to completely finish this issue before posting another.