daily pastebin goal
41%
SHARE
TWEET

Untitled

a guest Jan 24th, 2019 67 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. BEGIN FOR
  2. SELECT 1
  3. select U.id,U.customer_id,U.user_role,U.hashed_password,U.display_name,U.description,U.email_address,U.business_hours_start,U.business_hours_end,U.timezone,U.weekend_days,U.enabled,U.data_source,U.password_data_source,U.pin,U.last_imported_serial,U.is_deleted,U.deleted_serial,U.external_key,U.external_key_digits,U.ivr_label,U.password_reset,U.preferred_voice,U.password_expiry_date,U.invalid_password_count,U.authcode,U.authcode_expiry_date,U.authenticate_with_unicorn, E.address
  4. from ( ( select
  5. U.id,U.customer_id,U.user_role,U.hashed_password,U.display_name,U.description,U.email_address,U.business_hours_start,U.business_hours_end,U.timezone,U.weekend_days,U.enabled,U.data_source,U.password_data_source,U.pin,U.last_imported_serial,U.is_deleted,U.deleted_serial,U.external_key,U.external_key_digits,U.ivr_label,U.password_reset,U.preferred_voice,U.password_expiry_date,U.invalid_password_count,U.authcode,U.authcode_expiry_date,U.authenticate_with_unicorn
  6. from dat_user U
  7.  where U.customer_id = 1000 and  U.id in ( select user_id from dat_notification_user where message_id = 10753 )  order by U.display_name , U.id limit 100 ) U left join dat_user_email_addrs E on U.id=E.user_id )  order by U.display_name , U.id, E.addr_index
  8. HAS NEXT
  9. NEXT
  10. Begin Rec query
  11. End Rec query
  12. Begin printNotificationBasics query
  13. SELECT 1
  14. select count(*) from scheduled_tasks SE  where SE.task_executor not in ('com.m1.cmc.mgmt.tasks.CancelNotificationTask','com.m1.cmc.mgmt.tasks.EmailNotificationResultsTask') and SE.class_2='10753' and claimed_by is NULL
  15. End printNotificationBasics query
  16. Begin pair queries
  17. SELECT 1
  18. select s.user_id, s.device_id, s.status_id, s.message, s.device_name, s.device_type, s.device_address, s.status_timestamp, s.message_id from dat_notification_status s  where s.message_id = 10753 and s.user_id in (9432) order by s.status_timestamp
  19. SELECT 1
  20. select cp.id, cp.provider_id, cp.session_id, cp.customer_id, cp.message_id, cp.device_id, cp.device_address, cp.start_date, cp.end_date, cp.application_token, cp.voice,cp.call_type,cp.call_retry_count,cp.voice_start_date,cp.voice_end_date from dat_call_progress cp  where cp.message_id = 10753 and cp.device_id in (2147486178,2531) order by cp.customer_id
  21. End pair queries
  22. Begin responses query
  23. SELECT 1
  24. select  distinct(ur.message_id), ur.user_id, ur.response, ur.response_time, ur.response_data, ur.response_data_type, us.device_name, us.device_address from dat_notification_user ur, dat_notification_status us where ur.message_id = 10753 and ur.user_id in (9432) and ur.message_id = us.message_id  and ur.user_id = us.user_id and us.device_type > 0  order by ur.message_id
  25. End responses query
  26. END step
  27. END FOR
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top