Notification status Table

[Former Member]

Hi Gurus,

pls let me know from where to fetch the changes status date for Notifications when status of notifications are changes.

i have already tried to use JCDS but its not useful as it is very huge table and very slow response time.

please suggest alternative way..

With Regards

Lohith

[Former Member]

Hi Dear,

Check the Table JEST, with QM00 followed by the Order no.

But the Response is still Slow.

Hope it helps you.

Regards,

Yawar Khan

Edited by: 1234_abcd on Jan 24, 2012 11:13 AM

[Former Member]

It all depends on what you are trying to do with this information from within the notification itself you can get all this information in the action log

menu path - EXTRAS > NOTIFICATION DOCUMENTS > ACTION LOG this will give you the date and time that the status was changed not only for the notification but for tasks as well.

If this is not any help then let me know what your requirement is.

Jim

[Former Member]

Hi James,

thanks for the reply ... i need to fecth the notifications according to the date when their STATUS is changed.

For e.g NOTIFICATION : 1

CREATED DATE : 1/1/2012

STATUS : OSNO.

THIS NOFICATION 1 is RELEASED on 2/1/2012

i want to fetch the data according to this date.

I know it is available in action log but i want to know which database tabl holds this data.

Even i cant use VIQME- AEDAT field (CHANGES ON) as any one who is changing notificvation after status change will be reflected in this field.

JCDS JCDO etc are quite huge table and cant use them.

is there any other way ... ?

[former_member628212]

hi

u need changed on date for notification?