use current user in the user Defined alerts

[Former Member]

Hi

i created a UDQ with a filter on the Current user (where ???=$[USER]

and it's working fine.

but when i use it in the User Defined Alert, nothing happen. the UD Alert doesn't fire.

is there any solution?

10x

[Former Member]

Hi,

Could you post you entire query?

Thanks,

Gordon

[Former Member]

H Gordan

for example:

select t0.docentry,t0.docnum,t0.cardcode,t0.cardname from ordr t0 where t0.docstatus='O' and t0.usersign=$[[USER]]

if you save it as UDQ and run it, it will return all open sales orders for current user.

try to link it to an alert, it won't show you any thing

regards;

Edited by: Dany Bittar on May 12, 2011 1:08 PM

[Former Member]

Because alert function is not directly link to any user session, your goal may not be achievable.