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;
- You can dot-walk on the fields regardless of role, so this is a
great workaround to making some tricky reports for power users. - 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;
sys_report_template.do?sysparm_field_list=variables.71cba0540f5fb600503c590be1050ec0&sysparm_type=list&sysparm_table=sc_req_item&sysparm_from_list=true&sysparm_chart_size=large&sysparm_manual_labor=true&sysparm_query=cat_item%3Dc9d980750f437200503c590be1050e8a%5Ecat_item%3Dc9d980750f437200503c590be1050e8a