ui-do-10010.10002.sql

国外的一套开源CRM

-- Insert UiDisplayObject
INSERT INTO UI_DISPLAY_OBJECT (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  '10010.10002'
 ,'SEARCH_TEXT'
 ,'Search Text - Issue Item'
 ,'Issue Item Search Text'
);

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

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10010.10002'
 ,'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.10002'
 ,'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.10002'
 ,'SEARCH_TEXT'
 ,'ENTITY'
 ,'ItIssueItem'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10010.10002'
 ,'SEARCH_TEXT'
 ,'ENTITY_DISPLAY_DEF'
 ,'shortName'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10010.10002'
 ,'SEARCH_TEXT'
 ,'ENTITY_ORDER_DEF'
 ,'shortName'
);

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

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

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

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