Jurisdiction Participation and Submission Report

Working...
 
Choose Columns...

API endpoints: JSON | XML | CSV

Using the Filters

Using operators to filter the data in data tables can allow you to quickly pinpoint specific members.


Syntax

Means

expression

like '%expression%'

=expression             

exactly equals 'expression'

!=expression           

does not equal 'expression'

>expression             

greater than 'expression'

>=expression           

greater than or equal to 'expression'

<=expression           

less than or equal to 'expression'

<expression             

less than 'expression'

in(exp1,exp2)           

in the list 'exp1,exp2'

!in(exp1,exp2)         

not in the list 'exp1,exp2'

=NULL                   

is NULL or blank

!=NULL                 

is not NULL or blank

num1-num2              

between num1 and num2, inclusive

date1-date2            

between date1 and date2, inclusive

Notes:

  • No qualifiers (no single quotes) should be used. 
  • Valid date delimiters are '/' and '.' (no '-' because that's the range operator). 
  • Whitespace is generally ignored within operators: '! in (1,2,3)' works as well as '! in(1,2,3)' and '!in (1, 2, 3)'. 
  • Whitespace is maintained within string expressions though, so that 'region i' is different than 'regioni'.
  • Operators should not be used for Boolean data types.  Entering 1, Y or T (case-insensitive) evaluates to true, and 0, N, F evaluate to false.