Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET ThousandSep=' ';
- SET DecimalSep=',';
- SET MoneyThousandSep=' ';
- SET MoneyDecimalSep=',';
- SET MoneyFormat='# ##0,00 ₽;-# ##0,00 ₽';
- SET TimeFormat='h:mm:ss';
- SET DateFormat='DD.MM.YYYY';
- SET TimestampFormat='DD.MM.YYYY h:mm:ss[.fff]';
- SET MonthNames='янв;фев;мар;апр;май;июн;июл;авг;сен;окт;ноя;дек';
- SET DayNames='Пн;Вт;Ср;Чт;Пт;Сб;Вс';
- ODBC CONNECT TO jira;
- LOAD ID,
- pkey,
- issuenum,
- PROJECT,
- REPORTER,
- ASSIGNEE,
- CREATOR,
- issuetype as ID.jira.issuetype,
- SUMMARY,
- DESCRIPTION,
- ENVIRONMENT,
- PRIORITY,
- RESOLUTION,
- issuestatus,
- CREATED,
- UPDATED,
- DUEDATE,
- RESOLUTIONDATE,
- VOTES,
- WATCHES,
- TIMEORIGINALESTIMATE,
- TIMEESTIMATE,
- TIMESPENT,
- `WORKFLOW_ID`,
- SECURITY,
- FIXFOR,
- COMPONENT;
- SQL SELECT *
- FROM jira.jiraissue;
- LOAD ID,
- SEQUENCE,
- pname,
- pstyle,
- DESCRIPTION,
- ICONURL,
- AVATAR;
- SQL SELECT *
- FROM jira.issuetype;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement