Trigger filter condition

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

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

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

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

HTH,
RMG

Yes Please.Thanks a lot.