Users - Entity ECA - trigger not working

[saching]

Hi,

 

I am trying to invoke a service when PRODUCT table gets updated with salesDiscontinuationDate & a new field that I have added to the table i.e. status.

 

I have made the following entry in the eecas.xml, but the same does not get triggered.

 

    <eca entity="Product" operation="create-store" event="return">

        <condition field-name="productId" operator="is-not-empty"/>

        <condition field-name="salesDiscontinuationDate" operator="is-not-empty"/>

        <condition field-name="status" operator="DELETED"/>

        <action service="setProductStatusAsDeleted" mode="sync"/>

    </eca>

 

What I intend to achieve is when content XML import is done from webtool, if the product is set as deleted, I would like to update certain tables witin OFBiz.

 

Please could you please let me know why the trigger may not be working out? I have tried with or without the new field (status). I get the same result.

 

I am not very clear on when would the trigger be fired? Whether it would happen just after the PRODUCT table has been updated with imported values or at some other time.

 

Thanks and regards,

Sachin G

*********************************************************
Disclaimer:

The contents of this E-mail (including the contents of the enclosure(s) or attachment(s) if any) are privileged and confidential material of MBT and should not be disclosed to, used by or copied in any manner by anyone other than the intended addressee(s). In case you are not the desired addressee, you should delete this message and/or re-direct it to the sender. The views expressed in this E-mail message (including the enclosure(s) or attachment(s) if any) are those of the individual sender, except where the sender expressly, and with authority, states them to be the views of MBT.

This e-mail message including attachment/(s), if any, is believed to be free of any virus. However, it is the responsibility of the recipient to ensure that it is virus free and MBT is not responsible for any loss or damage arising in any way from its use

*********************************************************

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Jacopo Cappellato]

Hi,

the error is in this condition:

<condition field-name="status" operator="DELETED"/>

That should be:

<condition field-name="status" operator="equals" value="DELETED"/>


Hope this helps,

Jacopo

saching wrote:

> Hi,
>
>  
>
> I am trying to invoke a service when PRODUCT table gets updated with
> salesDiscontinuationDate & a new field that I have added to the table
> i.e. status.
>
>  
>
> I have made the following entry in the eecas.xml, but the same does not
> get triggered.
>
>  
>
>     <eca entity="Product" operation="create-store" event="return">
>
>         <condition field-name="productId" operator="is-not-empty"/>
>
>         <condition field-name="salesDiscontinuationDate"
> operator="is-not-empty"/>
>
>         <condition field-name="status" operator="DELETED"/>
>
>         <action service="setProductStatusAsDeleted" mode="sync"/>
>
>     </eca>
>
>  
>
> What I intend to achieve is when content XML import is done from
> webtool, if the product is set as deleted, I would like to update
> certain tables witin OFBiz.
>
>  
>
> Please could you please let me know why the trigger may not be working
> out? I have tried with or without the new field (status). I get the same
> result.
>
>  
>
> I am not very clear on when would the trigger be fired? Whether it would
> happen just after the PRODUCT table has been updated with imported
> values or at some other time.
>
>  
>
> Thanks and regards,
>
> *Sachin G*
>
> *********************************************************
> Disclaimer:
>
> The contents of this E-mail (including the contents of the enclosure(s)
> or attachment(s) if any) are privileged and confidential material of MBT
> and should not be disclosed to, used by or copied in any manner by
> anyone other than the intended addressee(s). In case you are not the
> desired addressee, you should delete this message and/or re-direct it to
> the sender. The views expressed in this E-mail message (including the
> enclosure(s) or attachment(s) if any) are those of the individual
> sender, except where the sender expressly, and with authority, states
> them to be the views of MBT.
>
> This e-mail message including attachment/(s), if any, is believed to be
> free of any virus. However, it is the responsibility of the recipient to
> ensure that it is virus free and MBT is not responsible for any loss or
> damage arising in any way from its use
>
> *********************************************************
>
>
> ------------------------------------------------------------------------
>
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users