API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 18th, 2018
152
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.47 KB | None | 0 0
raw download clone embed print report
  1. mysql> select workflowstep_name, role, processing, issue, idle, onhold, time_in, time_out, username, left(comment, 30), reject_error, reject_category from tat_tat where deliverable_id = 291127;
  2. +------------------------+-----------------+-------------+---------+--------------+---------+---------------------+---------------------+----------------------------------+--------------------------------+--------------------------------+-------------------+
  3. | workflowstep_name | role | processing | issue | idle | onhold | time_in | time_out | username | left(comment, 30) | reject_error | reject_category |
  4. +------------------------+-----------------+-------------+---------+--------------+---------+---------------------+---------------------+----------------------------------+--------------------------------+--------------------------------+-------------------+
  5. | brief | project manager | 0.00000 | 0.00000 | 1407.00000 | 0.00000 | 2016-12-22 12:07:21 | 2016-12-22 12:30:48 | agata.pawlak@tequilapolska.pl | Do przygotowania jest krtka br | NULL | NULL |
  6. | order verification | operator | 24.00000 | 0.00000 | 4298.00000 | 0.00000 | 2016-12-22 12:30:48 | 2016-12-22 13:42:50 | ireneusz.dylakowski@egplusww.com | | NULL | NULL |
  7. | artwork preparation | operator | 77469.00000 | 0.00000 | 11.00000 | 0.00000 | 2016-12-22 13:42:50 | 2016-12-23 11:14:10 | ireneusz.dylakowski@egplusww.com | | NULL | NULL |
  8. | QA proofreading | QA | 0.00000 | 0.00000 | 483.00000 | 0.00000 | 2016-12-23 11:14:10 | 2016-12-23 11:22:13 | pawel.antosiewicz@egplusww.com | | NULL | NULL |
  9. | artwork preparation | operator | 10.00000 | 0.00000 | 37.00000 | 0.00000 | 2016-12-23 11:22:13 | 2016-12-23 11:23:00 | ireneusz.dylakowski@egplusww.com | | NULL | NULL |
  10. | pm approval | project manager | 0.00000 | 0.00000 | 9066.00000 | 0.00000 | 2016-12-23 11:23:00 | 2016-12-23 13:54:06 | agata.pawlak@tequilapolska.pl | Prosz o powikszenie fontu,tak | Incomplete brief from PM | Incomplete Brief |
  11. | artwork preparation | operator | 24.00000 | 0.00000 | 339893.00000 | 0.00000 | 2016-12-23 13:54:06 | 2016-12-27 12:19:23 | ireneusz.dylakowski@egplusww.com | | NULL | NULL |
  12. | QA proofreading | QA | 4712.00000 | 0.00000 | 1023.00000 | 0.00000 | 2016-12-27 12:19:23 | 2016-12-27 13:54:58 | agnieszka.fila@egplusww.com | popr. w pliku | NULL | NULL |
  13. | pm QA review | project manager | 0.00000 | 0.00000 | 118.00000 | 0.00000 | 2016-12-27 13:54:58 | 2016-12-27 13:56:56 | paulina.pulrol@tequilapolska.pl | Prosz o wprowadzenie uwag QA. | Other | Production Error |
  14. | artwork preparation | operator | 1262.00000 | 0.00000 | 107.00000 | 0.00000 | 2016-12-27 13:56:56 | 2016-12-27 14:19:45 | ireneusz.dylakowski@egplusww.com | wprowadzone | NULL | NULL |
  15. | pm approval | project manager | 0.00000 | 0.00000 | 786.00000 | 0.00000 | 2016-12-27 14:19:45 | 2016-12-27 14:32:51 | paulina.pulrol@tequilapolska.pl | u klienta | NULL | NULL |
  16. | in client approval | project manager | 0.00000 | 0.00000 | 76411.00000 | 0.00000 | 2016-12-27 14:32:51 | 2016-12-28 11:46:22 | paulina.pulrol@tequilapolska.pl | 3 rzeczy zanim pjdziemy dalej: | De-brief (Changed copy/layout) | Client's feedback |
  17. | artwork preparation | operator | 1067.00000 | 0.00000 | 84616.00000 | 0.00000 | 2016-12-28 11:46:22 | 2016-12-29 11:34:25 | ireneusz.dylakowski@egplusww.com | | NULL | NULL |
  18. | pm approval | project manager | 0.00000 | 0.00000 | 487.00000 | 0.00000 | 2016-12-29 11:34:25 | 2016-12-29 11:42:32 | paulina.pulrol@tequilapolska.pl | u klienta | NULL | NULL |
  19. | in client approval | project manager | 0.00000 | 0.00000 | 524153.00000 | 0.00000 | 2016-12-29 11:42:32 | 2017-01-04 13:18:25 | agata.pawlak@tequilapolska.pl | poprosz o zmiane stopki zgodni | De-brief (Changed copy/layout) | Client's feedback |
  20. | artwork preparation | operator | 317.00000 | 0.00000 | 2126.00000 | 0.00000 | 2017-01-04 13:18:25 | 2017-01-04 13:59:08 | ireneusz.dylakowski@egplusww.com | | NULL | NULL |
  21. | pm approval | project manager | 0.00000 | 0.00000 | 6128.00000 | 0.00000 | 2017-01-04 13:59:08 | 2017-01-04 15:41:16 | agata.pawlak@tequilapolska.pl | Prosze o zmiane fontu w stopce | NULL | NULL |
  22. | artwork preparation | operator | 96.00000 | 0.00000 | 983.00000 | 0.00000 | 2017-01-04 15:41:16 | 2017-01-04 15:59:15 | ireneusz.dylakowski@egplusww.com | | NULL | NULL |
  23. | pm approval | project manager | 0.00000 | 0.00000 | 1382.00000 | 0.00000 | 2017-01-04 15:59:15 | 2017-01-04 16:22:17 | agata.pawlak@tequilapolska.pl | u klienta | NULL | NULL |
  24. | in client approval | project manager | 0.00000 | 0.00000 | 62923.00000 | 0.00000 | 2017-01-04 16:22:17 | 2017-01-05 09:51:00 | agata.pawlak@tequilapolska.pl | Prosze przeniesc stopke na str | De-brief (Changed copy/layout) | Client's feedback |
  25. | artwork preparation | operator | 1627.00000 | 0.00000 | 2662.00000 | 0.00000 | 2017-01-05 09:51:00 | 2017-01-05 11:02:29 | michal.chamerski@egplusww.com | | NULL | NULL |
  26. | pm approval | project manager | 0.00000 | 0.00000 | 687.00000 | 0.00000 | 2017-01-05 11:02:29 | 2017-01-05 11:13:56 | agata.pawlak@tequilapolska.pl | Poprosze do testow do drukarni | NULL | NULL |
  27. | artwork preparation | operator | 88.00000 | 0.00000 | 1345.00000 | 0.00000 | 2017-01-05 11:13:56 | 2017-01-05 11:37:49 | michal.chamerski@egplusww.com | | NULL | NULL |
  28. | pm approval | project manager | 0.00000 | 0.00000 | 5289.00000 | 0.00000 | 2017-01-05 11:37:49 | 2017-01-05 13:05:58 | agata.pawlak@tequilapolska.pl | u klienta/uwagi pn/wt | NULL | NULL |
  29. | in client approval | project manager | 0.00000 | 0.00000 | 598378.00000 | 0.00000 | 2017-01-05 13:05:58 | 2017-01-12 11:18:56 | paulina.pulrol@tequilapolska.pl | Prosz o pliki produkcyjne do t | NULL | NULL |
  30. | artwork preparation | operator | 282.00000 | 0.00000 | 1966.00000 | 0.00000 | 2017-01-12 11:18:56 | 2017-01-12 11:56:24 | pawel.antosiewicz@egplusww.com | paczka z materialami do druku | NULL | NULL |
  31. | pm approval | project manager | 0.00000 | 0.00000 | 2691.00000 | 0.00000 | 2017-01-12 11:56:24 | 2017-01-12 12:41:15 | paulina.pulrol@tequilapolska.pl | Dzikuj bardzo za pliki prbne. | NULL | NULL |
  32. | artwork preparation | operator | 2542.00000 | 0.00000 | 4715.00000 | 0.00000 | 2017-01-12 12:41:15 | 2017-01-12 14:42:12 | michal.chamerski@egplusww.com | | NULL | NULL |
  33. | pm approval | project manager | 0.00000 | 0.00000 | 6384.00000 | 0.00000 | 2017-01-12 14:42:12 | 2017-01-12 16:28:36 | paulina.pulrol@tequilapolska.pl | | NULL | NULL |
  34. | in client approval | project manager | 0.00000 | 0.00000 | 187.00000 | 0.00000 | 2017-01-12 16:28:36 | 2017-01-12 16:31:43 | paulina.pulrol@tequilapolska.pl | Prosz o czytanie. Literwki, wi | NULL | NULL |
  35. | QA proofreading | QA | 50331.00000 | 0.00000 | 11119.00000 | 0.00000 | 2017-01-12 16:31:43 | 2017-01-13 09:35:53 | anna.alfut@egplusww.com | Zaczam uwagi do weryfikacji. | NULL | NULL |
  36. | pm QA review | project manager | 0.00000 | 0.00000 | 267603.00000 | 0.00000 | 2017-01-13 09:35:53 | 2017-01-16 11:55:56 | paulina.pulrol@tequilapolska.pl | Prosz o wprowadzenie zaczonych | NULL | NULL |
  37. | artwork preparation | operator | 3959.00000 | 0.00000 | 8344.00000 | 0.00000 | 2017-01-16 11:55:56 | 2017-01-16 15:20:59 | ireneusz.dylakowski@egplusww.com | | NULL | NULL |
  38. | pm approval | project manager | 0.00000 | 0.00000 | 13293.00000 | 0.00000 | 2017-01-16 15:20:59 | 2017-01-16 19:02:32 | paulina.pulrol@tequilapolska.pl | Prosz usun "Zacznik 1" z lewej | Other | Production Error |
  39. | artwork preparation | operator | 215.00000 | 0.00000 | 2674.00000 | 0.00000 | 2017-01-16 19:02:32 | 2017-01-16 19:50:41 | ireneusz.dylakowski@egplusww.com | | NULL | NULL |
  40. | pm approval | project manager | 0.00000 | 0.00000 | 6672.00000 | 0.00000 | 2017-01-16 19:50:41 | 2017-01-16 21:41:53 | paulina.pulrol@tequilapolska.pl | u klienta | NULL | NULL |
  41. | in client approval | project manager | 0.00000 | 0.00000 | 42987.00000 | 0.00000 | 2017-01-16 21:41:53 | 2017-01-17 09:38:20 | paulina.pulrol@tequilapolska.pl | Prosz o wprowadzenie zaczonej | Minor correction | Client's feedback |
  42. | artwork preparation | operator | 1165.00000 | 0.00000 | 200.00000 | 0.00000 | 2017-01-17 09:38:20 | 2017-01-17 10:01:05 | michal.chamerski@egplusww.com | | NULL | NULL |
  43. | pm approval | project manager | 0.00000 | 0.00000 | 3388.00000 | 0.00000 | 2017-01-17 10:01:05 | 2017-01-17 10:57:33 | paulina.pulrol@tequilapolska.pl | u klienta | NULL | NULL |
  44. | in client approval | project manager | 0.00000 | 0.00000 | 1764.00000 | 0.00000 | 2017-01-17 10:57:33 | 2017-01-17 11:26:57 | paulina.pulrol@tequilapolska.pl | Prosz o czytanie przed drukiem | NULL | NULL |
  45. | QA proofreading | QA | 1474.00000 | 0.00000 | 3300.00000 | 0.00000 | 2017-01-17 11:26:57 | 2017-01-17 12:46:31 | agnieszka.fila@egplusww.com | popr. w pliku | NULL | NULL |
  46. | pm QA review | project manager | 0.00000 | 0.00000 | 331.00000 | 0.00000 | 2017-01-17 12:46:31 | 2017-01-17 12:52:02 | paulina.pulrol@tequilapolska.pl | Prosz o wprowadzeni uwag z zac | Other | Production Error |
  47. | artwork preparation | operator | 246.00000 | 0.00000 | 243.00000 | 0.00000 | 2017-01-17 12:52:02 | 2017-01-17 13:00:11 | michal.chamerski@egplusww.com | | NULL | NULL |
  48. | pm approval | project manager | 0.00000 | 0.00000 | 289.00000 | 0.00000 | 2017-01-17 13:00:11 | 2017-01-17 13:05:00 | paulina.pulrol@tequilapolska.pl | | NULL | NULL |
  49. | in client approval | project manager | 0.00000 | 0.00000 | 32.00000 | 0.00000 | 2017-01-17 13:05:00 | 2017-01-17 13:05:32 | paulina.pulrol@tequilapolska.pl | Poprosz plik produkcyjny. | NULL | NULL |
  50. | final file preparation | operator | 3411.00000 | 0.00000 | 998.00000 | 0.00000 | 2017-01-17 13:05:32 | 2017-01-17 14:19:01 | michal.chamerski@egplusww.com | | NULL | NULL |
  51. | technical QA | operator | 716.00000 | 0.00000 | 2777.00000 | 0.00000 | 2017-01-17 14:19:01 | 2017-01-17 15:17:14 | ireneusz.dylakowski@egplusww.com | Plik produkcyjny. | NULL | NULL |
  52. | final pm approval | project manager | 0.00000 | 0.00000 | 854.00000 | 0.00000 | 2017-01-17 15:17:14 | 2017-01-17 15:31:28 | paulina.pulrol@tequilapolska.pl | Poprosz jeszcze o pdf do zawie | De-brief (Changed copy/layout) | Client's feedback |
  53. | artwork preparation | operator | 257.00000 | 0.00000 | 136.00000 | 0.00000 | 2017-01-17 15:31:28 | 2017-01-17 15:38:01 | ireneusz.dylakowski@egplusww.com | | NULL | NULL |
  54. | pm approval | project manager | 0.00000 | 0.00000 | 63900.00000 | 0.00000 | 2017-01-17 15:38:01 | 2017-01-18 09:23:01 | paulina.pulrol@tequilapolska.pl | Materiay powinny by w dokadnym | NULL | NULL |
  55. | artwork preparation | operator | 3851.00000 | 0.00000 | 80.00000 | 0.00000 | 2017-01-18 09:23:01 | 2017-01-18 10:28:32 | michal.chamerski@egplusww.com | | NULL | NULL |
  56. | pm approval | project manager | 0.00000 | 0.00000 | 331.00000 | 0.00000 | 2017-01-18 10:28:32 | 2017-01-18 10:34:03 | paulina.pulrol@tequilapolska.pl | Prosz o przygotowanie pliku pr | NULL | NULL |
  57. | artwork preparation | operator | 23.00000 | 0.00000 | 46.00000 | 0.00000 | 2017-01-18 10:34:03 | 2017-01-18 10:35:12 | pawel.antosiewicz@egplusww.com | odklikane | NULL | NULL |
  58. | pm approval | project manager | 0.00000 | 0.00000 | 43.00000 | 0.00000 | 2017-01-18 10:35:12 | 2017-01-18 10:35:55 | paulina.pulrol@tequilapolska.pl | Prosz o przygotowanie pliku pr | NULL | NULL |
  59. | final file preparation | operator | 12.00000 | 0.00000 | 59.00000 | 0.00000 | 2017-01-18 10:35:55 | 2017-01-18 10:37:06 | michal.chamerski@egplusww.com | | NULL | NULL |
  60. | technical QA | operator | 340.00000 | 0.00000 | 206.00000 | 0.00000 | 2017-01-18 10:37:06 | 2017-01-18 10:46:12 | pawel.antosiewicz@egplusww.com | | NULL | NULL |
  61. | final pm approval | project manager | 0.00000 | 0.00000 | 12927.00000 | 0.00000 | 2017-01-18 10:46:12 | 2017-01-18 14:21:39 | paulina.pulrol@tequilapolska.pl | Jeszcze jedna proba: w tym pli | Minor correction | Client's feedback |
  62. | artwork preparation | operator | 578.00000 | 0.00000 | 415.00000 | 0.00000 | 2017-01-18 14:21:39 | 2017-01-18 14:38:12 | pawel.antosiewicz@egplusww.com | | NULL | NULL |
  63. | pm approval | project manager | 0.00000 | 0.00000 | 7491.00000 | 0.00000 | 2017-01-18 14:38:12 | 2017-01-18 16:43:03 | paulina.pulrol@tequilapolska.pl | u klienta | NULL | NULL |
  64. | in client approval | project manager | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 2017-01-18 16:43:03 | NULL | NULL | | NULL | NULL |
  65. +------------------------+-----------------+-------------+---------+--------------+---------+---------------------+---------------------+----------------------------------+--------------------------------+--------------------------------+-------------------+
  66. 60 rows in set (0.03 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!