Caravan Database Reporting Tool

Caravan Database Reporting Tool

This example shows how to produce a CSV file from the reminder table including relational fields from client and patient tables. in this example we will ask the question. "What Vaccination Types were given between 1-1-11 and 1-1-13. We will include the Manufacturer and Serial Number.

Find starting table and press "+".

Begin query in target table "Select"

Select the fields in the target table you want to report on.

Add "Where/Get" Restrictions

1) Click on fields in the query
2) to add "where" restrictions - in this case a time field allows for
3) Apply additional SQL criteria.

1) Explode related patient table and add fields.
2) Explode subrelations and add fields.

Generate Report

1) Click on Generate Report
2) Name report and click OK

Find Report on Local Desktop an Open

1) CSV file will be downloaded locally.
NOTE: larger reports may take time to generate before they down

This example open in CSV

Report took less than 30 seconds to generate.


    • Related Articles

    • Tag tool for VETport

      List of all unique Tool Tags for use in VETport email template This are all unique tag list which can be used in any email template. $$clinicadd$$ - will be replaced by Clinic Name & Address $$cliniccontactinfo$$ - will be replaced by the Clinic ...

    • REQUIRED(All) Caravan Setup

      Local Caravan installation for capturing lab, radiology, and other equipments output for transmission from the local Caravan to VETport on the cloud. Download and Install Vetport_equipments Folder 1) Clinic must send PC credentials and Teamview Host ...

    • Legacy - How to use Tag tool

      Go to settings to make changes in template by using tags Select any template to change or in which you want to make changes Select any template in which you want to make changes. Click on Tag tool to check available Tags for template List of Tags ...

    • Legacy - If the Client is not in the database - Add Full Client Information

      In case where the client is not in the system you can add the client information Alternate way to Add new client. Click on Registration >> Add Client Adding Client details   Fill general details in Client Form. Red highlighted fields are mandatory ...

    • Next Gen - How to use Tag Tool ?

      Go to "Preferences" >> "Templates & Attachments">> "Default Templates">> to make changes in template by using tags Step 1: Go to "Preferences" Step 2: Go to "Templates and Attachments" Step 3: Select "Default Templates" Select the Templates that you ...