is there a way I can get the SQL for the current reports in the monitoring console. Reports such as general operators report or Verification Operators report by Batches and others.
FlexiCapture creates reports using stored procedures in the Database. If you have administrator access to the FC DB, then you can look for procedures called Report...Report (e.g. ReportOperatorReport) to find the information you need.
Please be very careful when you work with the DB because even slight modifications may affect the whole complex workability. Detailed information about the FC Database is available in FlexiCapture Developer's Help > Database Structure.
Comments
1 comment
FlexiCapture creates reports using stored procedures in the Database.
If you have administrator access to the FC DB, then you can look for procedures called Report...Report (e.g. ReportOperatorReport) to find the information you need.
Please be very careful when you work with the DB because even slight modifications may affect the whole complex workability.
Detailed information about the FC Database is available in FlexiCapture Developer's Help > Database Structure.
Please sign in to leave a comment.