1 Reply Latest reply: Feb 1, 2018 4:07 AM by Fathi Ali RSS

    IF(Wildmatch(UPPER(SOW_APPROVAL_STATUS),'REJECT*'),'SOW Rejected',

    xxxxx yyyyy

      May I know the meaning for this script::

      IF(Wildmatch(UPPER(SOW_APPROVAL_STATUS),'REJECT*'),'SOW Rejected',

          IF((NOT IsNull(PO_NUMBER) OR LEN(TRIM(PO_NUMBER)))<>0,'Project Completed',

          IF(Not Wildmatch(UPPER(SOW_APPROVAL_STATUS),'APPROVED'), 'SOW Acceptance Pending',

          IF(Wildmatch(UPPER(SOW_APPROVAL_STATUS),'APPROVED')

          AND (ISNULL(RFQ_NO) OR LEN(TRIM(RFQ_NO))=0)

          ,'Sourcing Initiation Pending',

        • Re: IF(Wildmatch(UPPER(SOW_APPROVAL_STATUS),'REJECT*'),'SOW Rejected',
          Fathi Ali

          Hello,


          IF(Wildmatch(UPPER(SOW_APPROVAL_STATUS),'REJECT*'),'SOW Rejected',

           

          this line mean that if the field [SOW_APPROVAL_STATUS] on upper format have on it begining the word REJECT remplace it with the new value = 'SOW Rejected' 


          -----------------------------------------------------------------------------------------------------------------------------------------------------
          IF((NOT IsNull(PO_NUMBER) OR LEN(TRIM(PO_NUMBER)))<>0,'Project Completed',


          this one mean that if the field [PO_NUMBER] is not null , have a value and not empty by testing the length of it and if it's <> to 0 , we gonna replace the value of the field [PO_NUMBER] by 'Project Completed'


          -----------------------------------------------------------------------------------------------------------------------------------------------------

          IF(Not Wildmatch(UPPER(SOW_APPROVAL_STATUS),'APPROVED'), 'SOW Acceptance Pending',


          here we test if the value of the field [SOW_APPROVAL_STATUS] in upper format is not matching APPROVED we replace it by 'SOW Acceptance Pending'



          -----------------------------------------------------------------------------------------------------------------------------------------------------

          IF(Wildmatch(UPPER(SOW_APPROVAL_STATUS),'APPROVED')
          AND (ISNULL(RFQ_NO) OR LEN(TRIM(RFQ_NO))=0)    ,'Sourcing Initiation Pending',

           

           

          the last lines means that if the field [SOW_APPROVAL_STATUS] in upper format is matching APPROVED and the other condition it's if the field [RFQ_NO] is null , have no value and empty by testing the length of it, if the conditions are confirmed we replace the value of the field [SOW_APPROVAL_STATUS] by Sourcing Initiation Pending