Guriddo » Topic: Default Search with Multiple

Default Search with Multiple

Guriddo
Default Search with Multiple

This topic has 4 replies, 2 voices, and was last updated 8 years, 11 months ago by trevrobwhite.

Creator

Topic

March 30, 2017 at 6:09 pm #125933

trevrobwhite

Participant

Hi Guriddo,
Is it possible to set a default searchoption for a field with the with multiple set to true?

I have a priority field which is mapped 1 => LOW, 2=> MED, 3 => High and the multiple filter is set true.

The user selects for example 1 & 3 so I want to load the grid with the default filter on the column under multiselect with options 1 & 3 selected (I can’t do not 2 because some columns have many options)

I’ve done this with the date field by going:

$grid-&gt;setColProperty(&quot;alert_time&quot;, array(
    &quot;formatter&quot; =&gt; &quot;date&quot;,
    &quot;formatoptions&quot; =&gt; array(&quot;srcformat&quot; =&gt; &quot;U&quot;, &quot;newformat&quot; =&gt; &quot;d-M-Y H:i:s T&quot;),
    &quot;searchoptions&quot; =&gt; [&quot;defaultValue&quot;=&gt; date(&quot;d-M-Y&quot;,strtotime($params[&#039;date&#039;])),
        &quot;sopt&quot; =&gt; &quot;ge&quot;]
));

$grid->setColProperty("alert_time", array(

"formatter" => "date",

"formatoptions" => array("srcformat" => "U", "newformat" => "d-M-Y H:i:s T"),

"searchoptions" => ["defaultValue"=> date("d-M-Y",strtotime($params['date'])),

"sopt" => "ge"]

));

I also set the data into an array which is json_encoded and passed in:
$grid->setGridOptions(array("postData" => array("filters" => json_encode($searcharr))

I want to do a similar thing with my other fields with the multiple enabled

Many thanks

Creator

Topic

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

Author

Replies

March 31, 2017 at 12:19 pm #125945

guriddo.support

Participant

Hello,

Which search module is used?

In dialog search the defaultValue is missing (We will try to add it)

in toolbar search a comma separated values can be set:

$grid-&gt;setColProperty(&quot;alert_time&quot;, array(
     ...
    &quot;searchoptions&quot; =&gt; [&quot;defaultValue&quot;=&gt; &quot;1, 3&quot;,...],
    ...
));

$grid->setColProperty("alert_time", array(

...

"searchoptions" => ["defaultValue"=> "1, 3",...],

...

));

Kind Regards
Will

Guriddo Support Team

March 31, 2017 at 1:00 pm #125946

trevrobwhite

Participant

Thanks for the reply but I’m struggling to get that to work, I will give you the actual example for priority.

The data contains values 1,2,3,4 or 5 which then displays as text to the user

I’ve only given part of the code, but it’s the most relevant parts (rather than a 400 odd line file) 😉


$dataInit = &lt;&lt;&lt; DATAINIT
function(elem) {
    var options = {
        height: &quot;150&quot;,
        minWidth : &#039;auto&#039;,
        noneSelectedText: &#039;Select&#039;,
        open: function () {
            var mmenu = $(&quot;.ui-multiselect-menu:visible&quot;);
            mmenu.css(&quot;font-size&quot;,&quot;11px&quot;).width(&quot;auto&quot;);
            return;
        }
    }, 
    melem = $(elem);
    melem.multiselect(options);
                            
    melem.siblings(&#039;button.ui-multiselect&#039;).css({
        width: &quot;100%&quot;,
        marginTop: &quot;1px&quot;,
        marginBottom: &quot;1px&quot;,
        paddingTop: &quot;3px&quot;
    });
}
DATAINIT;

$grid-&gt;setSelect(&quot;priority&quot;, array(&quot;5&quot; =&gt; &quot;Emergency&quot;, &quot;4&quot; =&gt; &quot;High&quot;, &quot;3&quot; =&gt; &quot;Medium&quot;, &quot;2&quot; =&gt; &quot;Low&quot;, &quot;1&quot; =&gt; &quot;Info&quot;), true, true, false);

$grid-&gt;setColProperty(&#039;priority&#039;, array(
        &quot;searchoptions&quot;=&gt;array(
            &quot;multiple&quot;=&gt;true,
            &quot;dataInit&quot;=&gt;&quot;js:&quot;.$dataInit,
            &quot;defaultValue&quot;=&gt; &quot;1,2&quot;,  // Also tried Info,Low here
                &quot;sopt&quot; =&gt; &quot;eq&quot;

        ))
);

$searcharr[&quot;groupOp&quot;] = &quot;AND&quot;;
$searcharr[&quot;rules&quot;][] = [
    &quot;field&quot; =&gt; &quot;priority&quot;,
    &quot;op&quot; =&gt; &quot;eq&quot;,
    &quot;data&quot; =&gt; &quot;1,2&quot;
];

$grid-&gt;setGridOptions(array(
    &quot;scroll&quot; =&gt; false,
    &quot;rowNum&quot; =&gt; 20,
    &quot;sortname&quot; =&gt; &quot;alert_time&quot;,
    &quot;sortorder&quot; =&gt; &quot;desc&quot;,
    &quot;sortable&quot; =&gt; &quot;true&quot;,
    &quot;height&quot;=&gt;600,
    &quot;multiSort&quot; =&gt; true,
    &quot;loadonce&quot; =&gt; true,
    &quot;autowidth&quot; =&gt; true,
    &quot;shrinkToFit&quot; =&gt; false,
    &quot;search&quot; =&gt; true,
    &quot;postData&quot; =&gt; array(&quot;filters&quot; =&gt; json_encode($searcharr)),
    //&quot;colMenu&quot; =&gt; true,  // Can&#039;t get colMenu working with multiple
));

$grid-&gt;setNavOptions(&#039;navigator&#039;, [&quot;refresh&quot; =&gt; false,
    &quot;reload&quot; =&gt; false, &quot;excel&quot; =&gt; false, &quot;add&quot; =&gt; false, &quot;edit&quot; =&gt; false, &quot;del&quot; =&gt; false, &quot;view&quot; =&gt; true, &quot;search&quot; =&gt; true,
    &quot;columns&quot; =&gt; true,]);
$grid-&gt;setNavOptions(&#039;search&#039;, array(&quot;multipleSearch&quot; =&gt; true, &quot;uniqueSearchFields&quot; =&gt; true, &quot;multipleGroup&quot; =&gt; true, &quot;showQuery&quot; =&gt; true));

$grid-&gt;renderGrid(&#039;#grid&#039;, &#039;#pager&#039;, true, null, null, true, true);

$dataInit = <<< DATAINIT

function(elem) {

var options = {

height: "150",

minWidth : 'auto',

noneSelectedText: 'Select',

open: function () {

var mmenu = $(".ui-multiselect-menu:visible");

mmenu.css("font-size","11px").width("auto");

return;

}

melem = $(elem);

melem.multiselect(options);

melem.siblings('button.ui-multiselect').css({

width: "100%",

marginTop: "1px",

marginBottom: "1px",

paddingTop: "3px"

});

}

DATAINIT;

$grid->setSelect("priority", array("5" => "Emergency", "4" => "High", "3" => "Medium", "2" => "Low", "1" => "Info"), true, true, false);

$grid->setColProperty('priority', array(

"searchoptions"=>array(

"multiple"=>true,

"dataInit"=>"js:".$dataInit,

"defaultValue"=> "1,2", // Also tried Info,Low here

"sopt" => "eq"

))

);

$searcharr["groupOp"] = "AND";

$searcharr["rules"][] = [

"field" => "priority",

"op" => "eq",

"data" => "1,2"

];

$grid->setGridOptions(array(

"scroll" => false,

"rowNum" => 20,

"sortname" => "alert_time",

"sortorder" => "desc",

"sortable" => "true",

"height"=>600,

"multiSort" => true,

"loadonce" => true,

"autowidth" => true,

"shrinkToFit" => false,

"search" => true,

"postData" => array("filters" => json_encode($searcharr)),

//"colMenu" => true, // Can't get colMenu working with multiple

));

$grid->setNavOptions('navigator', ["refresh" => false,

"reload" => false, "excel" => false, "add" => false, "edit" => false, "del" => false, "view" => true, "search" => true,

"columns" => true,]);

$grid->setNavOptions('search', array("multipleSearch" => true, "uniqueSearchFields" => true, "multipleGroup" => true, "showQuery" => true));

$grid->renderGrid('#grid', '#pager', true, null, null, true, true);

April 3, 2017 at 1:30 pm #125947

guriddo.support

Participant

Hello,

Thank you for the code. It is much clear now.

In your case this will not work. For dialog search amd colMenu search the multiple option is not working in PHP version – it is working only when a toolbar search is on.

We will try to fix this for the upcoming release.

Kind Regards,

Will

This reply was modified 8 years, 11 months ago by guriddo.support.

Guriddo Support Team

April 3, 2017 at 1:58 pm #125949

Default Search with Multiple

Search Forum

Recent Replies

Forum Statistics

UserOnline