Skip to main content
Xdoxslt XML Publisher RTF Important Syntax’s

    1.       To convert CASE of a tag to UPPER case
     xdoxslt:convert_case(.//MATERIALTYPE,'UPPER')
    2.       To convert CASE of a tag to LOWER case
     xdoxslt:convert_case(.//MATERIALTYPE,'UPPER')
    3.       Syntax for CONTAIN
     contains(xdoxslt:convert_case(.//MATERIALTYPE,'UPPER'),’IC CREDIT MEMO’)
    4.       Syntax for NOT CONTAIN
     not(contains(xdoxslt:convert_case(.//REFERENCE_ID,'UPPER'),'WSC'))
    5.       CHOOSE-WHEN-OTHERWISE Syntax
    <?choose:?><?when: contains(xdoxslt:convert_case(.//MATERIALTYPE,'UPPER'),’IC CREDIT       MEMO’)?><?’Interco Credit Memo’?><?end when?><?otherwise:?><?.//INVOICETYPE?><?         end otherwise?><?end choose?>
    6.       IF - ELSE Syntax
    <?xdoxslt:ifelse(xdoxslt:convert_case(.//MATERIALTYPE,'UPPER')!='CONSIGNMENT                ORDER',.//BILLOFLADING,'NULL')?>
    7.       START-END BODY
     ----HEADER------
       <?start:body?>
     ----BODY---------
     <?end body?>
     ----FOOTER—
     8.       FOR-EACH Grouping
      <?for-each:XWII_810_OUT_LINE_OBJ?>
      <?end for-each?>
     9.       TEMPLATES
       <?template:XWII_LOGO?>
       ------Conditions-----
        <?end template?>
      Syntax to call Template
      <?call:XWII_LOGO?>
10.   Substring Before
        substring-before(.//ALLOY,’/’)
      11.   Substring After
        substring-after(.//ALLOY,’/’)
      12.   Set Variable
       <?xdoxslt:set_variable($_XDOCTX,'PRO',/ProcessInvoice/XWII_810_OUT_INVOICE_OBJ/XWII_810_OUT_HEADER/PRODUCT)?>
      Get Variable
       xdoxslt:get_variable($_XDOCTX,'PRO')
      13.   Concatenation
       concat(.//ALLOY,.//HAR,’TEST’)
      14.   Numeric
       xdoxslt:is_numeric(.//BILLTOIDENTIFIER)
      15.   Not Numeric
       not(xdoxslt:is_numeric(.//BILLTOIDENTIFIER))
      16.   Formatting Number
       format-number(LOTEXTENSION,'##,###,##0.00')
      17.   Tag Exists
       IF .//BILLTOIDENTIFIER THEN
      18.   Tag Not Exists
       IF not(.//BILLTOIDENTIFIER) THEN

Comments

Popular posts from this blog

Oracle Forms -- Important Syntaxes

1. To get the enabled property of the item APP_ITEM_PROPERTY.GET_PROPERTY('CONTROL.FILTER_HOLD_RECORDS',ENABLED) 2. Disable Attachment for this Block in WHEN-NEW-BLOCK-INSTANCE  APP_SPECIAL.ENABLE('ATTACHMENTS', PROPERTY_OFF); 3. Default Where / Default Order By Set_block_property('XWII_MATL_DISP_HOLDS_V', Default_where, Lc_query); Set_block_property('XWII_MATL_DISP_HOLDS_V', order_by, Lc_query); 4. Visual Attribute    a. Define Visual Attribute for eg 'XWII' where you can set Colour  b. SET_ITEM_INSTANCE_PROPERTY('block.item_name',CURRENT_RECORD,VISUAL_ATTRIBUTE ,'XWII'); 4. Visual Attribute for Record APP_RECORD.HIGHLIGHT('XWII'); Where 'XWII' is the visual attribute where you can set Colour. 5. Initiliaze SPECIAL Menu app_special.instantiate ('SPECIAL1', GET_GROUP_CHAR_CELL ('SPECIAL_MENU.SPECIAL_MENU_ITEM', 1), '', TRUE, ''); 6. execute_trigger('SPECIAL25...

Oracle Forms - Window Resize ( Changing window size upon minimizing and maximising)

-- Added by Qutub M for View SU Redesign Proj. (Notes) DECLARE ln_width_diff NUMBER; ln_item_width NUMBER; ln_canvas_width NUMBER; ln_view_width NUMBER; BEGIN IF :system.EVENT_WINDOW = 'FULL_NOTE_DISPLAY' THEN ln_width_diff := TO_NUMBER(GET_WINDOW_PROPERTY('FULL_NOTE_DISPLAY',width)) - :PARAMETER.FULL_NOTES_WIDTH; ln_item_width := TO_NUMBER(GET_ITEM_PROPERTY('FULL_NOTE_DISPLAY.FULL_NOTE',width)); ln_canvas_width := TO_NUMBER(GET_CANVAS_PROPERTY('FULL_NOTE_DISPLAY',width)); ln_view_width := TO_NUMBER(GET_VIEW_PROPERTY('FULL_NOTE_DISPLAY',width)); -- SET_VIEW_PROPERTY('FULL_NOTE_DISPLAY', X_POS, 0); SET_VIEW_PROPERTY('FULL_NOTE_DISPLAY', WIDTH, :parameter.view_width+ln_width_diff); SET_CANVAS_PROPERTY('FULL_NOTE_DISPLAY', WIDTH, :parameter.canvas_width+ln_width_diff);     SET_ITEM_PROPERTY('FULL_NOTE_DISPLAY.FULL_NOTE', width, :parameter.item_width+ln_width_diff);     --M...