Guriddo » Topic: Saved Filters

Saved Filters

Tagged: filters, templFilters, tmplNames

This topic has 15 replies, 2 voices, and was last updated 11 years, 3 months ago by tony.

Creator

Topic

January 12, 2015 at 3:18 am #115238

Participant

Hi Folks,

Can anyone help us on adding Saved Filters?

We have Filter Templates configured and working, see code snipet below.

Looking to add ability for users to create, update, update and delete (crud) filters and save changes on server side.

Looking on methods push or pop tmplNames and tmplFilters.

;
//this code retuerns the current filter in use
var currentfilter = $("#jqGrid").jqGrid('getGridParam','postData').filters;

//this is our setup for templNames and tmplFilters

   $(#jqGrid).navGrid(#jqGridPager, {
...
      multipleSearch: true,
      multipleGroup: true,
      showQuery: true,
      tmplNames: [Template One, Template Two],
      tmplFilters: [template1, template2],
...
   });

    var template1 =
    { "groupOp": "AND",
          "rules": [
            { "field": "Account", "op": "eq", "data": "XYZ" },
            { "field": "Name",    "op": "cn", "data": "Smith"}
          ]
    };

    var template2 =
    { "groupOp": "AND",
          "rules": [
            { "field": "Name", "op": "eq", "data": "Carnes" },
            { "field": "OrderID", "op": "le", "data": "10255"}
          ]
    };

;

//this code retuerns the current filter in use

var currentfilter = $("#jqGrid").jqGrid('getGridParam','postData').filters;

//this is our setup for templNames and tmplFilters

$(#jqGrid).navGrid(#jqGridPager, {

...

multipleSearch: true,

multipleGroup: true,

showQuery: true,

tmplNames: [Template One, Template Two],

tmplFilters: [template1, template2],

...

});

var template1 =

{ "groupOp": "AND",

"rules": [

{ "field": "Account", "op": "eq", "data": "XYZ" },

{ "field": "Name", "op": "cn", "data": "Smith"}

]

};

var template2 =

{ "groupOp": "AND",

"rules": [

{ "field": "Name", "op": "eq", "data": "Carnes" },

{ "field": "OrderID", "op": "le", "data": "10255"}

]

};

This topic was modified 11 years, 3 months ago by Tony Russo.
This topic was modified 11 years, 3 months ago by tony.
This topic was modified 11 years, 3 months ago by tony.

Creator

Topic

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

Author

Replies
January 12, 2015 at 3:33 am #115240

Tony Russo
Participant

on server side in addition to the filter, we would need to know the template name and mode (create, read, update, delete)

January 12, 2015 at 11:43 am #115250

tony
Keymaster

Hello,

Since you can get the current filter it is easy for you to manipulate these arrays

JavaScript

.. tmplNames: [Template One, Template Two], tmplFilters: [template1, template2], ..

1
2
3
4

..
tmplNames: [Template One, Template Two],
tmplFilters: [template1, template2],
..

There is no build in way to do this, but you can define two arrays for the names and templates and push,delete and modify them with a little custom JavasScript.
In order to take effect this you will need to set recreateFilter for the filter options.
See docs.

Kind Regards

January 12, 2015 at 4:22 pm #115257
Tony Russo
Participant
Hi Tony,
- Using the test code below only works if a filter has been used.
- Pressing the savefilter button does add “Template Three”.
- However thereafter “template” select does show the new “Template Three” filter but on change does not change the filters.
<pre class=”lang:js decode:true ” >$(‘#jqGrid’).navGrid(“#jqGridPager”, { … multipleSearch: true, multipleGroup: true, showQuery: true, // tmplNames: [“Template One”, “Template Two”], // tmplFilters: [template1, template2], tmplNames: tmplNames_array, tmplFilters: tmplFilters_array, recreateFilter: true, … });
var template1 = { “groupOp”: “AND”, “rules”: [ { “field”: “Account”, “op”: “eq”, “data”: “xyz” }, { “field”: “Name”, “op”: “cn”, “data”: “Smith”} ] }; var template2 = { “groupOp”: “AND”, “rules”: [ { “field”: “Name”, “op”: “eq”, “data”: “Carnes” }, { “field”: “OrderID”, “op”: “le”, “data”: “10255”} ] }; var tmplNames_array = [“Template One”, “Template Two”]; var tmplFilters_array = [template1, template2]; //test to add a filter $(‘#savefilter’).click(function() { var template3 = template1; tmplNames_array.push(“Template Three”); tmplFilters_array.push(template3);
return; });
- This reply was modified 11 years, 3 months ago by Tony Russo.
January 12, 2015 at 6:54 pm #115261

Tony Russo
Participant

Searching the docs for recreateFilter returns this “This topic does not exist yet”

.

January 12, 2015 at 8:38 pm #115262
Tony Russo
Participant
Hi Tony,

Please disregard where I said the filter was not working.

The save filter is now working, must have been something else in my code.

Our next steps are adding a button and/or icons to the search modal to call another modal with CRUD fields.

Thanks,
Tony
- This reply was modified 11 years, 3 months ago by Tony Russo.
January 13, 2015 at 1:50 pm #115277
tony
Keymaster
Hello,

Thanks for the feedback.
For now it is not possible to add custom buttons in the search dialogs, but we I can think about this. Will replay to you.

Kind Regards
- This reply was modified 11 years, 3 months ago by tony.
January 13, 2015 at 3:31 pm #115279

Tony Russo
Participant

Hi Tony,

.

We’ve been trying to add CRUD features to the search dialog, seems like the search dialog doesn’t exist in DOM until the search icon has been clicked?

.

Seems like if we could load the search dialog in DOM without making it visible we could add elements and events like .change to the ui-template select, add additional buttons/links etc for CRUD.

.

Do you think there could be be a way to extend filters so they are in DOM when the grid is created?

.

Regards,
Tony

January 13, 2015 at 4:05 pm #115281

Tony Russo
Participant

Hi Tony,

.

Seems even more difficult than we had imaged because the search dialog seems to be a modal and only in DOM when visible.

.

I wonder if it’s possible to add an additional event to the search button so when the search dialog is in DOM we could add elements and events?.

.

Looking at this from another view seems like our need for the the search dialog is mainly so we can add CRUD features. If we could figure out how extract the source code for the search dialog, maybe we could clone it in our own Save Search dialog where we would have the ability to add custom elements and events and save searches to the server?

.

Deploying jqGrid without Saved search functionality would be very difficult for us in our web application.

.

Can you think of any other way or hooks where we could add this functionality to jqGrid now?

.

Regards,
Tony

January 14, 2015 at 5:16 am #115283

Tony Russo
Participant

Setting recreateFilter to true results in template select element to default.
.
Problem is we need recreateFilter: true so we can add or delete filters but we do not want the template select to reset to default.

January 14, 2015 at 12:21 pm #115291

tony
Keymaster

Hello,

Aha, will take this in account too (todo list).

Regards

January 14, 2015 at 1:48 pm #115292

Tony Russo
Participant

Thank you.
.
Do you have any kind of time frame for this?

January 15, 2015 at 11:08 am #115303

tony
Keymaster

Hello,

I will try to include this in the next release, but I do not promise.

Kind Regards

January 15, 2015 at 2:19 pm #115306

Tony Russo
Participant

OK, thanks.

Do you have a roadmap or schedule for your next release?

January 15, 2015 at 2:43 pm #115308

Tony Russo
Participant

Oh I see the roadmap for Q1 2015.
.
We may need to look for another solution if it the release goes to March.
.
Regards,
Tony

January 16, 2015 at 11:00 am #115344

tony
Keymaster

Hello,

You can look into the html content (the modal) generated in the search dialogue. And then with a little JavaScript to add a button and attach the needed code. If you need help on this, please let me know.

Kind Regards,
Author

Replies

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

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

Saved Filters

Search Forum

Recent Replies

Forum Statistics

UserOnline