ui-dt-search_text.sql

国外的一套开源CRM

-- Insert UiDisplayType
INSERT INTO UI_DISPLAY_TYPE (
  DISPLAY_TYPE_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SEARCH_TEXT'
 ,'Search Text Field'
 ,'A special Text field that searches for a value when the field detects an onblur event.  When multiple values are found a select list is returned, otherwise the id value is returned. '
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SEARCH_TEXT'
 ,'ALIGN'
 ,'Text Alignment'
 ,'Text alignment<BR><BR>Translates to ALIGN attribute of HTML < INPUT > tag.<BR>Value can be TOP, MIDDLE, or BOTTOM.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SEARCH_TEXT'
 ,'ANCHOR_HREF_DEF'
 ,'Anchor (Link) Reference Definition'
 ,'Anchor (Link) Reference Definition<BR><BR>If this parameter is set, the field will be displayed as an HTML < A > tag when in read only-mode.<BR><BR>Contents must be a semicolon-delimited list of attribute names from the listed entity.<BR>Literal strings may also be embedded with quotes around them.<BR>Values from the specified attributes will be concatentated along with any embedded quoted literals, and used as the HREF value for the < A > tag.<BR>"#currentField" can be used in place of an attribute name to use the current field value.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SEARCH_TEXT'
 ,'ANCHOR_TARGET'
 ,'Anchor (Link) Target'
 ,'Anchor (Link) Target<BR><BR>If this parameter and the ANCHOR_HREF_DEF parameter are set, the field will be displayed as an HTML < A > tag when in read-only mode, and the value of this parameter will be used as the value for the TARGET attribute of the < A > tag.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SEARCH_TEXT'
 ,'CLASS'
 ,'Class'
 ,'Style class<BR><BR>Defines what style from the style sheet to assign to the CLASS attribute of the < INPUT > tag.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SEARCH_TEXT'
 ,'DISABLED'
 ,'Disabled'
 ,'Disabled<BR><BR>Translates to DISABLED attribute of HTML < INPUT > tag.<BR>Value should be Y or N.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SEARCH_TEXT'
 ,'ENTITY'
 ,'Entity'
 ,'Entity<BR><BR>Defines the data entity to use to search.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SEARCH_TEXT'
 ,'ENTITY_DISPLAY_DEF'
 ,'Entity Display Definition'
 ,'Entity display definition<BR><BR>Defines which attribute(s) of the entity to display in the drop down list.<BR>Must be a semicolon-delimited list of attribute names from the listed entity.<BR>Quoted literal strings may also be embedded.<BR>Values from the specified attributes will be concatentated along with any embedded quoted literals and used in the VALUE attribute of the < INPUT > tag.<BR>"#currentField" can be used in place of an attribute name to use the current field value.<BR><BR>Example:<BR>contactId;" - (";contactName;")"'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SEARCH_TEXT'
 ,'ENTITY_ORDER_DEF'
 ,'Entity Order Definition'
 ,'Entity order definition<BR><BR>Defines which attribute(s) of the listed entity to sort by.<BR>Must be a semicolon-delimited list of attribute names from the listed entity.<BR><BR>Example:<BR>contactLastName;contactFirstName'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SEARCH_TEXT'
 ,'ENTITY_PK_FIND_DEF'
 ,'Entity Primary Key Find Definition'
 ,'Entity primary key find definition<BR><BR>Required.<BR>Defines the primary key of the entity represented in the select list, and defines how to find the instance of the entity that is currently selected on the screen.<BR>This is used to display the selected item when not in edit mode (drop down list is not displayed in this case, just the display value according to the ENTITY_DISPLAY_DEF attribute.<BR>Should contain a list of attribute name pairs.<BR>The pairs should be separted by semicolons (;) between pairs.<BR>The two values in each pair should be separated by a colon (:).<BR>In each attribute pair, the first string of each pair should be the name of an attribute in the primary key of the listed entity.  The second string should either be an attribute name from the primary entity in the screen section the select list appears on, or a quoted literal string that will be used as a fixed value.<BR><BR>Examples:<BR>sectionId:sectionId;partyId:"-1";attributeId:attributeId<BR>codeTypeId:"INDUSTRY";codeId:industry'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SEARCH_TEXT'
 ,'ENTITY_SEARCH_DEF'
 ,'Entity Search Definition'
 ,'Entity search definition<BR><BR>Defines which attribute of the entity to search on.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SEARCH_TEXT'
 ,'ENTITY_VALUE_DEF'
 ,'Entity Value Definition'
 ,'Entity value definition<BR><BR>Defines which attribute(s) of the entity to use as values for the drop down select object, or to return as a single value.<BR>Must be a semicolon-delimited list of attribute names from the listed entity.<BR>Values from the specified attributes will be concatentated and used in the VALUE attribute of the < OPTION > tags.<BR><BR>Example:<BR>codeTypeId;codeId'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SEARCH_TEXT'
 ,'MAXLENGTH'
 ,'Maximum Length'
 ,'Maximum data length<BR><BR>Translates to MAXLENGTH attribute of HTML < INPUT > tag'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SEARCH_TEXT'
 ,'READONLY'
 ,'Read Only'
 ,'Read only<BR><BR>Translates to READONLY attribute of HTML < INPUT > tag.<BR>Value should be Y or N.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SEARCH_TEXT'
 ,'SIZE'
 ,'Field Size'
 ,'Field size<BR><BR>Translates to SIZE attribute of HTML < INPUT > tag'
);