Inspections: Difference between revisions

Jump to navigation Jump to search

Inspections (view source)

Revision as of 12:51, 30 November 2021

480 bytes removed ,  30 November 2021
→‎Technical information
Line 195: Line 195:


All questionnaire data is saved as records on your backend server (Resco Cloud/Dynamics/Salesforce), in multiple custom entities:
All questionnaire data is saved as records on your backend server (Resco Cloud/Dynamics/Salesforce), in multiple custom entities:
* '''Questionnaire''' (resco_questionnaire) stores information about the questionnaire templates, snippets, and answered questionnaires. Each questionnaire can contain any number of question groups and questions. How is a particular questionnaire record used depends on the following properties:
* '''Questionnaire''' (resco_questionnaire) stores information about the questionnaire templates, snippets, and answered questionnaires.
** As a questionnaire template (if Is_Template = Yes)
** As a snippet (if Is_Snippet = Yes)
** As a filled-in questionnaire
 
* '''Question Group''' (resco_questiongroup) stores information about the question groups. Each question group can contain multiple questions.
* '''Question Group''' (resco_questiongroup) stores information about the question groups. Each question group can contain multiple questions.
* '''Question'''  (resco_question) stores all the questions created for the questionnaire, as well as answers.
* '''Questionnaire Folder''' (resco_questionnairefolder) stores information about the folder structure that organizes questionnaire templates in the designer.


* '''Question'''  (resco_question) stores all the questions created for the questionnaire, as well as answers. The unformatted answer value can be found in the Value (resco_value) field; formatted value in the Value Label (resco_valuelabel) field.
When an app user starts a questionnaire in the app, a new copy of the template is created. For an answered questionnaire, we store both questions and answers. When you enable template dependency, the answered questionnaire is no longer self-contained (it refers to the template) but each answer needs less data (faster sync and less database storage).
 
* '''Questionnaire Folder''' (resco_questionnairefolder) stores information about the folder structure that organizes questionnaire templates in the designer. Each folder can contain multiple questionnaire templates. Usually, this entity does not need to be enabled in the app project.
 
When an app user starts a questionnaire in the app, a new copy of the template is created. For an answered questionnaire, we store both questions and answers. This approach ensures that when you change your questionnaire template, existing answered questionnaires are not affected; historical records are not altered.


See also: [https://blog.resco.net/2020/06/02/resco-inpections-for-dynamics-365-data/ Dynamics 365 – how is the data stored?] {{Badge|Blog}}
See also:
* [[Resco Inspections data model]]
* [https://blog.resco.net/2020/06/02/resco-inpections-for-dynamics-365-data/ Dynamics 365 – how is the data stored?] {{Badge|Blog}}


=== Permissions ===
=== Permissions ===
Retrieved from "https://docs.resco.net/wiki/Special:MobileDiff/5926"

Navigation menu