399
edits
Changes
From All n One's bxp software Wixi
Created page with "== Overview == BeX has the ability to allow users to render on screen a custom data listing of data from inside one of there forms. This can be achieved by useing a custom SQ..."
== Overview ==
bxp has the ability to allow users to render on screen a custom data listing of data from inside one of there forms. This can be achieved by useing a custom SQL statement.
== 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 ,)
[[File:KeyStatsListingSettings.png]]
bxp has the ability to allow users to render on screen a custom data listing of data from inside one of there forms. This can be achieved by useing a custom SQL statement.
== 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 ,)
[[File:KeyStatsListingSettings.png]]
