DIS Import Performance

➜ Back to Library
Description
Categories: Enginatics, Toolkit - Setup & Support
Repository: Github Columns: Report Name, Category, Created By, Creation Date, Time ...
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 Name SQL text Validation
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 From 
xrv.creation_date>=:date_from
 DateTime
Report Creation Time To 
xrv.creation_date<=:date_to
 DateTime
Download
 
Related Blitz Reports
Blitz Report Execution Summary Blitz Report Execution History Blitz Report Column Templates Blitz Reports and Example Files (Web View) EIS Reports Compare Blitz Reports between environments Blitz Report Parameter Setup Validation Blitz Reports Blitz Report License Users
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: