cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Help us improve the PTC Community by taking this short Community Survey! X

How old data is being retained by services QueryAlertSummary and QueryAlertHistory from current date

ranjank
15-Moonstone

How old data is being retained by services QueryAlertSummary and QueryAlertHistory from current date

Explain the difference between these two services.

 

Thanks in advance

ACCEPTED SOLUTION

Accepted Solutions
slangley
23-Emerald II
(To:ranjank)

Hi @ranjank.

 

When running the services in Composer, the number of records returned is limited to 500.  If you need to pull more, then you need to design a mashup to display the data.  This will allow you to pull ALL data if needed regardless of timeframe.

 

Regards.

 

--Sharon

View solution in original post

8 REPLIES 8

In short, the difference between the two is that QueryAlertHistory uses AlertHistoryStream, while QueryAlertSummary doesn't.

 

/ Constantine

ranjank
15-Moonstone
(To:Constantine)

Could you pls let me know how much data is being retrieved by QueryAlertSummary and QueryAlertHistory with respect to current time?

That's defined by service parameters -- both maximum number of items, as well as start/end timestamps.

 

/ Constantine

ranjank
15-Moonstone
(To:Constantine)

Actually, I want to know without providing any input and just run both these services, then how many days or hours old data from the current time will be retrieved? (not the no of records)

By default it will return you 500 most recent rows, as simple as that. If you don't specity start/end dates explicitly, then it won't apply any filtering on timestamps.

 

/ Constantine

ranjank
15-Moonstone
(To:Constantine)

My concern is not about no of rows or count. My question is QueryAlertSummary and QueryAlertHistory services retrieve data of the last 7 days or last 24 hours or else from current time (irrespective of the no of records).

slangley
23-Emerald II
(To:ranjank)

Hi @ranjank.

 

When running the services in Composer, the number of records returned is limited to 500.  If you need to pull more, then you need to design a mashup to display the data.  This will allow you to pull ALL data if needed regardless of timeframe.

 

Regards.

 

--Sharon

slangley
23-Emerald II
(To:slangley)

Hi @ranjank.

 

If one of the previous responses answered your question, please mark the appropriate one as the Accepted Solution for the benefit of others with the same question.

 

Regards.

 

--Sharon

Announcements


Top Tags