sql to pull back what is in the activities window

[Ron Gates]

I have some sql for v12 that pulls back what is in the activities window... 

To my surprise that same sql seems to work for v21???  I was thinking something definitely would

need to be updated... Does anybody have some sql to pull back activities in v21?

Any body know what should change in the sql used in v12 to sql used in v21?

thanks

[Mike Halliday]

The upgrade to v21 shouldn't affect your query.  v21 didn't require many db schema updates as the new features were mainly communication or process-based (eg TLS, AAKE, new JCP process etc).

I took a cursory look at the schema documentation and saw no changes to the EH table (which holds executing activity) from v12 to v21 so I don't believe your query needs any update.

[Andrzej Golaszewski]

Hello Ron Gates,

from the information you provided it is difficult to form an opinion. If you could share your sql query so maybe we can recreate your problem and find a solution.

Best regards

Andrzej Golaszewski

[Beige Fed]

Based on the information provided, it seems that the upgrade from version 12 to version 21 shouldn't impact your query significantly. Version 21 mainly introduced communication or process-based features such as TLS, AAKE, and a new JCP process, rather than requiring substantial database schema updates.

Upon reviewing the schema documentation, there appear to be no changes to the EH table (which stores executing activity) from version 12 to version 21. Therefore, it's unlikely that your query requires any updates to accommodate the upgrade. 

OneBloodRewards