Difference between revisions of "Dashboard widget configuration"
Jump to navigation
Jump to search
old>Admin (→Query) |
old>Admin |
||
| Line 19: | Line 19: | ||
GROUP BY 1 | GROUP BY 1 | ||
=== Special keywords / variables === | ==== Special keywords / variables ==== | ||
* %UserID% | * %UserID% | ||
| Line 28: | Line 28: | ||
* %AndRecordFilter% | * %AndRecordFilter% | ||
=== Lists === | |||
To setup a list view, simple copy/paste the URL of a view. | |||
Optimally you should strip anything but the parameters from the URL | |||
?SagID=252&command=list&QUERY_FIELD_1=OPFLGNING& .... | |||
Revision as of 08:59, 4 March 2019
Buttons
All the below properties are required for the button
- ButtonGlyph: Icon of the button (3 options)
- FontAwesome glyph: fa-home
- Icon URL: http://starwars.com/LukeSkyWalker.png
- Single character: ”P”
- Title: Text below the icon
- Content: Url of the button
Query
Sample: Limited status distribution
SELECT s.Status, count(*) FROM data_leads1 as d JOIN formstatus as s ON s.StatusID = d.StatusID WHERE d.StatusID IN (11344,11343,11345) GROUP BY 1
Special keywords / variables
- %UserID%
- %ExclusiveGroupID%
- %GroupListSql%
- %ExclusiveGroupListSql%
- %AndRecordFilter%
Lists
To setup a list view, simple copy/paste the URL of a view.
Optimally you should strip anything but the parameters from the URL
?SagID=252&command=list&QUERY_FIELD_1=OPFLGNING& ....