ui-do-10010.10000.sql

国外的一套开源CRM

-- Insert UiDisplayObject
INSERT INTO UI_DISPLAY_OBJECT (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  '10010.10000'
 ,'SEARCH_TEXT'
 ,'Search Text - Lead'
 ,'Lead Search Text'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10010.10000'
 ,'SEARCH_TEXT'
 ,'ANCHOR_HREF_DEF'
 ,'"/sfa/control/leads?leadId=";#currentField'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10010.10000'
 ,'SEARCH_TEXT'
 ,'ANCHOR_TARGET'
 ,'content'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10010.10000'
 ,'SEARCH_TEXT'
 ,'CLASS'
 ,'selectBox'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10010.10000'
 ,'SEARCH_TEXT'
 ,'ENTITY'
 ,'Lead'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10010.10000'
 ,'SEARCH_TEXT'
 ,'ENTITY_DISPLAY_DEF'
 ,'firstName;" ";lastName'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10010.10000'
 ,'SEARCH_TEXT'
 ,'ENTITY_ORDER_DEF'
 ,'lastName;firstName'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10010.10000'
 ,'SEARCH_TEXT'
 ,'ENTITY_PK_FIND_DEF'
 ,'leadId:#currentField'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10010.10000'
 ,'SEARCH_TEXT'
 ,'ENTITY_SEARCH_DEF'
 ,'lastName'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10010.10000'
 ,'SEARCH_TEXT'
 ,'ENTITY_VALUE_DEF'
 ,'leadId'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10010.10000'
 ,'SEARCH_TEXT'
 ,'SIZE'
 ,''
);