Difference between revisions of "Dashboard widget configuration"
Jump to navigation
Jump to search
old>Admin |
old>Admin (→Query) |
||
| Line 11: | Line 11: | ||
=== Query === | === 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 === | === Special keywords / variables === | ||
Revision as of 09:44, 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%