IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  Trigger filter condition

    Posted Tue June 23, 2009 11:52 AM

    Hi,

    I need to create a trigger with the following filter conditions as per the requirement.

    SupplierType = CSS
    PartyType!= Consumer
    PartyTransactableFlag = Y
    PartyStatus not like (‘%Marked For Deletion%’) and trim(PartyStatus)<>‘Inactive’ and trim(PartyStatus) not like (‘%Marked For Merge%’)

    And I am putting the filter condition as

    ((%PartyAccount/Data/Header/PartyStatus%! ‘/Marked For Deletion/’)
    and
    (trim(%PartyAccount/Data/Header/PartyStatus%) <> ‘Inactive’)
    and
    (trim(%PartyAccount/Data/Header/PartyStatus%)!‘/Marked For Merge/’ )and
    (%PartyAccount/Data/Header/PartyTypes/PartyType% L_NOT_EQUALS ‘Consumer’)
    and (%PartyAccount/Data/Header/PartyTransactableFlag% L_EQUALS ‘Y’)
    and
    (%PartyAccount/Data/BusinessLocation/SupplierType %) L_EQUALS ‘CSS’))

    But while enabling the trigger I am getting
    [ISS.0085.9185] Invalid filter
    [ISC.0049.9103] Too many parts to the expression.

    Please let me know how to include all the conditions in the filter.

    Regards,
    Titu


    #Integration-Server-and-ESB
    #webMethods
    #webMethods-General


  • 2.  RE: Trigger filter condition

    Posted Tue June 23, 2009 08:45 PM

    One thing i would say is replace logical ‘and’ with ‘&&’ in the filter condition above.

    And also not sure whether <> operator works…Are you trying for != (not equal to) there?

    HTH,
    RMG


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: Trigger filter condition

    Posted Thu June 25, 2009 05:22 PM

    RMG,

    I have replaced the logical ‘and’ with ‘&&’.But still this is not working.
    Yes,I am using !=(not equal to) here.
    I’ve gone through the documentations also.But did not find much help.
    Please suggest something.

    Thanks,
    Titu


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods


  • 4.  RE: Trigger filter condition

    Posted Thu June 25, 2009 05:40 PM

    It looks like you have too many expressions that not handled properly…If i also find any clue will let u know.

    HTH,
    RMG


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB


  • 5.  RE: Trigger filter condition

    Posted Thu June 25, 2009 05:43 PM