| SQL Id | SQL Text |
| 07m1sad7dj1g8 |
select User_Calender_Header_ID, Patient_ID, Event_Type_Lkp_ID, case when event_type='Appointment' then title when event_type='Todo' then title else encryption.decrypt_char(title, '0123456789ABCDEFFEDCBA9876543210') end as title, Start_Time, To_Time, Quantity, Cost, When_To_End, End_Time, Recurrent_ID, Notes, Assigned_To, Contact_With, Contact_Lkp_ID, Contact_Where, encryption.decrypt_char(User_Name, '0123456789ABCDEFFEDCBA9876543210') as user_name, encryption.decrypt_char(Contact_Name, '0123456789ABCDEFFEDCBA9876543210') as contact_name, Recurrent_Type, Event_Type, Drug_Id, Side_Effects, Currently_Used, Special_Instruction, Dosage, Times_Perday, Timings, Status , Created_By, Created_Date, Updated_By, Updated_Date, weekday, monthday, encryption.decrypt_char(FIRST_NAME, '0123456789ABCDEFFEDCBA9876543210') as first_name, encryption.decrypt_char(LAST_NAME, '0123456789ABCDEFFEDCBA9876543210') as last_name, encryption.decrypt_char(MIDDLE_INITIAL, '0123456789ABCDEFFEDCBA9876543210') as middle_initial, PICTURE_PATH, encryption.decrypt_char(PATIENT_NAME, '0123456789ABCDEFFEDCBA9876543210') as patient_name, encryption.decrypt_char(PATIENT_LAST_NAME, '0123456789ABCDEFFEDCBA9876543210') as patient_last_name, NOTES_COUNT, ADD_TO_CALENDAR, ISTIMEBOUND from vw_user_calendar_iteration where Patient_ID in (2312, 2339) and (((Start_Time between to_date('11-20-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-27-2010 18:29', 'MM-DD-YYYY HH24:MI') or End
_Time between to_date('11-20-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-27-2010 18:29', 'MM-DD-YYYY HH24:MI')) or (When_To_End='Never' or When_To_End='Until')) or (((Event_Type='Todo' and Start_Time between to_date('11-20-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-27-2010 18:29', 'MM-DD-YYYY HH24:MI')) and (End_Time is null or When_To_End is null)) or (((Event_Type='Item' and Start_Time between to_date('11-20-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-27-2010 18:29', 'MM-DD-YYYY HH24:MI')) and (End_Time is null or When_To_End is null)) or ((Event_Type='Prescription' and Start_Time between to_date('11-20-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-27-2010 18:29', 'MM-DD-YYYY HH24:MI')) and (End_Time is null or When_To_End is null))))) and event_type !='Treatment' and add_to_calendar =1 order by start_time asc |
| 0r38cnkzx304r |
select User_Calender_Header_ID, Patient_ID, Event_Type_Lkp_ID, case when event_type='Appointment' then title when event_type='Todo' then title else encryption.decrypt_char(title, '0123456789ABCDEFFEDCBA9876543210') end as title, Start_Time, To_Time, Quantity, Cost, When_To_End, End_Time, Recurrent_ID, Notes, Assigned_To, Contact_With, Contact_Lkp_ID, Contact_Where, encryption.decrypt_char(User_Name, '0123456789ABCDEFFEDCBA9876543210') as user_name, encryption.decrypt_char(Contact_Name, '0123456789ABCDEFFEDCBA9876543210') as contact_name, Recurrent_Type, Event_Type, Drug_Id, Side_Effects, Currently_Used, Special_Instruction, Dosage, Times_Perday, Timings, Status , Created_By, Created_Date, Updated_By, Updated_Date, weekday, monthday, encryption.decrypt_char(FIRST_NAME, '0123456789ABCDEFFEDCBA9876543210') as first_name, encryption.decrypt_char(LAST_NAME, '0123456789ABCDEFFEDCBA9876543210') as last_name, encryption.decrypt_char(MIDDLE_INITIAL, '0123456789ABCDEFFEDCBA9876543210') as middle_initial, PICTURE_PATH, encryption.decrypt_char(PATIENT_NAME, '0123456789ABCDEFFEDCBA9876543210') as patient_name, encryption.decrypt_char(PATIENT_LAST_NAME, '0123456789ABCDEFFEDCBA9876543210') as patient_last_name, NOTES_COUNT, ADD_TO_CALENDAR, ISTIMEBOUND from vw_user_calendar_iteration where Patient_ID in (2418) and (((Start_Time between to_date('11-20-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-27-2010 18:29', 'MM-DD-YYYY HH24:MI') or End_Time
between to_date('11-20-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-27-2010 18:29', 'MM-DD-YYYY HH24:MI')) or (When_To_End='Never' or When_To_End='Until')) or (((Event_Type='Todo' and Start_Time between to_date('11-20-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-27-2010 18:29', 'MM-DD-YYYY HH24:MI')) and (End_Time is null or When_To_End is null)) or (((Event_Type='Item' and Start_Time between to_date('11-20-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-27-2010 18:29', 'MM-DD-YYYY HH24:MI')) and (End_Time is null or When_To_End is null)) or ((Event_Type='Prescription' and Start_Time between to_date('11-20-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-27-2010 18:29', 'MM-DD-YYYY HH24:MI')) and (End_Time is null or When_To_End is null))))) and event_type !='Treatment' and add_to_calendar =1 order by start_time asc |
| 59nf178vrwr1k | select this_.SESSION_LOG_ID as SESSION1_48_0_, this_.USER_ID as USER2_48_0_, this_.LOGIN_TIME as LOGIN3_48_0_, this_.LOGOUT_TIME as LOGOUT4_48_0_, this_.SESSION_TOKEN as SESSION5_48_0_, this_.IP_ADD as IP6_48_0_, this_.AGENT as AGENT48_0_, this_.DESCRIPTION as DESCRIPT8_48_0_, this_.IS_AUTO_LOGGED_OUT as IS9_48_0_ from SESSION_LOG this_ where (this_.USER_ID=:1 and this_.SESSION_TOKEN=:2 ) |
| 8y3wz9swz7zjp | select user_id from user_profile where (lower(encryption.decrypt_char(user_email, '0123456789ABCDEFFEDCBA9876543210')) = 'loadtest222_3' or lower(encryption.decrypt_char(user_name, '0123456789ABCDEFFEDCBA9876543210')) = 'loadtest222_3') and password = '7cbfa25a0ba328ee7c8058e62dcdbedf8544f293' and is_active = 1 |
| d2ubmzm9u5c2k | Select user_id from user_profile where lower(encryption.decrypt_char(user_email, '0123456789ABCDEFFEDCBA9876543210'))='loadtest222_3@tuscan.com' |
| ffb720ahf723v | insert into AUDIT_FILTER_LOG (SESSION_LOG_ID, USER_ID, AUDIT_TIME, URI, MODULE_NAME, HTTP_METHOD, OPERATION_NAME, QUERY_STRING, DATA, AUDIT_LOG_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 ) |
| fzdsykgx23nxx | select this_.User_ID as User1_47_0_, this_.Session_Token as Session2_47_0_, this_.Last_Action as Last3_47_0_, this_.Is_Logged_in as Is4_47_0_ from User_Profile_Login this_ where (this_.Is_Logged_in=:1 and this_.Session_Token=:2 ) and this_.User_ID=:3 |
| gsj86dfmvsbjc |
select User_Calender_Header_ID, Patient_ID, Event_Type_Lkp_ID, case when event_type='Appointment' then title when event_type='Todo' then title else encryption.decrypt_char(title, '0123456789ABCDEFFEDCBA9876543210') end as title, Start_Time, To_Time, Quantity, Cost, When_To_End, End_Time, Recurrent_ID, Notes, Assigned_To, Contact_With, Contact_Lkp_ID, Contact_Where, encryption.decrypt_char(User_Name, '0123456789ABCDEFFEDCBA9876543210') as user_name, encryption.decrypt_char(Contact_Name, '0123456789ABCDEFFEDCBA9876543210') as contact_name, Recurrent_Type, Event_Type, Drug_Id, Side_Effects, Currently_Used, Special_Instruction, Dosage, Times_Perday, Timings, Status , Created_By, Created_Date, Updated_By, Updated_Date, weekday, monthday, encryption.decrypt_char(FIRST_NAME, '0123456789ABCDEFFEDCBA9876543210') as first_name, encryption.decrypt_char(LAST_NAME, '0123456789ABCDEFFEDCBA9876543210') as last_name, encryption.decrypt_char(MIDDLE_INITIAL, '0123456789ABCDEFFEDCBA9876543210') as middle_initial, PICTURE_PATH, encryption.decrypt_char(PATIENT_NAME, '0123456789ABCDEFFEDCBA9876543210') as patient_name, encryption.decrypt_char(PATIENT_LAST_NAME, '0123456789ABCDEFFEDCBA9876543210') as patient_last_name, NOTES_COUNT, ADD_TO_CALENDAR, ISTIMEBOUND from vw_user_calendar_iteration where Patient_ID in (4852, 4978) and (((Start_Time between to_date('11-23-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-24-2010 18:29', 'MM-DD-YYYY HH24:MI') or End
_Time between to_date('11-23-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-24-2010 18:29', 'MM-DD-YYYY HH24:MI')) or (When_To_End='Never' or When_To_End='Until')) or (((Event_Type='Todo' and Start_Time between to_date('11-23-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-24-2010 18:29', 'MM-DD-YYYY HH24:MI')) and (End_Time is null or When_To_End is null)) or (((Event_Type='Item' and Start_Time between to_date('11-23-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-24-2010 18:29', 'MM-DD-YYYY HH24:MI')) and (End_Time is null or When_To_End is null)) or ((Event_Type='Prescription' and Start_Time between to_date('11-23-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-24-2010 18:29', 'MM-DD-YYYY HH24:MI')) and (End_Time is null or When_To_End is null))))) and event_type !='Treatment' and add_to_calendar =1 order by start_time asc |
| gu6fw2w1rz1dw |
select User_Calender_Header_ID, Patient_ID, Event_Type_Lkp_ID, case when event_type='Appointment' then title when event_type='Todo' then title else encryption.decrypt_char(title, '0123456789ABCDEFFEDCBA9876543210') end as title, Start_Time, To_Time, Quantity, Cost, When_To_End, End_Time, Recurrent_ID, Notes, Assigned_To, Contact_With, Contact_Lkp_ID, Contact_Where, encryption.decrypt_char(User_Name, '0123456789ABCDEFFEDCBA9876543210') as user_name, encryption.decrypt_char(Contact_Name, '0123456789ABCDEFFEDCBA9876543210') as contact_name, Recurrent_Type, Event_Type, Drug_Id, Side_Effects, Currently_Used, Special_Instruction, Dosage, Times_Perday, Timings, Status , Created_By, Created_Date, Updated_By, Updated_Date, weekday, monthday, encryption.decrypt_char(FIRST_NAME, '0123456789ABCDEFFEDCBA9876543210') as first_name, encryption.decrypt_char(LAST_NAME, '0123456789ABCDEFFEDCBA9876543210') as last_name, encryption.decrypt_char(MIDDLE_INITIAL, '0123456789ABCDEFFEDCBA9876543210') as middle_initial, PICTURE_PATH, encryption.decrypt_char(PATIENT_NAME, '0123456789ABCDEFFEDCBA9876543210') as patient_name, encryption.decrypt_char(PATIENT_LAST_NAME, '0123456789ABCDEFFEDCBA9876543210') as patient_last_name, NOTES_COUNT, ADD_TO_CALENDAR, ISTIMEBOUND from vw_user_calendar_iteration where Patient_ID in (2470) and (((Start_Time between to_date('11-20-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-27-2010 18:29', 'MM-DD-YYYY HH24:MI') or End_Time
between to_date('11-20-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-27-2010 18:29', 'MM-DD-YYYY HH24:MI')) or (When_To_End='Never' or When_To_End='Until')) or (((Event_Type='Todo' and Start_Time between to_date('11-20-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-27-2010 18:29', 'MM-DD-YYYY HH24:MI')) and (End_Time is null or When_To_End is null)) or (((Event_Type='Item' and Start_Time between to_date('11-20-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-27-2010 18:29', 'MM-DD-YYYY HH24:MI')) and (End_Time is null or When_To_End is null)) or ((Event_Type='Prescription' and Start_Time between to_date('11-20-2010 18:30', 'MM-DD-YYYY HH24:MI') and to_date('11-27-2010 18:29', 'MM-DD-YYYY HH24:MI')) and (End_Time is null or When_To_End is null))))) and event_type !='Treatment' and add_to_calendar =1 order by start_time asc |