Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
wiki:advanced_searching [2010/04/01 21:48] jimmym spelling and grammar stuff |
wiki:advanced_searching [2017/12/12 17:17] (current) admin |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| ===== 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 26: | Line 26: | ||
| * ... other options set as name:value pair | * ... other options set as name:value pair | ||
| - | Typically when this method is called it launches the modal dialog and makes it so the grid unaccessible until the dialog is closed.\\ | + | To set more advanced search do: |
| + | |||
| + | <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 | ||
| + | |||
| + | |||
| + | |||
| + | 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. | 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: | The advanced searching can look like this when created: | ||
| - | {{ :wiki:advsearch.png |Advenced Searching}} | + | {{ :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. | 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. | ||
| Line 37: | Line 50: | ||
| 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 | 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 45: | 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> | ||
| Line 61: | Line 78: | ||
| * 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 searched on | * data - is the entered data to be searched on | ||
| + | * groups - set of other // groupOp, rules // elements to define a complex search query | ||
