Key Stat - Data List

1 Overview

bxp has the ability to allow users to render on screen a custom data listing of data stored in a form. This can be achieved by using a custom SQL statement.

2 Creating a Key Stat Data Listing

To create a Key Stat Data Listing you must first navigate the following system path:

Main Menu > Key Stats > KeyStat - Add

Once here you will need to input the following settings to successfully create a Key Stat Data Listing.

1) Title - This should be an easily identifiable title for the key stat

2) Type - Set this to be Value

3) Query - Field(s) - This field should contain the fields that are being returned as part of you SQL statement (The fields should be separated by a ,)

4) Query - SQL - This field should contain the custom SQL statement that will get all of the information that you require.

5) Display Title - This is the headings that you want the information retrieved to have (The fields should be separated by a ,)

3 Adding the Key Stat Data Listing

Once you are happy that you have created the Key Stat Data listing correctly, you then need to add the data listing to the Key Stats Tab associated with a Key Stats Workbook. When adding the Data Listing Key Stat to your Key Stat Tab, you have to reference it in a different way to the standard way of referencing a key stat. It must be referenced in the following format:

--List-KeyStatId--

4 Example output