select planplan_id planplan_name plancustomer_type planproduction_line_id planmanager plandescription planfenb_demand planvisit_times plancommucation_times plantraining_times planobjective
The given SQL query selects various fields from the cm_maintenance_plan table and joins it with the customer_info table on the customer_id column. It also includes a custom SQL segment defined by ew.customSqlSegment.
The selected fields are as follows:
plan_idplan_namecustomer_typeproduction_line_idmanagerdescriptionfenb_demandvisit_timescommucation_timestraining_timesobjectivenotifierstatusyearcreate_bycreate_timeupdate_byupdate_timetenant_iddel_flagcustomer_idcustomer_name
The query also includes a LIMIT clause to limit the number of returned rows based on the current and size parameters.
Note: The ${ew.customSqlSegment} is a placeholder for a custom SQL segment that can be dynamically added to the query
原文地址: https://www.cveoy.top/t/topic/imWX 著作权归作者所有。请勿转载和采集!