Title UDF Alert when changes

[Former Member]

Hello Experts,

I was wondering if user could be alerted when a UDF in a marketing document is update? for example: I have a UDF named "internal notes" where users enter notes and a few people need to be alerted when this field is updated.

I would like to thank you in advance.

Jose

[Former Member]

Try:

select t0.DocNum, t0.u_notes from ORDR T0

where $[ordr.u_notes\] NOT IN (SELECT T1.u_notes FROM ADOC T1 WHERE T1.DocNum = T0.DocNum AND T1.ObjType = '17')

[Former Member]

Hi Jose,

This will only work if the note message is added from nothing.

The solution would be a user alert query:

select t0.DocNum, t0.u_notes from ORDR T0

where $[ordr.u_notes\] IS NOT NULL

Thanks,

Gordon

[Former Member]

Hi Gordon,

This will work if the notes are entered once, the problem is when users update the notes constantly. Do you know of another solution?

Thank You,

Jose

[Former Member]

HI

Check this FOR PURCHASE ORDERS

select T0.[ItemCode],T1.[u_notes] from OPOR T0 inner join POR1 T1 on T0.[DocEntry] = T1.[DocEntry] where T1.[u_notes] NOT IN (select [u_notes] from ADOC T2 where T2.[DocEntry] = T1.[DocEntry] AND T0.[ObjType] = '22' )

Edited by: kambadasan on Jun 10, 2011 10:43 AM

[Former Member]

HI

You can do that by using query based alert:

sample query for purchase order:

select t0.[DocNum] as 'Document number' from OPOR T0 Inner join POR1 on T0.[DocEntry] = T1.[DocEntry] where t1.[u_notes] IS NOT NULL

Assign this for the alert and keep the frequency as '1 min'

hope it will work...

Please check...

[Former Member]

Hi kambadasan,

This will work if the notes are entered once, the problem is when users update the notes constantly. Do you know of another solution?

Thank You,

Jose