Difference between revisions of "Telemarque Custom Data Views"

Revision as of 11:55, 13 March 2018

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

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.

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: set to CPI
Open Code: set to ROOT001
Filter Type: set to 0 (zero)
Field Aliases: leave blank
Field Pick Lists: leave blank
Hidden Fields: leave blank
Grouped Fields: leave blank

3) Press Save

@@ Line 4: / Line 4: @@
 . Open the Flexiview Config application:  Start Menu > Telemarque > Tools > Flexiview Config
 [[File:Startmenu.png]]
 . Select the Telemarque database from the drop down list & click ''Open''.
 . Sign in as SYSDBA with your password.
 [[File:Blank flexiviews.png]]