Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
wiki:advanced_searching [2009/11/03 17:21]
tony
wiki:advanced_searching [2017/12/12 17:17] (current)
admin
Line 1: Line 1:
 ====== Advanced Searching ====== ====== Advanced Searching ======
-Advanced searching is a way to search on multiple fields ​and the same time with different conditions. Advanced searching and single searching use the same method, but with different ​setting ​and posting data. +Advanced searching is a way to search on multiple fields ​at the same time with different conditions. Advanced searching and single searching use the same method, but with different ​settings ​and posting data. 
  
 ===== Installation ===== ===== Installation =====
-In order to use this method the following modules should be included when downloading the grid: Common, Form Edit, Search ​Plugin. For more information refer to [[Download]] +In order to use this method the following modules should be included when downloading the grid: Common, Form Edit, filter ​Plugin. For more information refer to [[Download]].
 ===== Calling Conventions ===== ===== Calling Conventions =====
 <code javascript>​ <code javascript>​
Line 27: Line 26:
    * ... other options set as name:value pair    * ... other options set as name:value pair
  
-Typically when this method is called it lunches the modal dialog and make so that the grid is not accessible until the dialog is not closed.\\  +To set more advanced ​search ​do:
-This method is not the default search method in the [[navigator]]. ​To enable this you should either set the defaults search options using the extend method or set it in the navigator in the place of the search ​options.+
  
-The advanced searching can look like this when created:+<code javascript>​ 
 +<​script>​ 
 +...  
 +jQuery("#​grid_id"​).jqGrid('​searchGrid',​ {multipleSearch:true,...} ); 
 +... 
 +</​script>​ 
 +</​code>​ 
 +   * multipleGroup:​true activates the more advanced search dialog allowing to add complex group conditions
  
-{{ :​wiki:​advsearch.png |Advenced Searching}} 
  
-As you can see the user can add or delete a unlimited conditions to perform the search. \\ To add a condition the plus button should be pressed. \\ To delete a condition a minus button should be pressed. 
  
 +Typically when this method is called it launches the modal dialog and makes it so the grid inaccessible until the dialog is closed.\\ ​
 +This method is not the default search method in the [[navigator]]. To enable this you should either set the default search options using the extend method or set it in the navigator in the place of the search options.
 +
 +The advanced searching can look like this when created:
 +
 +{{ :​wiki:​complexsearch.png |Advenced Searching}}
 +
 +As you can see the user can add or delete an unlimited number of conditions to perform the search. \\ To add a condition the plus button should be pressed. \\ To delete a condition the minus button should be pressed.
 ===== Options ===== ===== Options =====
  
-We have the same options as those from [[:​wiki:​singe_searching#​options | Singe Searching]] \\ Below we consider only these options that are connected with the advanced search.\\ As mentioned above the first options ​is  +We have the same options as those from [[:​wiki:​singe_searching#​options | Single ​Searching]] \\ Below we consider only these options that are connected with the advanced search.\\ As mentioned above the first option ​is 
-   * multipleSearch:​true - This option activates the advanced searching+   * multipleSearch:​true - This option activates the advanced searching ​
 The second option is: The second option is:
    * sFilter - this option determines the name of the posting data. The default value is filters.    * sFilter - this option determines the name of the posting data. The default value is filters.
Line 47: Line 58:
 <code html> <code html>
 filters =  filters = 
-    ​{"​groupOp":"​AND", +   { 
-     ​"​rules":​[ +    ​"​groupOp":"​OR", 
-       {"​field":"​invdate","​op":"​ge","​data":"​2007-10-06"}, +    "​rules":​[{"​field":"​a.id","​op":"​eq","​data":"​1"}]
-       {"field":"​invdate","​op":"​le","​data":"​2007-10-20"​},​  +    "groups":
-       {"​field":"​name","​op":"​bw","​data":"​Client 3"} +         { 
-      +             "groupOp":"​AND", 
-    }+             "rules":[{"​field":"​a.id","​op":"​eq","​data":"​2"}], 
 +             "​groups":​[...] 
 +         } 
 +     
 +}
 </​code>​ </​code>​
  
-As your notice the posted data is a JSON string with the following parameters:+The posted data is a JSON string with the following parameters:
  
-  * groupOp this determines the rules of the search. Can be AND or OR. This option can be changed from the user with help of the select box near to Reset button. When the user select all (English variant) the AND is set. When the user select ​any the OR is set. +  * groupOp ​this determines the rules of the search. Can be AND or OR. This option can be changed from the user with the help of the select box near the Reset button. When the user select all (English variant) the AND is set. When the user selects ​any the OR is set. 
-  * rules is array with the following options +  * rules - an array with the following options 
-     * field - the field property ​contain ​the name of the selected index (or name) from colModel+     * field - the field property ​contains ​the name of the selected index (or name) from colModel
      * op - determines the condition of the searching. see the sopt in the [[:​wiki:​singe_searching#​options | options]]      * op - determines the condition of the searching. see the sopt in the [[:​wiki:​singe_searching#​options | options]]
-     * data - is the entered data to be search +     * data - is the entered data to be searched on 
- +  * groups -  set of other // groupOp, rules // elements to define a complex ​search ​query

QR Code
QR Code wiki:advanced_searching (generated for current page)