Query builder filter limits
From PTAGISWiki
There are limits imposed on the building a query with the PTAGIS Query Builder to prevent malformed or anti-social queries from consuming all available access to the database.
Required Filters
- Apply a filter to a red field.
- Apply a filter to at least one blue field and at least one green field.
- Apply a filter to an orange field.
| First Observation Date | |
| OR | |
| Release Site | Release Date |
| HUC Code | Migration Year |
| OR | |
| Tag ID | |
Filter limits
The limits for any individual field are defined in the table wqb_fields in the column validation_data. For instance, the obs_site field can have a maximum number of items in it. That limit is defined in the database as 5, so no query can specify a filter with more that 5 obs_sites. However, since obs_site is not a required filter, it can be left blank to allow all values of obs_site.
After a change is made to this value, the SREE webapp needs to be redeployed before the change will take effect.
