Dashboard widget configuration

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& ...

Special case: List of values i search parameters

Currently lists of search parameters are encoded

 ... &QUERY_VALUE_3=11344%2C11343%2C11345& ...

To make them work in list views, please decode the kommas

 ... &QUERY_VALUE_3=11344,11343,11345& ...