Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1. I don’t understand why this gave no results →
- Can’t we use these ‘%’ signs with customfields?
- SELECT 'Ticket Audit Logs.Department' AS 'Origin Department', CUSTOMFIELD('Tickets', 'Product Name') AS 'Product Name', CUSTOMFIELD('Tickets', 'Product Type'), CUSTOMFIELD('Tickets', 'Platform') AS 'Platform', 'Ticket Audit Logs.Department' AS 'Origin Department', 'Tickets.Department' AS 'Current Department', 'Tickets.Owner' AS 'Owner', DATE_format('Ticket Audit Logs.Creation Date', '%Y/%m/%d %H:%i:%s') AS 'Creation Date', CUSTOMFIELD('Tickets', 'Internal Reporting (Auto-Capture KB)', 'Type of sub-issues (auto-capture)') AS 'Type of sub-issues (auto-capture)', CUSTOMFIELD('Tickets', 'Internal Reporting (Auto-Capture KB)', 'Product Name (auto-capture)') AS 'Product Name (auto-capture)', CUSTOMFIELD('Tickets', 'Internal Reporting (Auto-Capture KB)', 'Product Type (auto-capture)') AS 'Product Type (auto-capture)', CUSTOMFIELD('Tickets', 'Internal Reporting (Auto-Capture KB)', 'Country of residence (auto-capture)') AS 'Country of residence (auto-capture)', CUSTOMFIELD('Tickets', 'Internal Reporting (Auto-Capture KB)', 'User Role (auto-capture)') AS 'User Role (auto-capture)', DATE_format('Ticket Audit Logs.Creation Date', '%Y/%m/%01') AS 'Month UPD', DATE_format('Ticket Audit Logs.Creation Date', '%Y/%m/%d') AS 'Day UPD' WHERE CUSTOMFIELD('Tickets', 'Product Name') IN('%MyEnglishLab%', '%Progress%', '%STARK%') AND 'Ticket Audit Logs.Action' = 'New Ticket' AND ('Ticket Audit Logs.Creation Date' >= '1487462400' AND 'Ticket Audit Logs.Creation Date' <= '1503014399') ORDER BY 'Ticket Audit Logs.Creation Date'
- 2. This query produced results (I provided an exemplary, full name of the product)
- ... WHERE CUSTOMFIELD('Tickets', 'Product Name') IN('MyEnglishLab: Focus on Grammar'):
- SELECT 'Ticket Audit Logs.Department' AS 'Origin Department', CUSTOMFIELD('Tickets', 'Product Name') AS 'Product Name', CUSTOMFIELD('Tickets', 'Product Type'), CUSTOMFIELD('Tickets', 'Platform') AS 'Platform', 'Ticket Audit Logs.Department' AS 'Origin Department', 'Tickets.Department' AS 'Current Department', 'Tickets.Owner' AS 'Owner', DATE_format('Ticket Audit Logs.Creation Date', '%Y/%m/%d %H:%i:%s') AS 'Creation Date', CUSTOMFIELD('Tickets', 'Internal Reporting (Auto-Capture KB)', 'Type of sub-issues (auto-capture)') AS 'Type of sub-issues (auto-capture)', CUSTOMFIELD('Tickets', 'Internal Reporting (Auto-Capture KB)', 'Product Name (auto-capture)') AS 'Product Name (auto-capture)', CUSTOMFIELD('Tickets', 'Internal Reporting (Auto-Capture KB)', 'Product Type (auto-capture)') AS 'Product Type (auto-capture)', CUSTOMFIELD('Tickets', 'Internal Reporting (Auto-Capture KB)', 'Country of residence (auto-capture)') AS 'Country of residence (auto-capture)', CUSTOMFIELD('Tickets', 'Internal Reporting (Auto-Capture KB)', 'User Role (auto-capture)') AS 'User Role (auto-capture)', DATE_format('Ticket Audit Logs.Creation Date', '%Y/%m/%01') AS 'Month UPD', DATE_format('Ticket Audit Logs.Creation Date', '%Y/%m/%d') AS 'Day UPD' WHERE CUSTOMFIELD('Tickets', 'Product Name') IN('MyEnglishLab: Focus on Grammar')AND 'Ticket Audit Logs.Action' = 'New Ticket' AND ('Ticket Audit Logs.Creation Date' >= '1487462400' AND 'Ticket Audit Logs.Creation Date' <= '1503014399') ORDER BY 'Ticket Audit Logs.Creation Date'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
