v 1.0.0 Eclipse BIRT Designer Version 4.6.0.v201606072122 Version string 1.0.0 queryText 497 queryTimeOut 497 rowFetchSize 497 in /templates/blank_report.gif ltr 120 static true string true % simple false text-box Unformatted static true string true 1559340000 simple false text-box Unformatted static true string true 1561845600 simple false text-box Unformatted static string true % simple text-box Unformatted static string true % simple text-box Unformatted static boolean true false simple check-box static false string true dd MMM y HH:mm:ss simple text-box Unformatted static string true % simple text-box Unformatted metadataBidiFormatStr ILYNN disabledMetadataBidiFormatStr contentBidiFormatStr ILYNN disabledContentBidiFormatStr com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/sog gis Z2lz nulls lowest transaction_id dimension transaction_id transaction_id startDate dimension startDate startDate endDate dimension endDate endDate sched_action_date dimension sched_action_date sched_action_date sched_action dimension sched_action sched_action sched_fullname dimension sched_fullname sched_fullname transaction_operation dimension transaction_operation transaction_operation srm_schedule_confirmation_status dimension srm_schedule_confirmation_status srm_schedule_confirmation_status is_suspended measure is_suspended is_suspended lock_fullname dimension lock_fullname lock_fullname access_point_id dimension access_point_id access_point_id access_point_description dimension access_point_description access_point_description access_point_com_status dimension access_point_com_status param_1 start_date string -1 1 true false param_2 start_date string -1 2 true false param_3 start_date string -1 3 true false param_4 end_date string -1 4 true false param_5 start_date string -1 5 true false param_6 start_date string -1 6 true false param_7 start_date string -1 7 true false param_8 end_date string -1 8 true false 1 transaction_id string 2 startDate date-time 3 endDate date-time 4 sched_action_date date-time 5 sched_action string 6 sched_fullname string 7 transaction_operation string 8 srm_schedule_confirmation_status string 9 is_suspended integer 10 lock_fullname string 11 access_point_id string 12 access_point_description string 13 access_point_com_status string Glam 1 transaction_id transaction_id string 12 2 startDate startDate date-time 93 3 endDate endDate date-time 93 4 sched_action_date last_changed_on date-time 93 5 sched_action his_action string 12 6 sched_fullname sched_fullname string 12 7 transaction_operation transaction_operation string 12 8 srm_schedule_confirmation_status srm_schedule_confirmation_status string 12 9 is_suspended is_suspended integer -7 10 lock_fullname lock_fullname string 12 11 access_point_id access_point_id string 12 12 access_point_description access_point_description string 12 12 access_point_com_status access_point_com_status string 12 ?)) OR (trans.transaction_date_start BETWEEN ? AND ?)) $WHERE UNION SELECT trans.transaction_id, from_unixtime(trans.transaction_date_start) as startDate,from_unixtime(trans.transaction_date_end) as endDate, sche.last_changed_on as sched_action_date, 'ADDED', CONCAT(schedule_user.usr_firstname ,' ',schedule_user.usr_lastname) as sched_fullname, sche.transaction_operation,sche.srm_schedule_confirmation_status, sche.is_suspended , CONCAT(lock_user.usr_firstname ,' ',lock_user.usr_lastname) as lock_fullname, gap.access_point_id as access_point_id, gap.access_point_description as access_point_description, gap.access_point_com_status as access_point_com_status FROM sog.glam_transaction as trans INNER JOIN glam_transaction_schedule as sche on trans.transaction_id = sche.transaction_id LEFT JOIN glam_access_point gap on sche.access_point_id = gap.access_point_id LEFT JOIN krf_user as schedule_user on sche.last_changed_by = schedule_user.usr_id LEFT JOIN krf_user as lock_user on sche.user_id = lock_user.usr_id WHERE (((trans.transaction_date_start < ?) AND (trans.transaction_date_end > ?)) OR (trans.transaction_date_start BETWEEN ? AND ?)) AND NOT ISNULL(transaction_id_owner) $WHERE ORDER BY access_point_description ASC]]> landscape html new Date()]]> LockAndHistory param_1 params["start_date"].value param_2 params["start_date"].value param_3 params["start_date"].value param_4 params["end_date"].value transaction_id transaction_id dataSetRow["transaction_id"] string startDate startDate var temp = dataSetRow["startDate"] var format = params["date_format"].value; Formatter.format(temp,format) string true endDate endDate var temp = dataSetRow["endDate"] var format = params["date_format"].value; Formatter.format(temp,format) string true sched_action_date sched_action_date dataSetRow["sched_action_date"] date-time sched_action sched_action dataSetRow["sched_action"] string sched_fullname sched_fullname dataSetRow["sched_fullname"] string transaction_operation transaction_operation dataSetRow["transaction_operation"] string srm_schedule_confirmation_status srm_schedule_confirmation_status dataSetRow["srm_schedule_confirmation_status"] string is_suspended is_suspended if(dataSetRow["is_suspended"]) { "X"; } else { ""; } string true lock_fullname lock_fullname dataSetRow["lock_fullname"] string access_point_id access_point_id dataSetRow["access_point_id"] string access_point_description access_point_description dataSetRow["access_point_description"] string

solid thin solid thin solid thin bold 2pt 0.3in Keyholder solid thin solid thin solid thin solid thin bold 2pt 0.3in Lock solid thin solid thin solid thin solid thin bold 2pt 0.3in Start solid thin solid thin solid thin solid thin bold 2pt 0.3in End solid thin solid thin solid thin solid thin bold 2pt 0.3in Action solid thin solid thin solid thin solid thin bold 2pt 0.3in Changed on solid thin solid thin solid thin solid thin bold 2pt 0.3in Changed by solid thin solid thin solid thin solid thin bold 2pt 0.3in Operation solid thin solid thin solid thin solid thin bold 2pt 0.3in Confirmation solid thin solid thin solid thin bold 2pt 0.3in Suspend

solid thin solid thin black solid thin lock_fullname solid thin solid thin solid thin black solid thin access_point_description solid thin solid thin solid thin black solid thin startDate solid thin solid thin solid thin solid thin endDate solid thin black solid thin solid thin black solid thin sched_action solid thin solid thin solid thin solid thin sched_action_date solid thin solid thin solid thin solid thin sched_fullname solid thin black solid thin black solid thin black solid thin transaction_operation solid thin solid thin black solid thin black solid thin srm_schedule_confirmation_status solid thin solid thin solid thin is_suspended