You are not logged in. Click here to log in.

Application Lifecycle Management
Login
 Projects
 Reports
 Wiki
 Documents
 Trackers
 SCM Repositories
Last ModifiedRecently Visited Items
Search In Project
Search inClear
anonymous
 WQM-03: Pesticide Product List (PestProdList)#41624/v6
Tags:  not added yet

WQM-03: Pesticide Product List (PestProdList)[SERVICE-41624]

Tracker: Services Priority: NormalNormal Status: New
Submitted by: casespMar 22 2018 14:15 Modified by: jdriMay 17 2018 12:59 Type:
Data
Path: m/wqm/pestprodlist/2.1 Context: csip-wqm Version: 2.1
Endpoints: http://csip.engr.colostate.edu:8083/csip-wqm/m/wqm/pestprodlist/2.1
Maintainers:
casesp
Website: -- Apps:
--
Test Status:
--
Last Tested: -- Test Count: --
Test Success Rate: -- Failed Tests: --
Traceability
Loading…
Description
This service returns a list of pesticide products, their names, EPA numbers, product types, active ingredients and percentages. It adds the ability, over version 2.0, to search by database row_id, and was developed in support of NRCS RS 5.0.


The data source is the NRCS pesticide database kept current on an 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". 

{
    "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"
        }
    ]
}






		









	
	


























	
		
			
		
		Details
		
	
	

			
				
				
			

			

			

			


	

		

			

				 
Comments & Attachments  


			

				 
Associations 


			

				 
Children 


			

				 
SCM Commits 


			

				 
History (6) 


			

				 
Baselines 


			

				 
All (6)