Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.
SELECT CASE PROJECT WHEN '10180' THEN 'Corporate Applications' WHEN '10160' THEN 'Corporate Reporting' WHEN '10182' THEN 'CMMI' WHEN '10100' THEN 'Information Technology Office' WHEN '10230' THEN 'Domain Controller/Migration' END AS ProjectName, REPORTER, ASSIGNEE, CASE issuetype WHEN '1' THEN 'Product Defect' WHEN '3' THEN 'Task' WHEN '4' THEN 'Risk' WHEN '20' THEN 'Report' WHEN '21' THEN 'Change' WHEN '22' THEN 'Customization' WHEN '23' THEN 'Updated' WHEN '24' THEN 'Research' WHEN '25' THEN 'Applications Issue Type' WHEN '26' THEN 'Enhancement' END AS IssueTypeDef, SUMMARY, DESCRIPTION, CASE PRIORITY WHEN '1' THEN 'Very High' WHEN '2' THEN 'High' WHEN '3' THEN 'Moderate' WHEN '4' THEN 'Low' WHEN '5' THEN 'Very Low' END AS IssuePriority, PRIORITY, CASE issuestatus WHEN '1' THEN 'Open' WHEN '3' THEN 'In Progress' WHEN '4' THEN 'Reopened' WHEN '5' THEN 'Resolved' WHEN '6' THEN 'Closed' END AS IssueStatusName, CREATED, UPDATED, DUEDATE, ID, PROJECT, TIMESPENT, issuetype, issuestatus FROM jiraissue WHERE (PROJECT = '10180') AND (ASSIGNEE = 'tristanboughton') OR (PROJECT = '10160') AND (ASSIGNEE = 'tristanboughton') OR (PROJECT = '10182') AND (ASSIGNEE = 'tristanboughton') OR (PROJECT = '10100') AND (ASSIGNEE = 'tristanboughton') OR (PROJECT = '10230') AND (issuetype <> '12') AND (issuestatus IN (@StatusParameter)) AND (ASSIGNEE = 'tristanboughton') ORDER BY ProjectName, PRIORITY
|Calculating total percentage per row in Oracle Query||2||22|
Select column_name from INFORMATION.SCHEMA.COLUMNS
|(SQL)How to remove leading zeros||4||25|
|SQL Round a percentage||2||13|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!