Description |
%%(background-color:#ffffff;color:#1e1e1e;)This service returns a list of pesticide products, their... annual basis, derived from WinPST maintained by Eric Hesketh at University of Mass. at Amherst.%!¶ | ¶ | WQM-03 has been updated to include a new parameter and an additional pp_filter_name value.¶ | ¶ | The new parameter, "filter_operator", identifies how to combine all of the submitted filters into an SQL statement. The options are as an "OR" or as an "AND". The default value is "AND".¶ | ¶ | The additional pp_filter_name value is "product_row_id", to allow for searching for specific rows of the pesticide's products table by their internal row_id. When choosing to search for more than one product by row_id, one should set the "filter_operator" to be "OR".¶ | ¶ | ¶ | [{Table¶ | ¶ | |__Request (WQM-03)__¶ | ¶ | |(text-align:left;vertical-align:top;)¶ | {{{¶ | {¶ | "metainfo": {},¶ | "parameter": [¶ | {¶ | "name": "max_products",¶ | "value": 40¶ | },¶ | {¶ | "name": "filters",¶ | "optional": false,¶ | "notes": "May contain more than one array element meeting the specifications listed in the first element of the 'value' key of this object.",¶ | "value": [¶ | [¶ | {¶ | "name": "pp_filter_name",¶ | "optional": false,¶ | "option1": "reg_no",¶ | "option2": "prod_name",¶ | "option3": "company_code",¶ | "option4": "product_code",¶ | "option5": "product_row_id",¶ | "value": "reg_no",¶ | "description": "This filter must contain one of the following: 'reg_no', 'prod_name', 'company_code', 'product_code'"¶ | },¶ | {¶ | "name": "pp_filter_value",¶ | "optional": false,¶ | "value": "000",¶ | "description": "This parameter specifies what value is being sought in the field specified in pp_filter_name. The value may be string or integer type"¶ | },¶ | {¶ | "name": "ends_with",¶ | "optional": true,¶ | "option1": true,¶ | "option2": false,¶ | "default": false,¶ | "value": false,¶ | "description": "This parameter when set to 'true' indicates that the pp_filter_value being sought in pp_filter_name must occur in the end of the word or data located in that column"¶ | },¶ | {¶ | "name": "contains",¶ | "optional": true,¶ | "option1": true,¶ | "option2": false,¶ | "default": false,¶ | "value": false,¶ | "description": "This parameter when set to 'true' indicates that the pp_filter_value being sought in pp_filter_name must occur somewhere in the word or data located in that column"¶ | },¶ | {¶ | "name": "begins_with",¶ | "optional": true,¶ | "option1": true,¶ | "option2": false,¶ | "default": false,¶ | "value": true,¶ | "description": "This parameter when set to 'true' indicates that the pp_filter_value being sought in pp_filter_name must occur at begining of the word or data located in that column"¶ | },¶ | {¶ | "name": "is_exactly",¶ | "optional": true,¶ | "option1": true,¶ | "option2": false,¶ | "default": false,¶ | "value": false,¶ | "description": "This parameter when set to 'true' indicates that the pp_filter_value being sought in pp_filter_name must occur exactly in that column"¶ | }¶ | ]¶ | ],¶ | "description": " Array of filters to use for a search into the pesticides database."¶ | },¶ | {¶ | "name": "filter_operator",¶ | "optional": true,¶ | "option1": "AND",¶ | "option2": "OR",¶ | "default": "AND",¶ | "value": "AND",¶ | "description": "Contains the operator to use in joining all of the specified filters during a search"¶ | }¶ | ]¶ | }¶ | }}}¶ | }] | Show diff |
%%(background-color:#ffffff;color:#1e1e1e;)This service returns a list of pesticide products, their... annual basis, derived from WinPST maintained by Eric Hesketh at University of Mass. at Amherst.%! | |