Open zambrovski opened 5 months ago
We documented the statement to create the view in the documentation of the JPA View.
create view PLF_VIEW_TASK_AND_DATA_ENTRY_PAYLOAD as
((select pc.TASK_ID, dea.PATH, dea.VALUE
from PLF_TASK_CORRELATIONS pc
join PLF_DATA_ENTRY_PAYLOAD_ATTRIBUTES dea on pc.ENTRY_ID = dea.ENTRY_ID and pc.ENTRY_TYPE = dea.ENTRY_TYPE)
union
select * from PLF_TASK_PAYLOAD_ATTRIBUTES);
The View JPA provides a new view for payload resolution of tasks and correlated data entries.
Please provide scripts for the view creation.