Trigger filter condition

, ,
1

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

2

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

3

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

4

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

HTH,
RMG

5

Yes Please.Thanks a lot.