Data Layer

Owned by Testify
Aug 30, 2023
1 min read

Inhalt

The Standard Data Layer enables an independent evaluation of the collected data from Testify. Numerous queries are provided for this purpose, which correspond according to the subject area.

Data Layer Queries

Checklist Analysis

  • Checklist Analysis

  • Checklist Process Activities

  • Checklist CustomField

  • Periodic Assignment Analysis

  • Scoring Analysis

Issue Analysis

  • Issue Analysis

  • Issue Process Activities

  • Issue Category Hierarchy

  • Issue Custom Field

Test Case Analysis

  • Check Result Analysis

  • Statistical Result Analysis

Test Equipment Analysis

  • TestEquipment Analysis

  • TestEquipment Custom Field

Process Mining

  • Process Mining Sektionen

  • Process Mining Check Results

Other

  • Translations: For translating user-defined wording within Testify

Retrieving the Functions

The following functions can be retrieved:

  • Reporting_ChecklistAnalysis,

  • Reporting_IssueAnalysis,

  • Reporting_CheckResultAnalysis,

  • Reporting_ScoringAnalysis,

  • Reporting_StatisticalResultAnalysis

Enter the following SQL statements to call the functions:

  • select * from [test-tenant].Reporting_ChecklistAnalysis('de-AT', ‘en-US', ‘UTC’, ‘01.01.2022 00:00:00’)

Four parameters are always passed with the report function:

  • Language

    • in which language the data should be displayed

    • z.B.: de-AT, en-US ... -

  • Language2

    • Fallback language, if above language is not available

    • z.B.: de-AT, en-US ...

  • LocalTimeZone

    • Fallback language, if above language is not available

    • z.B: UTC

  • dateFrom

    • Checklists or issues last modified before this timestamp will be excluded.

    • z. B. 01.01.2020 00:00:0

The remaining functions are called without the fourth parameter (dateFrom):

  • select * from [test-tenant].Reporting_ChecklistProcessActivities('de-AT', ‘en-US', ‘UTC’)