1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
<DataSource
dbName="SQLServer_CRM"
dataSourceVersion="1"
generatedBy="v8.3p"
serverType="sql"
>
<operationBindings operationType="fetch">
select
OBJ_DET.crm_obj_idnum AS OBJ_ID
,OBJ_DET.crm_obj_name AS OBJ_NAME
,OBJ_KN.crm_kind_name AS OBK_KIND
from
crm_objects OBJ_DET,
crm_kind OBJ_KN
where OBJ_DET.crm_obj_kind = OBJ_KN.crm_kind_idnum
union all
select
OBJ_ATTR.crm_attr_idnum AS OBJ_ID
,OBJ_ATTRcrm_attr_name AS OBJ_NAME
,OBJ_KN.crm_kind_name AS OBK_KIND
from
crm_attribut OBJ_ATTR,
crm_kind OBJ_KN
where OBJ_KN.crm_kind_idnum = OBJ_ATTR.crm_attr_fk_kind_idnum
</operationBindings>
</DataSource> |
Partager