META FUNCTIONITEMS

From SemanticLab

Jump to: navigation, search

SET DEFINE OFF; 

 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('386190', 0, 0, NULL, 'null', 
     '281702');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('388759', 0, 0, NULL, %{ROWNUM}, 
     '281699');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259783', 0, 0, NULL, '"volume"', 
     '259782');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259784', 10, 0, '||', 'CASE WHEN  "number" is NULL   THEN', 
     '259782');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259785', 20, 4, NULL, 'NULL', 
     '259782');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259786', 30, 0, NULL, 'ELSE', 
     '259782');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259787', 40, 4, NULL, (, 
     '259782');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259788', 50, 4, '||', '"number"', 
     '259782');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259789', 60, 4, '||', ), 
     '259782');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259790', 70, 0, NULL, 'END', 
     '259782');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259791', 80, 0, '||', 'CASE WHEN  "pages" is not NULL   THEN', 
     '259782');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259792', 90, 4, NULL, 'CASE WHEN  "volume" is NULL and "number" is NULL THEN', 
     '259782');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259793', 100, 8, NULL, 'format_pages', 
     '259782');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259794', 110, 4, NULL, 'ELSE', 
     '259782');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259795', 120, 8, NULL, :, 
     '259782');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259796', 130, 8, '||', 'REPLACE(REPLACE(REPLACE(REPLACE(REPLACE("pages",--,"xxx"),"xxx"-,"xxx""yy"),-,--),"xxx",--),"yy",-)', 
     '259782');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259797', 140, 4, NULL, 'END', 
     '259782');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259798', 150, 0, NULL, 'END', 
     '259782');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259800', 0, 0, NULL, 'CASE WHEN  "type" is NULL   THEN', 
     '259799');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259801', 10, 4, NULL, Technical Report, 
     '259799');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259802', 20, 4, '||', 'CASE WHEN  "number" is not NULL THEN', 
     '259799');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259803', 30, 8, NULL, 'CASE WHEN LENGTH("number")<3 THEN ~ ELSE   END || "number"', 
     '259799');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259804', 40, 4, NULL, 'END', 
     '259799');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259805', 50, 0, NULL, 'ELSE', 
     '259799');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259806', 60, 4, NULL, 'CASE WHEN  "number" is NULL   THEN', 
     '259799');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259807', 70, 8, NULL, 'INITCAP("type")', 
     '259799');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259808', 80, 4, NULL, 'ELSE', 
     '259799');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259809', 90, 8, NULL, '"type"', 
     '259799');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259810', 100, 8, '||', 'CASE WHEN LENGTH("number")<3 THEN ~ ELSE   END || "number"', 
     '259799');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259811', 110, 4, NULL, 'END', 
     '259799');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259812', 120, 0, NULL, 'END', 
     '259799');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259814', 0, 0, NULL, 'CASE WHEN ITEMTYPE =book OR ITEMTYPE = inbook THEN', 
     '259813');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259815', 10, 4, NULL, 'author_editor_key_label', 
     '259813');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259816', 20, 0, NULL, 'ELSE', 
     '259813');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259817', 30, 4, NULL, 'CASE WHEN   ITEMTYPE = proceedings   THEN', 
     '259813');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259818', 40, 8, NULL, 'editor_key_organization_label', 
     '259813');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259819', 50, 4, NULL, 'ELSE', 
     '259813');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259820', 60, 8, NULL, 'CASE WHEN   ITEMTYPE = manual   THEN', 
     '259813');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259821', 70, 12, NULL, 'author_key_organization_label', 
     '259813');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259822', 80, 8, NULL, 'ELSE', 
     '259813');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259823', 90, 12, NULL, 'author_key_label', 
     '259813');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259824', 100, 8, NULL, 'END', 
     '259813');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259825', 110, 4, NULL, 'END', 
     '259813');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259826', 120, 0, NULL, 'END', 
     '259813');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259827', 130, 0, '||', 'SUBSTR("year_pu",-1, 2)', 
     '259813');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259829', 0, 0, NULL, 'CASE WHEN ITEMTYPE =book OR ITEMTYPE = inbook THEN', 
     '259828');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259830', 10, 4, NULL, 'author_editor_sort', 
     '259828');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259831', 20, 0, NULL, 'ELSE', 
     '259828');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259832', 30, 4, NULL, 'CASE WHEN   ITEMTYPE = proceedings   THEN', 
     '259828');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259833', 40, 8, NULL, 'editor_organization_sort', 
     '259828');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259834', 50, 4, NULL, 'ELSE', 
     '259828');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259835', 60, 8, NULL, 'CASE WHEN   ITEMTYPE = manual  THEN', 
     '259828');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259836', 70, 12, NULL, 'author_organization_sort', 
     '259828');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259837', 80, 8, NULL, 'ELSE', 
     '259828');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259838', 90, 12, NULL, 'author_sort', 
     '259828');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259839', 100, 8, NULL, 'END', 
     '259828');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259840', 110, 4, NULL, 'END', 
     '259828');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259841', 120, 0, NULL, 'END', 
     '259828');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259842', 130, 0, '||',     , 
     '259828');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259843', 140, 0, '||', '"year_pu"', 
     '259828');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259844', 150, 0, '||',     , 
     '259828');
 Insert into META_FUNCTIONITEMS
    (ID, ITEM_POSITION, INDENT, LINE_ACTION, SQL_TEXT, 
     M_TYPEF_ID)
  Values
    ('259845', 160, 0, '||', 'REPLACE(REPLACE(REPLACE("title",A ),An ),The )', 
     '259828');
 COMMIT;
Retrieved from "http://www.semanticlab.net/index.php/META_FUNCTIONITEMS"
Personal tools