DIS Import Performance

Description
Categories: Application, Enginatics
Simple query to review Discoverer worksheet to Blitz Report import performance, when running the mass migration script.
https://www.enginatics.com/user-guide/#Discoverer_Worksheet
select
xrv.report_name,
xrv.category,
xxen_util.user_name(xrv.created_by) created_by,
xrv.creation_date,
xxen_util.time((xrv.creation_date-lag(xrv.creation_date) over (order by xrv.report_id))*86400) time
from
xxen_reports_v xrv
where
1=1
order by
xrv.report_id desc
Parameter NameSQL textValidation
Category
xrv.report_id in (
select
xrca.report_id
from  
xxen_report_categories_v xrcv,
xxen_report_category_assigns xrca
where
xrcv.category=:category_name and
xrcv.category_id=xrca.category_id
)
LOV
Report Creation Time To
xrv.creation_date<=:date_to
DateTime
Report Creation Time From
xrv.creation_date>=:date_from
DateTime