URL Parameters

HTTP GET and HTTP POST parameters can be used in the default WHERE clause in the Table Builder, Map Builder, and Chart Builder.

Available URL Parameters

Use these variables in your queries as demonstrated in the examples below.

Parameter	Type	Description
httpGet['param_name']	string	GET parameter value.
httpPost['param_name']	string	POST parameter value.
httpRequest['param_name']	string	GET and POST parameter values.

Examples

✨ Filter by Student ID

Using httpPost:

WHERE student_id = httpPost['student_id'] 
  AND httpPost['student_id'] IS NOT NULL

URL EXAMPLE: YOURDOMAIN.com/?student_id=1

Using httpGet:

WHERE student_id = httpGet['student_id'] 
  AND httpGet['student_id'] IS NOT NULL

✨ Conditional Wildcard Search

WHERE first_name LIKE IF(
  httpGet['student_firstname'] IS NULL,
  first_name,
  CONCAT('%', httpGet['student_firstname'], '%')
)

✨ Fallback to All Rows

WHERE student_id = IFNULL(httpPost['student_id'], student_id)

Shows specific student when parameter exists, all students otherwise.

🛡️ Security Notes

• All values are auto-sanitized. 🔒
• Parameter names must be written in lowercase.
• Returns NULL for missing params.