{"id":50925,"date":"2022-03-13T16:07:40","date_gmt":"2022-03-13T15:07:40","guid":{"rendered":"https:\/\/www.stormcorp.ch\/?page_id=50925"},"modified":"2024-04-02T17:02:44","modified_gmt":"2024-04-02T16:02:44","slug":"academy-for-developers","status":"publish","type":"page","link":"https:\/\/www.stormcorp.ch\/index.php\/academy-for-developers\/","title":{"rendered":"Academy for developers"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; background_image=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2022\/03\/photo-1468276311594-df7cb65d8df6.jpg&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;2_5,3_5&#8243; use_custom_gutter=&#8221;on&#8221; gutter_width=&#8221;1&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; border_radii=&#8221;on|15px|15px|15px|15px&#8221; border_width_bottom=&#8221;3px&#8221; border_color_bottom=&#8221;#afafaf&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1 style=\"padding-left: 40px;\">Academy<br \/><strong>FOR DEVELOPERS<\/strong><\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2022\/03\/Academy-.png&#8221; title_text=&#8221;Academy&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;Arial||||||||&#8221; text_text_color=&#8221;#0C71C3&#8243; text_font_size=&#8221;18px&#8221; text_line_height=&#8221;1.8em&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\">How to create a new project<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;15px||||false|false&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>In this academy, you&#8217;ll learn how to create a new project, understand your database hierarchy, select tables for drill down and code resolution, add missing foreign keys, create a configuration, add widgets to the dashboard, edit SQL queries, edit factors, edit the loading dialog.<\/p>\n<p><strong>Prerequisite:<\/strong><\/p>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/index.php\/academy-for-users\/&#8221; button_text=&#8221;Academy for users&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; custom_margin=&#8221;|||15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/index.php\/features\/#for_developers&#8221; button_text=&#8221;Key features for developers&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; custom_margin=&#8221;|||15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;|||15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Table of content:<\/strong><\/p>\n<p>[\/et_pb_text][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][et_pb_button button_url=&#8221;#NewProject&#8221; button_text=&#8221;Project : New&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#database-copy&#8221; button_text=&#8221;Project: Copy \/ Past&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#project_database&#8221; button_text=&#8221;Project: Database&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#project_options&#8221; button_text=&#8221;Project: Options&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][et_pb_button button_url=&#8221;#DB_schema&#8221; button_text=&#8221;Schema&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#Inspect&#8221; button_text=&#8221;Schema: Inspect&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#database_structure&#8221; button_text=&#8221;Schema: DB Structure&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#database_drilldown&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Schema: DB Drill down&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#my_drill_down&#8221; button_text=&#8221;Schema: My Drill down&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#create_config&#8221; button_text=&#8221;Schema: Create config&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][et_pb_button button_url=&#8221;#configuration&#8221; button_text=&#8221;Configuration&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#configuration_system_objects&#8221; button_text=&#8221;Configuration: System objects&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#configuration_widget_objects&#8221; button_text=&#8221;Configuration: Widget objects&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][et_pb_button button_url=&#8221;#console&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;System: Console&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][et_pb_button button_url=&#8221;#query_template&#8221; button_text=&#8221;Query: Template&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#query_macro&#8221; button_text=&#8221;Query: Macro&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][et_pb_button button_url=&#8221;#globals_data&#8221; button_text=&#8221;Globals data&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][et_pb_button button_url=&#8221;#factor_code_resolution&#8221; button_text=&#8221;Factor: Pointer&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#total_sum&#8221; button_text=&#8221;Factor: Total&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#expression&#8221; button_text=&#8221;Factor: Expression&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#factor_date&#8221; button_text=&#8221;Factor: Date&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#factor_image&#8221; button_text=&#8221;Factor: Image&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][et_pb_button button_url=&#8221;#unpin_widget&#8221; button_text=&#8221;Dashboard: Unpin widget&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#add_widget&#8221; button_text=&#8221;Dashboard: Add widget&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#add_page&#8221; button_text=&#8221;Dashboard: Add \/ Remove page&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#widget_copy_past&#8221; button_text=&#8221;Widget Copy \/ Paste&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][et_pb_button button_url=&#8221;#dataset&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Dataset&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#dataset_query&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Dataset: Query&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#dataset_paramset&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Dataset: Paramset&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#dataset_join&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Dataset: Join&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#dataset_drilldown&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Dataset: Drill down&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#dataset_details&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Dataset: Details&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][et_pb_button button_url=&#8221;#paramset&#8221; button_text=&#8221;Paramset&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#param_properties&#8221; button_text=&#8221;Param: Properties&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#param_query&#8221; button_text=&#8221;Param: Query&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#param_date&#8221; button_text=&#8221;Param: Date&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_button button_url=&#8221;#param_decimal&#8221; button_text=&#8221;Param: Decimal&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#0c71c3&#8243; button_border_width=&#8221;0px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;NewProject&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>PROJECT: NEW PROJECT<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_NewProject.png&#8221; title_text=&#8221;Academy_dev_NewProject&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>+ New project<\/strong>: create new project<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Creation of a new project begins with the selection of an empty target folder in which\u00a0 XML objects will be stored.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li>Login screen: click on <strong>+ New project<\/strong><\/li>\n<li>Select an empty folder, for exemple <strong>..\\storm.projects\\AcademyForDev<\/strong>.<\/li>\n<li>Folder name will become the project name<\/li>\n<li>An empty config is then created<\/li>\n<li><strong>Sign in <\/strong>(no password)<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;database-copy&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>PROJECT: COPY \/ PAST<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Project_CopyDefinition.png&#8221; title_text=&#8221;Academy_dev_Project_CopyDefinition&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px||15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Copy definition<\/strong>: <em>Demo &#8211; Human ressources<\/em> project<\/span><\/p>\n<p><span><\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px||15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Avoid having to enter it manually in the new project.<\/p>\n<p><span><\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps<\/span><\/p>\n<ol>\n<li>Login to project: Demo &#8211; Human ressources<\/li>\n<li>Configuration -&gt; Projects-&gt; Demo -Human ressources -&gt; Right-click -&gt; <strong>Copy definition<\/strong><\/li>\n<li><strong>Past<\/strong> to the new project<strong><\/strong><\/li>\n<li><strong>Save<\/strong><\/li>\n<li><strong>Login <\/strong>again to get new projects<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;project_database&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>PROJECT: DATABASE<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_NewProject_Project_Past2.png&#8221; title_text=&#8221;Academy_dev_NewProject_Project_Past2&#8243; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Databases:<\/strong> connection information\u00a0<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><span>Enter database id, database engine, pilots, host, port and datasource where to connect. <\/span><\/p>\n<p><span>Add other databases by adding rows.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Database:<\/strong><\/p>\n<ul>\n<li><strong>Id<\/strong>: Database ID<\/li>\n<li><strong>Engine<\/strong>: double-click to get possible list<\/li>\n<li><strong>Driver<\/strong>: UseODBC if no native driver is installed<\/li>\n<li><strong>Host<\/strong>: of database<\/li>\n<li><strong>Port<\/strong>: to connect<\/li>\n<li><strong>User: <\/strong>Can saved into project if it is used by StormServer<\/li>\n<li><strong>Password<\/strong>: will be encrypted into the xml project source file<\/li>\n<li><strong>Schema<\/strong>: Double-click to get the list<\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;project_database&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>PROJECT: FOLDERS<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Project_Folders.png&#8221; title_text=&#8221;Academy_dev_Project_Folders&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Folders:<\/strong> list of repositories<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><span>A root folder can be specify. If empty, the project selected folder will be used.<\/span><\/p>\n<p><span><em>Business<\/em>, <em>core<\/em> and <em>report<\/em> repositories are created by <strong>+New project<\/strong>\u00a0<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Folders:<\/strong><\/p>\n<ul>\n<li><strong>Id<\/strong>: Repository Id<\/li>\n<li><strong>Path<\/strong>: absolute or relative path to repository<\/li>\n<li><strong>Alias<\/strong>: for final user<\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;project_options&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>PROJECT: OPTIONS<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Project_Options.png&#8221; title_text=&#8221;Academy_dev_Project_Options&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><span><strong>Options<\/strong>: default users login, projects options, speed dial background image<\/span><\/p>\n<p style=\"text-align: center;\"><span><\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Other option are described in server installation<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li><strong>Speed dial background image<\/strong> to select an image<\/li>\n<li>Save<\/li>\n<li>Relogin<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;DB_schema&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>SCHEMA<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Schema2.png&#8221; title_text=&#8221;Academy_dev_Schema2&#8243; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Schema<\/strong>: database hierarchy, drill down and code tables, create a config<\/span><\/p>\n<ul><\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: left;\">Hiearchy and data\u00a0 must be analysed to understand what are <strong>Drill down tables<\/strong> and <strong>Code tables<\/strong>.<\/p>\n<ul><\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Schema:<\/strong><\/p>\n<ul>\n<li style=\"text-align: left;\"><strong>Load schema<\/strong>: Load schema meta data<\/li>\n<li style=\"text-align: left;\"><strong>Save Schema<\/strong>: Save selected Drilldown and Code table, Added foreign keys and Code resolution (column)<\/li>\n<li style=\"text-align: left;\"><strong>Drilldown -&gt; DB structure<\/strong>: Hierarchy of foreign key<\/li>\n<li style=\"text-align: left;\"><strong>Drilldown -&gt; DB drilldown<\/strong>: Drilldown tree for the whole database<\/li>\n<li style=\"text-align: left;\"><strong>Drilldown -&gt; My drilldown<\/strong>: Drilldown tree for dashboard tables only<\/li>\n<li style=\"text-align: left;\"><strong>Create config<\/strong>: Create an XML configuration<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Tables:<\/strong><\/p>\n<ul><\/ul>\n<ul>\n<li style=\"text-align: left;\"><strong>Find<\/strong>: A table in shema<\/li>\n<li style=\"text-align: left;\"><strong>Primary key<\/strong>: DB primary key<\/li>\n<li style=\"text-align: left;\"><strong>Foreign keys<\/strong>: Formated DB foreign keys<\/li>\n<li style=\"text-align: left;\"><strong>Drill down keys<\/strong>: Formated drill down key (calculated by Storm)<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><strong>\u00a0Tables for configuration:<\/strong><\/p>\n<ul>\n<li><strong>Code resolution (column)<\/strong>: Column containing the text corresponding to the code (if it&#8217;s always the same field name)<\/li>\n<li><strong>Drill down tables<\/strong>: Become dashboards<\/li>\n<li><strong>Code tables<\/strong>: Loaded ans stay in\u00a0 memory as <strong>Global data<\/strong><\/li>\n<li><strong>Added foreign keys<\/strong>: Missing foreign keys<\/li>\n<li><strong>Db foreign keys<\/strong>: Formated list<\/li>\n<\/ul>\n<p>A table can be selected twice, as code and then also for drill down. If no tables are selected, all tables are considered as drill down table.<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Right-click menu on table<\/span><\/p>\n<p><strong>Inspect<\/strong>: Display non formated and formated data<\/p>\n<p><strong>Drill down<\/strong>: Tree starting from selected table.<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Press shift and roll-over:<\/span><\/p>\n<ul>\n<li>\u00a0<strong>Table name<\/strong> to get a tips with data preview<\/li>\n<\/ul>\n<p style=\"text-align: left;\">\n<ul><\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Info:<\/strong><\/p>\n<p><strong>Tables<\/strong>: Tables list with database information<\/p>\n<p><strong>Columns<\/strong>: Fields list with meta data<\/p>\n<p><strong>Primary keys<\/strong>: Database primary key definitions and formated primary keys<\/p>\n<p><strong>Foreign keys<\/strong>: Database foreign key definitions and formated foreign keys<\/p>\n<ul><\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Keymaker:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>Table\/Column<\/strong>: Tables with foreign key to be defined<\/p>\n<p style=\"text-align: left;\"><strong>FK Tables\/Column<\/strong>: Foreign tables with pointed foreign field<\/p>\n<ul><\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>DB Search:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>Searches<\/strong>: Enter find string<\/p>\n<p style=\"text-align: left;\"><strong>Find<\/strong>: Search for text through all fields of all tables<\/p>\n<ul><\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li>Clik on <strong>Load schema<\/strong> selecting the desired schema in case of multiple schemas<\/li>\n<li>Drag and drop <span style=\"text-decoration: underline;\">tables with data<\/span>, from schema table list to <strong>Dashboard tables<\/strong> (to get one dashboard per selected table)<\/li>\n<li>Drag and drop <span style=\"text-decoration: underline;\">tables with codes<\/span>, from schema table list to <strong>Code tables<\/strong> (for automatic code resolution)<\/li>\n<li><strong>Del key<\/strong> to remove a selected table<\/li>\n<li>Define the <strong>Code resolution (column)<\/strong><\/li>\n<li><strong>Save schema<\/strong><\/li>\n<li><strong>Create config<\/strong> -&gt; Select Core repository<\/li>\n<li>Exit and login again<\/li>\n<\/ol>\n<ul><\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;Inspect&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>SCHEMA: INSPECT<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Schema_Inspect.png&#8221; title_text=&#8221;Academy_dev_Schema_Inspect&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Schema_Inspect_Columns.png&#8221; title_text=&#8221;Academy_dev_Schema_Inspect_Columns&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Schema_Inspect_Keys.png&#8221; title_text=&#8221;Academy_dev_Schema_Inspect_Keys&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Schema_Inspect_Tree.png&#8221; title_text=&#8221;Academy_dev_Schema_Inspect_Tree&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Schema_Inspect_Query.png&#8221; title_text=&#8221;Academy_dev_Schema_Inspect_Query&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Inspect:<\/strong> data preview and meta data\u00a0 \u00a0<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Data:<\/strong><\/p>\n<ul>\n<li><strong>DB view:<\/strong> Non formated data.<\/li>\n<li><strong>List view:<\/strong> Formated data with column name, according to factor definition.<\/li>\n<\/ul>\n<ul><\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Columns:<\/strong><\/p>\n<ul>\n<li><strong>Column<\/strong>: Table layout with meta data<\/li>\n<li><strong>Keys<\/strong>: Formated Foreign and Drill down keys<\/li>\n<\/ul>\n<ul><\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Keys:<\/strong><\/p>\n<ul>\n<li><strong>Foreign keys<\/strong>: of current tables, with formated one<\/li>\n<li><strong>Drill down keys<\/strong>: of current table, with formated one<\/li>\n<\/ul>\n<ul><\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Tree:<\/strong><\/p>\n<ul>\n<li><strong>Drill up<\/strong>: Tree\u00a0 from current table<\/li>\n<li><strong>Drill down<\/strong>: Tree from current table<\/li>\n<\/ul>\n<ul><\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Query:<\/strong><\/p>\n<ul>\n<li><strong>Sql<\/strong>: Query template with JOIN to father tables<\/li>\n<li><strong>Run query<\/strong>: to execute it<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps<\/span><\/p>\n<ol>\n<li>Select a table with Right-click -&gt; Inspect<\/li>\n<\/ol>\n<ul><\/ul>\n<ul><\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;database_structure&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>SCHEMA: DB STRUCTURE<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Schema_DB-Structure.png&#8221; title_text=&#8221;Academy_dev_Schema_DB Structure&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>DB structure:<\/strong> hierarchy of the database as a tree<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><span>For each table, foreign key pointing to primary key tables are displayed.<\/span><\/p>\n<p><span>Depending on database size and complexity, this tree can be huge. By default we display only one level, but it can be expand.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px||15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Click on:<\/span><\/p>\n<ul>\n<li><strong>Add level<\/strong>,\u00a0 to add one level<\/li>\n<li><strong>Fold<\/strong> \/ <strong>Unfold <\/strong>to colaps \/ expand tree<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Drag and Drop:<\/span><\/p>\n<ul>\n<li>Drag and drop a node in the Drilldown table,\u00a0 to select the entire hierarchy below that node<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Shift + roll over:<\/span><\/p>\n<ul>\n<li>To get tips with preview of data<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px||15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li>Drilldown -&gt; <strong>DB structure<\/strong><\/li>\n<li><strong>+ Add level <\/strong>(tree can become huge)<\/li>\n<li>Drag and drop a node in the Drilldown table<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;database_drilldown&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>SCHEMA: DB DRILLDOWN<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Schema_DB-Drilldown.png&#8221; title_text=&#8221;Academy_dev_Schema_DB Drilldown&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>DB drill down:<\/strong> database drill down in tree form<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><span>Display fathers top tables of database, and related childs tables where to drilldown.<\/span><\/p>\n<p><span>Depending on database size and complexity, this tree can be huge. By default we display only one level, but it can be expand.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Click on:<\/span><\/p>\n<ul>\n<li><strong>+ Add level<\/strong>,\u00a0 to add one level<\/li>\n<li><strong>Fold<\/strong> \/ <strong>Unfold <\/strong>to colaps \/ expand tree<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Shift + roll over :<\/span><\/p>\n<ul>\n<li>To get tips with preview of data<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ul>\n<li>Drilldown -&gt; <strong>DB drilldown<\/strong><\/li>\n<li><strong>+ Add level <\/strong>(tree can become huge)<\/li>\n<li>Drag and Drop a node to Drilldown table,\u00a0<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;my_drill_down&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>SCHEMA: MY DRILL DOWN<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Schema_My-Drilldown.png&#8221; title_text=&#8221;Academy_dev_Schema_My Drilldown&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>My Drill down<\/strong>: drill down for selected tables as a tree<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><span>Display fathers top tables, and related childs tables where to drilldown.<\/span><\/p>\n<p><span>This hierarchy must be validated before to <strong>Create config<\/strong>.<\/span><\/p>\n<p><span>Depending on database size and complexity, this tree can be huge. By default we display only one level, but it can be expand.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Click on:<\/span><\/p>\n<ul>\n<li><strong>+ Add level<\/strong>,\u00a0 to add one level<\/li>\n<li><strong>Fold<\/strong> \/ <strong>Unfold <\/strong>to colaps \/ expand tree<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Shift + roll over :<\/span><\/p>\n<ul>\n<li>To get tips with preview of data<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li>Check that the Drilldown tree corresponds to the desired business logic<\/li>\n<li>Click on <strong>Create config<\/strong><\/li>\n<\/ol>\n<ul><\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;create_config&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>SCHEMA: CREATE CONFIG<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Schema_CreateConfig.png&#8221; title_text=&#8221;Academy_dev_Schema_CreateConfig&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Create config<\/strong>: generate configuration<\/span><\/p>\n<ul><\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>A configuration is a set of XML source files stored in repositories, mainly in <em>Core<\/em>.<\/p>\n<p>Incremental Create config will not erase previous updated objects.<span><\/span><\/p>\n<ul><\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\">\u00a0The following main objects are created:<\/p>\n<ul>\n<li>Dashboard<\/li>\n<li>Dataset<\/li>\n<li>Paramset<\/li>\n<li>Query<\/li>\n<li>Factor<\/li>\n<li>..<\/li>\n<\/ul>\n<ol><\/ol>\n<ul><\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_margin=&#8221;||||false|false&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li>Tools -&gt; <strong>DB Schema<\/strong><\/li>\n<li><strong>Create config<\/strong> to generate all objects<\/li>\n<li><strong>Exit<\/strong><\/li>\n<li><strong>Login<\/strong> again to load generated config<\/li>\n<li><strong>Configuration<\/strong> display generated objects<\/li>\n<li>Right-click <strong>Edit<\/strong> object<\/li>\n<\/ol>\n<ul><\/ul>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;configuration&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>CONFIGURATION<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Schema_CreateConfig_Configuration2.png&#8221; title_text=&#8221;Academy_dev_Schema_CreateConfig_Configuration2&#8243; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Configuration <\/strong>: Objects stored in repositories<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: left;\">An object is *.xml source code.<\/p>\n<p style=\"text-align: center;\"><span>There are 2 categories of objects: <\/span><\/p>\n<ul>\n<li style=\"text-align: left;\"><span><strong>System objects<\/strong>:\u00a0 Developers objects<\/span><\/li>\n<li style=\"text-align: left;\"><strong>Widget objects<\/strong>: Users objects.<\/li>\n<\/ul>\n<p style=\"text-align: center;\">\n<p style=\"text-align: center;\">Objects locations:<\/p>\n<p>In general, system objects and standard widget objects are stored in the &#8230;\\Core repository.<\/p>\n<p>User-defined widget objects and user-customized dashboards are stored in a dedicated repository.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_margin=&#8221;||||false|false&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li><strong>Project<\/strong>: Add specific repositories<\/li>\n<li><strong>User<\/strong>: Allow repositories to end-user<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;configuration_system_objects&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>CONFIGURATION: SYSTEM OBJECTS<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_config_objects_system.png&#8221; title_text=&#8221;Academy_dev_config_objects_system&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>System objects <\/strong>: Developers objects<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: left;\">These objects are not visible to end users. They are generated by Create config or manually by a developer.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\">\u00a0The main <strong>System objects<\/strong> are:<\/p>\n<ul>\n<li><strong>Project<\/strong>: Database, folders,\u00a0 dataserver options, locale, SMTP<\/li>\n<li><strong>User<\/strong>: Authentication, permissions, startmenu<\/li>\n<li><strong>Startmenu<\/strong>: Available dashboards grouped by business need<\/li>\n<li><strong>Dashboard<\/strong>: <span>Document displaying data into widgets<\/span><\/li>\n<li><strong>Dataset<\/strong>: <span>Populated with queries result <\/span><span>and filtered by paramset<\/span><\/li>\n<li><strong>Paramset<\/strong>: Parameters for data loading:<\/li>\n<li><strong>Query<\/strong>: SQL query template<\/li>\n<li><strong>Factor<\/strong>:\u00a0 Data type, total and options<\/li>\n<li><strong>Style<\/strong>: for factor<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\">Additionnal <strong>System objects<\/strong> are:<\/p>\n<ol><\/ol>\n<ul>\n<li><strong>Dbschema<\/strong>: Tables for configuration, foreign keys, variables<\/li>\n<li><strong>Replace<\/strong>: Placeholder source code (macro)<\/li>\n<li><strong>Script<\/strong>: JavaScript functions<\/li>\n<li><strong>Dictionnary<\/strong>: Static or query based translation<\/li>\n<li><strong>Datagrid<\/strong>: Layout of details windows<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_margin=&#8221;||||false|false&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li><strong>Configuration<\/strong>: Open an object type node<\/li>\n<li><strong>Right-click -&gt; Edit<\/strong>: on selected object<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li><strong>+New<\/strong>: On object type<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;configuration_widget_objects&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>CONFIGURATION: WIDGET OBJECTS<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_config_objects_widgets.png&#8221; title_text=&#8221;Academy_dev_config_objects_widgets&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Widget objects<\/strong>: Users objects<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>These objects are intended for end users. Initial objects are first created by developers, then managed by end-users.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\">\u00a0The main <strong>Widget objects<\/strong> are:<\/p>\n<ul>\n<li><strong>Kpi<\/strong>: Key paramaters indicator<\/li>\n<li><strong>List<\/strong>: Rows and columns with totals<\/li>\n<li><strong>Pivot<\/strong>: Tree with distributed columns<\/li>\n<li><strong>Pivotlist<\/strong>: Combination of a pivot with a list<\/li>\n<li><strong>Chart<\/strong>: Different type of charts<\/li>\n<\/ul>\n<ul><\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\">Additionnal <strong>Widget objects<\/strong> are:<\/p>\n<ul>\n<li><strong>Report: <\/strong>Design with NCReportDesigner<br \/><strong><\/strong><\/li>\n<li><strong>Geomap<\/strong>: World map<\/li>\n<li><strong>Heatmap<\/strong>: Map with<\/li>\n<li><strong>Htmlapp<\/strong>: Html pages with placeholder for variable<\/li>\n<li><strong>Notepad<\/strong>: Editor to format text<\/li>\n<li><strong>Textapp<\/strong>:<\/li>\n<li><strong>Label<\/strong>:<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_margin=&#8221;||||false|false&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li><strong>Configuration<\/strong>: Open an object type node<\/li>\n<li><strong>Right-click -&gt; Edit<\/strong>: on selected object<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;console&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>SYSTEM: CONSOLE<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_System.png&#8221; title_text=&#8221;Academy_dev_System&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Console<\/strong>: Execute SQL statement with log<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Copy\/past source code from <strong>Log<\/strong>, or enter it manually.<\/p>\n<p>SQL key word are highlighted.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Console<\/strong>:<\/p>\n<p><strong>SQL statement<\/strong>: Enter or copy\/past SQL native source code<\/p>\n<p><strong>SQL Query<\/strong>: Execute query on database engine<\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Log<\/strong>:<\/p>\n<p><strong>Log<\/strong>: History of database and Storm message.<\/p>\n<p>Log are per user, per login, per day and are stored in folder:<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>..\\storm.log<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul><\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Query tab<\/strong>:<\/p>\n<p>Displays data query result twice<\/p>\n<ul>\n<li><strong>DB view:<\/strong> non formated data.<\/li>\n<li><strong>List view<\/strong> Formated data, according to factor definition<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Click on:<\/span><\/p>\n<ul>\n<li><strong>Console<\/strong>: Past or enter SQL statement<\/li>\n<li><strong>Clear<\/strong>: Clear log<\/li>\n<li><strong>SQL Query<\/strong>: Execute SQL statement on database<\/li>\n<li><strong>Edit query<\/strong>: Manage query object<\/li>\n<li><b>Create dashboard: <\/b>Create a new dashboard, with all related objects<\/li>\n<\/ul>\n<ul><\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;query_template&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>QUERY: TEMPLATE<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Query_Template.png&#8221; title_text=&#8221;Academy_dev_Query_Template&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Query<\/strong>: SQL template<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Query template are generated by <strong>Create config<\/strong>, or can be created manually.<\/p>\n<p>The reserved spaces (placeholders) are enriched by the query compiler, depending on the loading parameters.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Placeholder:<\/strong><\/p>\n<p>Placeholders are variables replaced by values. The standards are as follows:<\/p>\n<ul>\n<li><span>${SCHEMA}<\/span><\/li>\n<li><span>${PARAMS}<\/span><\/li>\n<li><span>${CONTEXT}<\/span><\/li>\n<li><span>${LIMIT}<\/span><\/li>\n<\/ul>\n<p><span>Placeholders are also macro replaced by source code. The standards are as follows:<\/span><\/p>\n<ul>\n<li>${REPLACE_<em>Table<\/em>_SELECT}<\/li>\n<li>${REPLACE_<em>Table<\/em>_SELECT_REDUCED}<\/li>\n<li>${REPLACE_<em>JoinTable<\/em>_JOIN(<em>JoinTable<\/em>)}<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><b>Query template<\/b> structure:<\/p>\n<p style=\"padding-left: 80px;\"><span style=\"color: #ff00ff;\"><strong>SELECT<\/strong><\/span><\/p>\n<p style=\"padding-left: 80px;\"><strong>&#8212; {% if reduced %}<\/strong><\/p>\n<p style=\"padding-left: 120px;\"><em>The following macro will be inserted when we click on the corresponding Drill down tree node, this to obtain the number of records.<\/em><\/p>\n<p style=\"padding-left: 120px;\"><em>Selecting smaller columns set speeds up response times and reduces network traffic.<\/em><\/p>\n<p style=\"padding-left: 120px;\"><strong>${ReducedColumnsOfTableA}<\/strong><\/p>\n<p style=\"padding-left: 80px;\"><strong>&#8212; {% else %}<\/strong><\/p>\n<p style=\"padding-left: 120px;\"><em>Those macros will be executed when we click on Load.<\/em><\/p>\n<p style=\"padding-left: 120px;\"><em>We have one macro per join table, this to select at only one place the needed joins columns.<\/em><\/p>\n<p style=\"padding-left: 120px;\"><strong>${ColumnsOfTableA}<\/strong><\/p>\n<p style=\"padding-left: 120px;\"><strong>${ReducedColumnsOfTableJ1}<\/strong><\/p>\n<p style=\"padding-left: 80px;\"><strong>&#8212; {% endif %}<\/strong><\/p>\n<p style=\"padding-left: 80px;\"><span style=\"color: #ff00ff;\"><strong>FROM<\/strong><\/span><\/p>\n<p style=\"padding-left: 80px;\"><strong>${SCHEMA}.TableA <span style=\"text-decoration: underline;\">TableA<\/span><\/strong><\/p>\n<p style=\"padding-left: 80px;\"><em>Lest join to father tables are inserted, up to top father table.<\/em><\/p>\n<p style=\"padding-left: 80px;\"><span style=\"color: #ff00ff;\"><strong>LEFT JOIN<\/strong><\/span> <strong>${SCHEMA}.TableJ1 <span style=\"text-decoration: underline;\">TableJ1<\/span> ON (TableA.PkColumn = TableJ1.FkToPkColumn<\/strong><\/p>\n<p style=\"padding-left: 80px;\"><span style=\"color: #ff00ff;\"><strong>WHERE<\/strong><\/span><\/p>\n<p style=\"padding-left: 80px;\"><em>Reserved keyword to generate the where condition, according to load param or selected context.<\/em><\/p>\n<p style=\"padding-left: 80px;\"><strong>${PARAMS}<\/strong><\/p>\n<p style=\"padding-left: 80px;\"><strong>&#8212;<\/strong><\/p>\n<p style=\"padding-left: 80px;\"><strong>AND ${CONTEXT}<\/strong><\/p>\n<p style=\"padding-left: 80px;\"><strong>&#8212;<\/strong><\/p>\n<p style=\"padding-left: 80px;\"><strong><span style=\"color: #ff00ff;\">LIMIT<\/span> ${LIMIT}<\/strong><\/p>\n<p>\u00a0&#8220;- -&#8221; are separator to enclose code.<\/p>\n<p>Enclosed source code will be activated only if corresponding macro is populated. It can be used both in SELECT or in WHERE condition<\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Check list of your source code:<\/span><\/p>\n<ol>\n<li><strong>Apply<\/strong> to run query and check for SQL error<\/li>\n<li><b>Tables <\/b>must be prefix by <strong>${SCHEMA}.YourTable<\/strong><\/li>\n<li>Table must have an <strong>alias<\/strong> with the same name, this to be free of schema name in SELECT ..,\u00a0 in ON (..), and also with Params machinery<\/li>\n<li>In <b>Macro, <\/b>select only needed fields, this to speed-up your query<\/li>\n<li>Feel free to add ORDER BY, despite that sorting is easily done in List widget<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;query_macro&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>QUERY: MACRO<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Query_Macro.png&#8221; title_text=&#8221;Academy_dev_Query_Macro&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Macro<\/strong>: Pieces of source code used in many places<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><span>Macros are generated by <strong>Create config<\/strong>, or can be created and then inserted manually anywhere in the template.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Macro:<\/strong><\/p>\n<p><span>By default, Create config does not select foreign table fields in macros.<\/span><\/p>\n<p><span>In macros, they are all commented with: &#8211; &#8211;\u00a0<\/span><\/p>\n<p><span>To select fields, just uncomment them and press Save in macro editor:<\/span><\/p>\n<p style=\"padding-left: 40px;\">, %1.`FIRSTNME`<\/p>\n<p style=\"padding-left: 40px;\">, %1.`LASTNAME`<\/p>\n<p>In the case of duplicate columns in several tables, it is important to precede the field name with the table name. To do this, uncomment this piece of code in the macro.<\/p>\n<p style=\"padding-left: 40px;\">\u00a0AS `%1_<em>ColumnName<\/em>`<\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px||15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li>Dashboard -&gt; Edit -&gt; Properties-&gt;<strong> Query,<br \/><\/strong>or, Configuration -&gt; Query -&gt; Right-click -&gt; Edit<\/li>\n<li><strong>\u00a0Apply<\/strong> to run query<\/li>\n<li><strong>\u00a0Open selected macro <\/strong>to edit <strong>Replace<\/strong> object, for exemple to activate employee columns<\/li>\n<li><b>Expend macro<\/b> to replace macro with related source code (if really needed)<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;globals_data&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>GLOBALS DATA<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Globals.png&#8221; title_text=&#8221;Academy_dev_Globals&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Globals<\/strong>: data loaded in memory<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>They are used to:<\/p>\n<ul>\n<li>Speed up <strong>Code resolution<\/strong> for static data<\/li>\n<li>Calculate global sum<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Global data: <\/strong><\/p>\n<p>Global data is the result of queries executed during login. The data remains in memory. A periodic refresh can be defined in the project.<\/p>\n<p>The advantage of global data is that static codes, such as the list of currencies, countries, etc., are read just once, considerably speeding up code resolution.<\/p>\n<p>Queries for globals are generated without join or macro.<\/p>\n<p>Language code, if exist, and text to be displayed must be adjusted in select statement.<\/p>\n<p>Calculating global data can take time. To avoid slowing down login times, thoses queries will be marked as lazy.<\/p>\n<p>A progress bar for loading globals is displayed during login.<\/p>\n<p style=\"padding-left: 80px;\">[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li><strong>Tool-&gt; Schema<\/strong>: select code tables, before to create config<\/li>\n<li><strong>Tools -&gt; Globals -&gt; Show globals only<\/strong>: Click on SQL object to see the data in memory<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;factor_code_resolution&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>FACTOR: POINTER<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Factor_CodeResolution.png&#8221; title_text=&#8221;Academy_dev_Factor_CodeResolution&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Factor: Pointer<\/strong>: Replacing the code with the corresponding text stored in a foreign table<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>When a foreign key field points to a table selected as a <strong>Code table<\/strong>, <strong>Create config<\/strong> generates a new factor to automatically display the corresponding code text.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Factor pointer:<\/strong><\/p>\n<p>Create config genarate a new factor with the following Object Id and Alias:<\/p>\n<p style=\"text-align: left; padding-left: 40px;\"><strong>Object Id<\/strong>: FieldContainingCode_PTR_ForeignTableWithText<\/p>\n<p style=\"text-align: left; padding-left: 40px;\"><strong>Alias<\/strong>: FieldContainingCode -&gt; ForeignTableWithText<\/p>\n<p>If the code is a commercial code, the <strong>Code\/text factor<\/strong> box must be ticked, so that it is visible in the Tips (when you press Shift and move the mouse cursor over the cell).<\/p>\n<p style=\"padding-left: 80px;\">[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<p>If code tables are select in Schema panel, Create config will automatically generate a new factor with the resolved code.<\/p>\n<p>It can be done manually:<\/p>\n<ol>\n<li>Right-click on list column header -&gt; <strong>Edit columns<\/strong><\/li>\n<li><strong>Enable pointer<\/strong><\/li>\n<li><strong>Datasource<\/strong> globals query must be selected<\/li>\n<li><strong>Link<\/strong> is pair of fields, CodeField:PkOfForeignTable,..<\/li>\n<li>Click on <strong>Code\/text pair factor<\/strong>, if\u00a0 Tips must display the code<\/li>\n<li><strong>Expression<\/strong> to display the foreign text field<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;total_sum&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>FACTOR: TOTAL<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Factor_Sum.png&#8221; title_text=&#8221;Academy_dev_Factor_Sum&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Factor: Total<\/strong>:\u00a0 Functions for total line<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><span>A set of functions are available for total line, such as: SUM, SUM_ABS,&#8230;<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Total:<\/strong><\/p>\n<p>Select the desired function is the factor must be totalized.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ul>\n<li><strong>Right-click <\/strong>on column header Salary-&gt; <strong>Edit<\/strong><\/li>\n<li>Total select <strong>SUM, <\/strong>or desired function<\/li>\n<li><b>Save<\/b><\/li>\n<\/ul>\n<ul><\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;expression&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>FACTOR: EXPRESSION<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Factor_Expression.png&#8221; title_text=&#8221;Academy_dev_Factor_Expression&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Factor: Expression<\/strong>: Field name to be displayed or <strong>JavaScript<\/strong> expression<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><span>Reference to factor value must be enclosed with: <strong>${FactorID}<\/strong><\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><b>Expression:<\/b><\/p>\n<p>Expression or Mathematical expression are defined using javaScript.<\/p>\n<p>To know more about JavaScript:<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.w3schools.com\/js\/default.asp\">https:\/\/www.w3schools.com\/js\/default.asp<\/a><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ul>\n<li><strong>Right-click <\/strong>on column header Salary -&gt; + <strong>Insert<\/strong><\/li>\n<li>Enter Alias to be displayed<\/li>\n<li>Enter expression<\/li>\n<li><b>Save as<\/b><\/li>\n<\/ul>\n<ul><\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;factor_date&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>FACTOR: DATE<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Factor_Date3.png&#8221; title_text=&#8221;Academy_dev_Factor_Date3&#8243; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; hover_enabled=&#8221;0&#8243; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p><strong>Factor:<\/strong> <strong>Date<\/strong>: For database date field , all date types are generated<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Date:<\/strong><\/p>\n<p>For each date field in the database, Create config generates all kinds of dates.<\/p>\n<p>If a field is not a date, but does contain one, you must first set the database type to Date in Factor Edit.<\/p>\n<p>If the date storage is exotic, you can define the parse format:<\/p>\n<ul>\n<li>Factor Edit -&gt; Option -&gt; Date\/Time parse format.<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ul>\n<li><strong>List edit: <\/strong>Drag and Drop desired dates<\/li>\n<li><strong>Factor edit<\/strong>: Data type set to date_xxx<\/li>\n<li>Expression: must refer to original date<\/li>\n<\/ul>\n<ul><\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;factor_image&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>FACTOR: IMAGE<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Factor_Image.png&#8221; title_text=&#8221;Academy_dev_Factor_Image&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; hover_enabled=&#8221;0&#8243; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p><strong>Factor:<\/strong> <strong>Image<\/strong>: If the field contain a image<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Image:<\/strong><\/p>\n<p>The following format are supported:<\/p>\n<p><a href=\"https:\/\/doc.qt.io\/qt-6\/qimagereader.html#supportedImageFormats\">QImageReader Class | Qt GUI 6.6.3<\/a><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ul>\n<li><strong>Factor edit<\/strong>: Data type Image<\/li>\n<\/ul>\n<ul><\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;unpin_widget&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>DASHBOARD: UNPIN WIDGETS<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Dashboard_Unpin.png&#8221; title_text=&#8221;Academy_dev_Dashboard_Unpin&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px||15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Unpin widgets<\/strong>: Drag and drop position and size<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>The content of the dashboard page can be defined, by modifying the position and size of widgets and adding new widgets with specific objects, for the current dataset or for a connected dataset (next drill down level).<\/p>\n<p>Once the layout has been defined, <strong>Save<\/strong> the dashboard.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Click on:<\/span><\/p>\n<ul>\n<li style=\"text-align: left;\"><strong>Allign to grid<\/strong><\/li>\n<li style=\"text-align: left;\"><strong>Pin widgets<\/strong><\/li>\n<li style=\"text-align: left;\"><strong>Unpin widgets<\/strong><\/li>\n<li style=\"text-align: left;\"><strong>Cascade widgets<\/strong><\/li>\n<li style=\"text-align: left;\"><strong>Tile widgets<\/strong><\/li>\n<\/ul>\n<p><strong><\/strong><\/p>\n<ul>\n<li style=\"text-align: left;\"><strong>X <\/strong>to delete a widget<\/li>\n<li style=\"text-align: left;\"><strong>Save<\/strong> dashboard layout<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Double-Click on:<\/span><\/p>\n<ul>\n<li style=\"text-align: left;\"><strong>Page name <\/strong>to edit it<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li>Right-click on<strong> Page name -&gt; Unpine widgets<\/strong><\/li>\n<li><strong>Drag and Drop<\/strong> <strong>windows header<\/strong> to move it on grid<\/li>\n<li><b>Drag and Drop <\/b>bottom\/right\/corner to change size<\/li>\n<\/ol>\n<ul><\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;add_widget&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>DASHBOARD: ADD WIDGET<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Dashboard_AddWidget.png&#8221; title_text=&#8221;Academy_dev_Dashboard_AddWidget&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Add widgets<\/strong>: Select current or next level datasets<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>A widget is fed by a dataset.<\/p>\n<p>Adding a widget begins by selecting the current dataset or the next level. By default a List widget is displayed.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ul>\n<li><strong>+Add widget<\/strong><\/li>\n<li><strong>Click on a dataset:<\/strong> the current dataset, or any next level<\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;add_page&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>DASHBOARD: ADD \/ REMOVE PAGE<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Dashboard_AddPage.png&#8221; title_text=&#8221;Academy_dev_Dashboard_AddPage&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Add page<\/strong>: after current page<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><strong>Add page <\/strong>after current one. Then page sequence can be changed.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li>Right-click on <strong>Page name -&gt; Add \/ Remove page<\/strong><\/li>\n<li><strong>\u00a0Drag and Drop Page name <\/strong>to change sequence<\/li>\n<li><strong>Double-click<\/strong> on page name to edit it<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;widget_copy_past&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>WIDGET: COPY \/ PAST<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Widget_Copy.png&#8221; title_text=&#8221;Academy_dev_Widget_Copy&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Copy \/ Past<\/strong>: Widget object<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><strong>Copy <\/strong>Employee list widget object from Demo &#8211; Human resource, and <strong>Paste<\/strong> it to new project.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li><strong>Sign in<\/strong> to Demo &#8211; Human resource<\/li>\n<li>Employee dashboard<\/li>\n<li><strong>Page<\/strong> Pivot and list<\/li>\n<li><strong>Edit<\/strong> of Employee, sorted by Department<\/li>\n<li><strong>Copy<\/strong><\/li>\n<li>Back to new project<\/li>\n<li>List <strong>Edit<\/strong>-&gt; <strong>Paste<\/strong> -&gt; <strong>Apply<\/strong><\/li>\n<li><strong>Save<\/strong> -&gt; <strong>Create new List<\/strong> -&gt; Core -&gt; <strong>Finish<\/strong><\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;dataset&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>DATASET<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/04\/Academy_dev_Dataset2.png&#8221; title_text=&#8221;Academy_dev_Dataset2&#8243; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Dataset<\/strong>: is populated by one or several <strong>Query<\/strong> and filtered by one or several <strong>Paramset<\/strong><\/span><\/p>\n<p><span><\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Dataset:<\/strong><\/p>\n<p><strong>Query<\/strong>: Populating the dataset.<\/p>\n<p><strong>Paramset:<\/strong> Build Load window, with one paramset per JOIN table.<\/p>\n<p><strong>Join:<\/strong> Join queries are executed after dataset queries. The results of SQL queries are the parameters of join queries. Data will be merged in memory. Join query results become additional columns.<\/p>\n<p><strong>Drill down:<\/strong> to next level are defined.<\/p>\n<p><strong>Details:<\/strong> windows are defined.<\/p>\n<p><strong>Script:<\/strong> can be executed for data transformation.<\/p>\n<p><strong>Options<\/strong>:<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li>Click on Edit -&gt; Properties -&gt; <strong>Dataset<\/strong> -&gt; Dataset name<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;dataset_query&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>DATASET: QUERY<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/04\/Academy_dev_Dataset_Query.png&#8221; title_text=&#8221;Academy_dev_Dataset_Query&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Dataset<\/strong>: is populated by one or several <strong>Query<\/strong><\/span><\/p>\n<p><span><\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>In Demo &#8211; Human ressources, for Projects query, Create config generated a SQL left join with the employee table, because the employee table is a parent table.<\/p>\n<p>As a result, we can <strong>Load<\/strong> projects with project parameters, but also with employee parameters.\u00a0<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li>Right-click on a <strong>Query<\/strong> -&gt; Edit.<\/li>\n<li>Drag and Drop a query object to Datasource<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;dataset_paramset&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>DATASET: PARAMSET<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/04\/Academy_dev_Dataset_Paramset.png&#8221; title_text=&#8221;Academy_dev_Dataset_Paramset&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Dataset<\/strong>: is filtered by one or several <strong>Paramset<\/strong><\/span><\/p>\n<p><span><\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>In Demo &#8211; Human ressources,\u00a0 Create config has also generated project and employee <strong>Paramset<\/strong>.<\/p>\n<p>Create config does not generate parameters when we have a second join on the same table. If necessary, it can be added manually.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li>Right-click on a <strong>Paramset<\/strong> -&gt; Edit.<\/li>\n<li>Drag and Drop a query object to Datasource<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;dataset_join&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>DATASET: JOIN<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Dataset_Join.png&#8221; title_text=&#8221;Academy_dev_Dataset_Join&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Dataset<\/strong>: <strong>Join<\/strong> to merge additionnal query result with the initial result set<\/span><span><\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Join:<\/strong><\/p>\n<p><strong>Query<\/strong>: Join query wich will be executed with loaded data as parameters.<\/p>\n<p><strong>Contextual link:<\/strong> To define the link between current field value and sql where condition<\/p>\n<p><strong>Join link:<\/strong> To define the merge in memory<\/p>\n<p><strong>Propagate param:<\/strong> &#8230;<\/p>\n<p><strong>Param:<\/strong> .<\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>A Join query is used to read additional data for the initial result set and merge them as additional columns.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>In Demo &#8211; Sakila configuration, in the dashbpoard Customer, we have a Join query responsible to calculate the sum of rental per Customer.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li>Right-click on a <strong>Query<\/strong> -&gt; Edit.<\/li>\n<li>Set the Contextual link and the link.<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;dataset_drilldown&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>DATASET: DRILL DOWN<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Dataset_Drilldown.png&#8221; title_text=&#8221;Academy_dev_Dataset_Drilldown&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Dataset<\/strong>: <b>Drill down <\/b>Next level dataset where to Drill down<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>According to database drilldown key calculated by Storm, Drill down display the next level possibilities where to Drill down.<\/p>\n<p>It can be compared to a car driver arriving at a traffic circle. The exit roads are the possible routes down to the next traffic circle.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Drilldown:<\/strong><\/p>\n<p><strong>Dataset<\/strong>: Connected dataset for drilldown<\/p>\n<p><strong>Link<\/strong>: CurrentKeys_A, CurrentKeys_B,.. : ForeignKeys_A, ForeignKeys_B,..<\/p>\n<p><strong>Alias<\/strong>: Instead of default dashboard name<\/p>\n<p><strong>Enable<\/strong>: A drilldown can be desactivated<\/p>\n<p><strong>Stop branch<\/strong>: It will be the last possible drilldown<\/p>\n<p><strong>Context needed<\/strong>: Populate slave widget only if a context exist<\/p>\n<p><strong>Master sync:<\/strong><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li>Drag and Drop Dataset.<\/li>\n<li>Define the Link<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;dataset_details&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>DATASET: DETAILS<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Dataset_Details.png&#8221; title_text=&#8221;Academy_dev_Dataset_Details&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Dataset<\/strong>: <b>Details<\/b> Display details of selected records<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>It&#8217;s possible to display Details windows of current dataset, but also of all to father dataset.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Details:<\/strong><\/p>\n<p><strong>Enables<\/strong>: A details windows can be disable<\/p>\n<p><strong>Alias<\/strong>: Specific name<\/p>\n<p><strong>Data grid<\/strong>: Datagrid object id<\/p>\n<p><strong>Dataset<\/strong>: Connected dataset for details windwos<\/p>\n<p><strong>Link<\/strong>: CurrentKeys_A, CurrentKeys_B,.. : ForeignKeys_A, ForeignKeys_B,..<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li>Drag and Drop Dataset.<\/li>\n<li>Define the Link<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;paramset&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>PARAMSET<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Paramset2.png&#8221; title_text=&#8221;Academy_dev_Paramset2&#8243; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Paramset_load.png&#8221; title_text=&#8221;Academy_dev_Paramset_load&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; hover_enabled=&#8221;0&#8243; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Paramset<\/strong>: list of <strong>Load<\/strong> params for underlying tables<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><strong> Create config<\/strong> generates <strong>Paramset<\/strong>, with one <strong>Param<\/strong> per field.<\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Paramset:<\/strong><\/p>\n<ul>\n<li><strong>Field with a foreign key<\/strong>: it generates a &#8220;select distinct&#8221; query to obtain the list of elements to be selected in the loading dialog box. It also displays the resolved column in the <strong>Columnset<\/strong>.<\/li>\n<li><strong>Date<\/strong>: Date selector<\/li>\n<li><strong>Decimal<\/strong>: Numeric value<\/li>\n<li><strong>String<\/strong>: String value<\/li>\n<\/ul>\n<p><strong>Bind<\/strong>: A <strong>factor<\/strong> to an <strong>SQL field<\/strong>. The SQL field is prefixed by the table name.<\/p>\n<p>Operator: A default logical operator can be set.<\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li>Edit -&gt; Properties -&gt; Paramset &#8230;<\/li>\n<\/ol>\n<p><strong>+Add<\/strong>: a new param<\/p>\n<p><strong>Edit<\/strong> (or right-click Edit): current param<\/p>\n<p><strong>Remove<\/strong>: selected param<\/p>\n<p><strong>Sort<\/strong>:<\/p>\n<p><strong>Preview<\/strong>: Load params<\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;param_properties&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>PARAM: PROPERTIES<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Paramset_Properties.png&#8221; title_text=&#8221;Academy_dev_Paramset_Properties&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; hover_enabled=&#8221;0&#8243; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Param properties<\/strong>: SQL Bind, type, operators, options<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><b>Param properties:<\/b><\/p>\n<p><b>Alias<\/b>: to overhide factor name<\/p>\n<p><b>SQL Bind<\/b>: Table.Fieldname for the WHERE condition<\/p>\n<p><b>Icon<\/b>: specific icon<\/p>\n<p><b>Operators<\/b>: Logical operator for the WHERE condition<\/p>\n<p><strong>Value<\/strong>: Default value can be set<\/p>\n<p><strong>Enable<\/strong>: Enable the param<\/p>\n<p><strong>Show<\/strong>: Show it by default<\/p>\n<p><strong>Escaped<\/strong>: Enclose value with &#8216;<\/p>\n<p><strong>Editable<\/strong>: Value can be edited by the user<\/p>\n<p><strong>Mandatory<\/strong>: Cannot be empty<\/p>\n<p><strong>Propagate<\/strong>: Propagate to next level dataset<\/p>\n<p><strong>Date format<\/strong>: Parser for date<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li><strong>Param<\/strong>: Right-click -&gt; Edit<\/li>\n<li><strong>Preview<\/strong> to see it<\/li>\n<li><strong>Apply<\/strong>, and Save<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;param_query&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>PARAM: QUERY<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Paramset_Query.png&#8221; title_text=&#8221;Academy_dev_Paramset_Query&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Paramset_Distinct3.png&#8221; title_text=&#8221;Academy_dev_Paramset_Distinct3&#8243; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; hover_enabled=&#8221;0&#8243; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Param query<\/strong>: Field with a foreign key<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><strong>Create config<\/strong> generates a <strong>Query\u00a0<\/strong> with &#8220;select distinct&#8221; to obtain the list of elements to be selected in the <strong>Load<\/strong> dialog. It also displays the resolved column in the <strong>Columnset<\/strong>.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Query :<\/strong><\/p>\n<p>Query source code to populate the param list<\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li><strong>Param<\/strong>: Right-click -&gt; Edit<\/li>\n<li><strong>Query<\/strong>: Adjust the generated query according to your needs<\/li>\n<li><strong>Value factor<\/strong>: Select a Factor for SQL Bind<\/li>\n<li><strong>Columnset<\/strong>: Factor to be displayed<\/li>\n<li><strong>Preview<\/strong>: the param<\/li>\n<li><strong>Save<\/strong>: Paramset<\/li>\n<li>Close and reopen dashboard<\/li>\n<\/ol>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>In this example, the parameter EMPLOYEE.`EMPNO` has been manually enhanced to display the list of employees, with: job number, first name and last name. Multiple selection is allowed, to load selected employees.<\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;param_string&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>PARAM: STRING<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Paramset_String2.png&#8221; title_text=&#8221;Academy_dev_Paramset_String2&#8243; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; hover_enabled=&#8221;0&#8243; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Param string<\/strong>: String field<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>A string field, combined with the logical operator &#8220;Matches&#8221;, is used to find the desired records.<\/p>\n<p>A string field with no foreign key is a text field. The logical operator can be adapted accordingly.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li><strong>Param<\/strong>: Right-click -&gt; Edit<\/li>\n<li><strong>Operator<\/strong>: matches<\/li>\n<li><strong>Preview<\/strong>: the param<\/li>\n<li><strong>Save<\/strong>: Paramset<\/li>\n<li>Close and reopen dashboard<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;param_date&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>PARAM: DATE<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Paramset_Date.png&#8221; title_text=&#8221;Academy_dev_Paramset_Date&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Param date<\/strong>: Date field<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>A date field in the database will be converted into a date selector.<\/p>\n<p>A database field with a type string containing a date can be converted to a date by selecting the date type.<\/p>\n<p>Depending on the storage, to convert a wrong storage into a date, use:<\/p>\n<ul>\n<li>Factor edit -&gt; Option -&gt; Date\/Time parse format<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li><strong>Param<\/strong>: Right-click -&gt; Edit<\/li>\n<li><strong>Type<\/strong>: Date<\/li>\n<li><strong>Preview<\/strong>: the param<\/li>\n<li><strong>Save<\/strong>: Paramset<\/li>\n<li>Close and reopen dashboard<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;param_decimal&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#eaeaea&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; max_width=&#8221;90%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; header_text_color=&#8221;#0C71C3&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>PARAM: DECIMAL<\/h1>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ea21nybujzt.preview.infomaniak.website\/wp-content\/uploads\/2024\/03\/Academy_dev_Paramset_Decimal.png&#8221; title_text=&#8221;Academy_dev_Paramset_Decimal&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; transform_styles__hover_enabled=&#8221;on|hover&#8221; transform_scale__hover_enabled=&#8221;on|hover&#8221; transform_translate__hover_enabled=&#8221;on|desktop&#8221; transform_rotate__hover_enabled=&#8221;on|desktop&#8221; transform_skew__hover_enabled=&#8221;on|desktop&#8221; transform_origin__hover_enabled=&#8221;on|desktop&#8221; transform_scale__hover=&#8221;117%|117%&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_bottom=&#8221;4px&#8221; border_color_bottom=&#8221;#8e8e8e&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span><strong>Param decimal<\/strong>: Numeric field<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>A numerical field in the database will be converted into a numerical value input field.<\/p>\n<p>A default operator can be set.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;15px|15px|15px|15px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Steps:<\/span><\/p>\n<ol>\n<li><strong>Param<\/strong>: Right-click -&gt; Edit<\/li>\n<li><strong>Operator<\/strong>: set default<\/li>\n<li><strong>Preview<\/strong>: the param<\/li>\n<li><strong>Save<\/strong>: Paramset<\/li>\n<li>Close and reopen dashboard<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider _builder_version=&#8221;4.14.7&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>AcademyFOR DEVELOPERSHow to create a new projectIn this academy, you&#8217;ll learn how to create a new project, understand your database hierarchy, select tables for drill down and code resolution, add missing foreign keys, create a configuration, add widgets to the dashboard, edit SQL queries, edit factors, edit the loading dialog. Prerequisite:&nbsp; Table of content:PROJECT: NEW [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-50925","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.stormcorp.ch\/index.php\/wp-json\/wp\/v2\/pages\/50925","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stormcorp.ch\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.stormcorp.ch\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.stormcorp.ch\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stormcorp.ch\/index.php\/wp-json\/wp\/v2\/comments?post=50925"}],"version-history":[{"count":376,"href":"https:\/\/www.stormcorp.ch\/index.php\/wp-json\/wp\/v2\/pages\/50925\/revisions"}],"predecessor-version":[{"id":52478,"href":"https:\/\/www.stormcorp.ch\/index.php\/wp-json\/wp\/v2\/pages\/50925\/revisions\/52478"}],"wp:attachment":[{"href":"https:\/\/www.stormcorp.ch\/index.php\/wp-json\/wp\/v2\/media?parent=50925"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}