Diskussion:De DE Metrik
Aus iDempiere de
Die Daten für die Metrik bekomme ich mit
select trl.ad_language,trl.ad_client_id,trl.istranslated,trl.isactive, count(*) --from ad_column_trl trl, ad_column o where o.ad_column_id=trl.ad_column_id AND o.ad_client_id=trl.ad_client_id --from ad_ctxhelpmsg_trl trl, ad_ctxhelpmsg o where o.ad_ctxhelpmsg_id=trl.ad_ctxhelpmsg_id AND o.ad_client_id=trl.ad_client_id --from ad_desktop_trl trl, ad_desktop o where o.ad_desktop_id=trl.ad_desktop_id AND o.ad_client_id=trl.ad_client_id --from ad_element_trl trl, ad_element o where o.ad_element_id=trl.ad_element_id AND o.ad_client_id=trl.ad_client_id --from ad_field_trl trl, ad_field o where o.ad_field_id=trl.ad_field_id AND o.ad_client_id=trl.ad_client_id --from ad_fieldgroup_trl trl, ad_fieldgroup o where o.ad_fieldgroup_id=trl.ad_fieldgroup_id AND o.ad_client_id=trl.ad_client_id --from ad_form_trl trl, ad_form o where o.ad_form_id=trl.ad_form_id AND o.ad_client_id=trl.ad_client_id --from ad_infocolumn_trl trl, ad_infocolumn o where o.ad_infocolumn_id=trl.ad_infocolumn_id AND o.ad_client_id=trl.ad_client_id --from ad_infowindow_trl trl, ad_infowindow o where o.ad_infowindow_id=trl.ad_infowindow_id AND o.ad_client_id=trl.ad_client_id --from ad_menu_trl trl, ad_menu o where o.ad_menu_id=trl.ad_menu_id AND o.ad_client_id=trl.ad_client_id --from ad_message_trl trl, ad_message o where o.ad_message_id=trl.ad_message_id AND o.ad_client_id=trl.ad_client_id --from ad_printformatitem_trl trl, ad_printformatitem o where o.ad_printformatitem_id=trl.ad_printformatitem_id AND o.ad_client_id=trl.ad_client_id --from ad_printlabelline_trl trl, ad_printlabelline o where o.ad_printlabelline_id=trl.ad_printlabelline_id AND o.ad_client_id=trl.ad_client_id --from ad_process_para_trl trl, ad_process_para o where o.ad_process_para_id=trl.ad_process_para_id AND o.ad_client_id=trl.ad_client_id --from ad_process_trl trl, ad_process o where o.ad_process_id=trl.ad_process_id AND o.ad_client_id=trl.ad_client_id --from ad_ref_list_trl trl, ad_ref_list o where o.ad_ref_list_id=trl.ad_ref_list_id AND o.ad_client_id=trl.ad_client_id --from ad_reference_trl trl, ad_reference o where o.ad_reference_id=trl.ad_reference_id AND o.ad_client_id=trl.ad_client_id --from ad_tab_trl trl, ad_tab o where o.ad_tab_id=trl.ad_tab_id AND o.ad_client_id=trl.ad_client_id --from ad_table_trl trl, ad_table o where o.ad_table_id=trl.ad_table_id AND o.ad_client_id=trl.ad_client_id --from ad_task_trl trl, ad_task o where o.ad_task_id=trl.ad_task_id AND o.ad_client_id=trl.ad_client_id --from ad_wf_node_trl trl, ad_wf_node o where o.ad_wf_node_id=trl.ad_wf_node_id AND o.ad_client_id=trl.ad_client_id --from ad_window_trl trl, ad_window o where o.ad_window_id=trl.ad_window_id AND o.ad_client_id=trl.ad_client_id --from ad_workbench_trl trl, ad_workbench o where o.ad_workbench_id=trl.ad_workbench_id AND o.ad_client_id=trl.ad_client_id --from ad_workflow_trl trl, ad_workflow o where o.ad_workflow_id=trl.ad_workflow_id AND o.ad_client_id=trl.ad_client_id --from c_charge_trl trl, c_charge o where o.c_charge_id=trl.c_charge_id AND o.ad_client_id=trl.ad_client_id --from c_country_trl trl, c_country o where o.c_country_id=trl.c_country_id AND o.ad_client_id=trl.ad_client_id --from c_currency_trl trl, c_currency o where o.c_currency_id=trl.c_currency_id AND o.ad_client_id=trl.ad_client_id --from c_doctype_trl trl, c_doctype o where o.c_doctype_id=trl.c_doctype_id AND o.ad_client_id=trl.ad_client_id --from c_dunninglevel_trl trl, c_dunninglevel o where o.c_dunninglevel_id=trl.c_dunninglevel_id AND o.ad_client_id=trl.ad_client_id --from c_elementvalue_trl trl, c_elementvalue o where o.c_elementvalue_id=trl.c_elementvalue_id AND o.ad_client_id=trl.ad_client_id --from c_greeting_trl trl, c_greeting o where o.c_greeting_id=trl.c_greeting_id AND o.ad_client_id=trl.ad_client_id --from c_paymentterm_trl trl, c_paymentterm o where o.c_paymentterm_id=trl.c_paymentterm_id AND o.ad_client_id=trl.ad_client_id --from c_tax_trl trl, c_tax o where o.c_tax_id=trl.c_tax_id AND o.ad_client_id=trl.ad_client_id --from c_taxcategory_trl trl, c_taxcategory o where o.c_taxcategory_id=trl.c_taxcategory_id AND o.ad_client_id=trl.ad_client_id --from c_uom_trl trl, c_uom o where o.c_uom_id=trl.c_uom_id AND o.ad_client_id=trl.ad_client_id --from cm_container_element_trl trl, cm_container_element o where o.cm_container_element_id=trl.cm_container_element_id AND o.ad_client_id=trl.ad_client_id --from cm_container_trl trl, cm_container o where o.cm_container_id=trl.cm_container_id AND o.ad_client_id=trl.ad_client_id --from cm_cstage_element_trl trl, cm_cstage_element o where o.cm_cstage_element_id=trl.cm_cstage_element_id AND o.ad_client_id=trl.ad_client_id --from cm_cstage_trl trl, cm_cstage o where o.cm_cstage_id=trl.cm_cstage_id AND o.ad_client_id=trl.ad_client_id --from m_product_trl trl, m_product o where o.m_product_id=trl.m_product_id AND o.ad_client_id=trl.ad_client_id --from pa_dashboardcontent_trl trl, pa_dashboardcontent o where o.pa_dashboardcontent_id=trl.pa_dashboardcontent_id AND o.ad_client_id=trl.ad_client_id --from pp_order_bom_trl trl, pp_order_bom o where o.pp_order_bom_id=trl.pp_order_bom_id AND o.ad_client_id=trl.ad_client_id --from pp_order_bomline_trl trl, pp_order_bomline o where o.pp_order_bomline_id=trl.pp_order_bomline_id AND o.ad_client_id=trl.ad_client_id --from pp_order_node_trl trl, pp_order_node o where o.pp_order_node_id=trl.pp_order_node_id AND o.ad_client_id=trl.ad_client_id --from pp_order_workflow_trl trl, pp_order_workflow o where o.pp_order_workflow_id=trl.pp_order_workflow_id AND o.ad_client_id=trl.ad_client_id --from pp_product_bom_trl trl, pp_product_bom o where o.pp_product_bom_id=trl.pp_product_bom_id AND o.ad_client_id=trl.ad_client_id --from pp_product_bomline_trl trl, pp_product_bomline o where o.pp_product_bomline_id=trl.pp_product_bomline_id AND o.ad_client_id=trl.ad_client_id --from r_mailtext_trl trl, r_mailtext o where o.r_mailtext_id=trl.r_mailtext_id AND o.ad_client_id=trl.ad_client_id --from w_mailmsg_trl trl, w_mailmsg o where o.w_mailmsg_id=trl.w_mailmsg_id AND o.ad_client_id=trl.ad_client_id --from w_store_trl trl, w_store o where o.w_store_id=trl.w_store_id AND o.ad_client_id=trl.ad_client_id --from XXX_trl trl, XXX o where o.XXX_id=trl.XXX_id AND o.ad_client_id=trl.ad_client_id AND o.isactive='Y' --AND trl.isactive='Y' AND trl.ad_language = 'de_DE' group by trl.ad_language,trl.ad_client_id,trl.istranslated,trl.isactive
