Difference between revisions of "Telemarque Custom Data Views"

Revision as of 11:59, 13 March 2018

Telemarque supports the addition of custom views that allow the addition of SQL queries as views within the application main screen.

Opening the Flexiview Config

1. Open the Flexiview Config application: Start Menu > Telemarque > Tools > Flexiview Config

2. Select the Telemarque database from the drop down list & click Open.

3. Sign in as SYSDBA with your password.

4. Initially the list will be empty.

Adding a Flexiview

This will add a custom data view based on patient records (demographics).

1) Press the + sign on the toolbar (left hand side, just under the Open button)

2) Complete the fields opposite as follows:

• Order: a number, indicating the position of this custom view in the list of custom views in the Telemarque screen. Suggest starting at 100 and working upwards in increments of 10.
• View Name: a unique name describing what this view will show, e.g. "Missing NHS Numbers"
• Page Name: always set to Views
• User Name: leave blank or use your own Telemarque user name if you only want this to appear for yourself.
• Select SQL (required): copy and paste a valid SQL query into this box. Press Test to make sure it's working okay.
• Where SQL: leave blank
• ID Fields: always set to CPI
• Open Code: always set to ROOT001
• Filter Type: always set to 0 (zero)
• Field Aliases: leave blank
• Field Pick Lists: leave blank
• Hidden Fields: leave blank
• Grouped Fields: leave blank

3) Press Save

Repeat each step above with new values for Order, View Name and Select SQL. All other values will remain the same.

Using Flexiviews

Once you have all the flexiviews you need, start Telemarque (or exit and re-start) and the views will appear on the left hand side of the main application window.

Click on each one to see the contents. Double click a row to open the record in question.