How can i access event handler monitor table in web service?

I am beginner. I want to create web service which display the events in event handler monitor table on my webpage. how can i do it? can i create it using java spring boot?

Agile User Asked on April 28, 2021 in Agile PLM (v9).
Add Comment
1 Answer(s)

Hello Darsh

AGILE.event_history table stores all the data that you see in the Event monitor. You should be able to select the table using spring boot without any issues

One question though. Since all this data is in Administrator including a decent search, I am just wondering why you are building an app

– Raj

Agile Angel Answered on April 29, 2021.

Hi Raj

Thank you for your quick response.. I have connected to agile plm java client using IAgileSession. I am not finding related that event_history table. How and where can i get access to AGILE.event_history table?  do you have any sample code for it? can you help me with it?

Thanks

Darsh

on April 30, 2021.

Hi Darsh

Sorry if i wasn’t clear. You need to connect to the Oracle schema AGILE. That’s where all these tables are. There you will find EVENT_HISTORY. Please check with your DBA for details. You then setup as a datasource in springboot and then query the table

– Raj

on April 30, 2021.

Hi Raj,

Thank you for your response. I’ll look into it.

is there a way to subscribe to these events?
Thanks
Darsh
on May 3, 2021.

Not sure what you mean by subscribe to these events. Can you please elaborate?

on May 3, 2021.

Hi Raj,

In Agile java client, Events are binds to event handlers using event subscriber. can we get those event info using event subscriber?

 

Thanks

Darsh

on May 4, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.