Skip to content
This repository has been archived by the owner on Jan 18, 2019. It is now read-only.

Queries

Jared Rewerts edited this page Oct 5, 2018 · 3 revisions

Each program is filtered based on queries. For example, you may qualify for a program if you satisfy the low income query and also the has children query. Lets 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, lets just ignore the middle column, taking just the higher qualification amount into account. We will add queries to YCB to allow our screener questions added in the questions guide 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 have a couple queries already created. If you don't have any, that's okay. We're going to add some new queries. Remember the table shown previously? We're going to create a query that allows a single person, with no kids to get access to the Leisure Access Program. Click the new query button. Click the new condition button.

On the left side are keys. If you're interested in learning more about these, please see the keys page. On the right are values. Select children is false.

Next, add spouse is false and grossincome is <= 31673. Finally, click the save button.

Congratulations! We have successfully allowed single applicants to qualify for the leisure access program. We will leave the rest of the table as an exercise.

Clone this wiki locally