How to build reports via URL

Building reports via the URL can be really useful when you don't want to ensure a report exists or hasn't been modified, but documentation is pretty lacking on it.

Thankfully ralpho have seemed to figure out the url parameters.

Report type: List

Parameter Value
manual_labor true
form list
query encoded query
field_list comma separated list of fields you want
type list
table table

A few things to note;

  1. You can dot-walk on the fields regardless of role, so this is a great workaround to making some tricky reports for power users.
  2. You can add variables from sc_req_item if you can figure out the sys_id of variable

Here's an example report url I generated for someone the other day that included variables;