View source for Telemarque Custom Data Views

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

[[File:Startmenu.png]]

2. Select the Telemarque database from the drop down list & click ''Open''.
3. Sign in as SYSDBA with your password.

[[File:Blank flexiviews.png]]


== 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: 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'''