【正文】
d on = where = 1 and = 1and = 2and like 39。競爭訂單子表字段select as 競爭訂單子表字段, as 中文標(biāo)簽 from dd_attribute ainner join dd_dict_str d on = where = 1 and = 1and = 2and like 39。競爭產(chǎn)品字段select as 競爭產(chǎn)品字段, as 中文標(biāo)簽 from dd_attribute ainner join dd_dict_str d on = where = 1 and = 1and = 2and like 39。市場活動字段select as 市場活動字段, as 中文標(biāo)簽 from dd_attribute ainner join dd_dict_str d on = where = 1 and = 1and = 2and like 39。線索字段select as 線索字段, as 中文標(biāo)簽 from dd_attribute ainner join dd_dict_str d on = where = 1 and = 1and = 2and like 39。 and lang_id = 2 and dict_name like 39。在子表里,需要使用={BEGIN} 和 ={END} 來括住子表信息,如圖示。={BEGIN}子表字段信息…………={END}引用對象的字段取值舉例說明:系統(tǒng)中創(chuàng)建了自定義對象“車輛管理”對象名是“car”,在訂單中創(chuàng)建了引用字段“車輛”字段名是“cheliang”并引用“車輛管理”對象。contract.%39。lead.%39。campaign.%39。CmptProd.%39。CmptCntrtitem.%39。opportunityitem.%39。quoteitem.%39。contractitem.%39。payment.%39。inventory.%39。invoice.%39。serviceplan.%39。worksheet.%39。product.%39。worksheetitem.%id39。servicerequest.%id39。invoiceitem.%id39。inventoryitem.%id39。paymentitem.%id39。beforetake.%id39。contract.%id39。quote.%id39。opportunity%.%id39。CmptCntrt%