Skip to content

Queries

Cody Gramlich edited this page Apr 5, 2019 · 3 revisions

Each program is filtered based on queries. Let's take a look at an example.

Example

The City of Edmonton has a program called Leisure Access Program that citizens can qualify for. We have an info page on it here. The primary way citizens can qualify for LAP is based on their income level.

For now we will take into consideration only the household income for Monthly Pass ignoring the middle column. We will add queries to YCB to allow our screener questions to qualify the correct applicants for this program. First, if you aren't already logged in as admin, click the lock in the top right corner and log in. You will now see the admin bar.

Select programs. For this example, we will assume you already have a program setup. If not, please see the programs wiki page. Click the edit icon (a little pencil) on the program you would like to add queries to.

Click the edit program queries button near the top.

In this case, we already have some queries. We're going to create a new query that allows a single person with no kids to get access to the Leisure Access Program. Click the new query button. Then click the new condition button. There will be a drop-down menu to select a question. If the input type is a number input, there will be a drop-down menu for a qualifier (<, <=, =, >=, >) and a field to enter a number. If the input type is toggle, then there will be a true or false option.

Select false for the spouse question and <= 31673 for the income question. Finally, click the save button.

We have successfully allowed single applicants to qualify for the Leisure Access Program.