Searching For Bill Sponsorship in Query Builder
User can a) search for legislators in query builder based on bill sponsorship and b) add bill sponsorship data to current selection. Bills can be Federal or State. There is separate field (Legislator State Bills Sponsored) for searching based on State Bills.
As with the staff search bill sponsorship lookup, the data is coming from the KnowWho database. State bill sponsorship data is coming from State Bills database.
- Go To Query Builder
- Main Search Record =Legislator and at least one field has been selected
- New Clause Type = ANDREL
- Field = "Legislator Bills Sponsored" or "Legislator State Bills Sponsored"
Operator = In the Set of Any Values Field = Search for Bills