Advertisement
Guest User

Untitled

a guest
Feb 18th, 2020
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. SET ThousandSep=' ';
  2. SET DecimalSep=',';
  3. SET MoneyThousandSep=' ';
  4. SET MoneyDecimalSep=',';
  5. SET MoneyFormat='# ##0,00 ₽;-# ##0,00 ₽';
  6. SET TimeFormat='h:mm:ss';
  7. SET DateFormat='DD.MM.YYYY';
  8. SET TimestampFormat='DD.MM.YYYY h:mm:ss[.fff]';
  9. SET MonthNames='янв;фев;мар;апр;май;июн;июл;авг;сен;окт;ноя;дек';
  10. SET DayNames='Пн;Вт;Ср;Чт;Пт;Сб;Вс';
  11.  
  12. ODBC CONNECT TO jira;
  13.  
  14. LOAD ID,
  15. pkey,
  16. issuenum,
  17. PROJECT,
  18. REPORTER,
  19. ASSIGNEE,
  20. CREATOR,
  21. issuetype as ID.jira.issuetype,
  22. SUMMARY,
  23. DESCRIPTION,
  24. ENVIRONMENT,
  25. PRIORITY,
  26. RESOLUTION,
  27. issuestatus,
  28. CREATED,
  29. UPDATED,
  30. DUEDATE,
  31. RESOLUTIONDATE,
  32. VOTES,
  33. WATCHES,
  34. TIMEORIGINALESTIMATE,
  35. TIMEESTIMATE,
  36. TIMESPENT,
  37. `WORKFLOW_ID`,
  38. SECURITY,
  39. FIXFOR,
  40. COMPONENT;
  41. SQL SELECT *
  42. FROM jira.jiraissue;
  43.  
  44. LOAD ID,
  45. SEQUENCE,
  46. pname,
  47. pstyle,
  48. DESCRIPTION,
  49. ICONURL,
  50. AVATAR;
  51. SQL SELECT *
  52. FROM jira.issuetype;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement