Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.
<cfquery name = "QSearchResultRecord" datasource='#strDSN#' username='#strUID#' password='#strPWD#' result="r"> SELECT case when L.ParentIssueID is null then L.IssueId else L.ParentIssueID end as TopIssueID , L.IssueID , L.ParentIssueID , T.TicketNumber , L.TitleOfIssue , I.Status , L.DateCreated , C.Category FROM LogEntry L LEFT JOIN IssueStatus I on I.StatusID = L.StatusID LEFT JOIN CategoryType C on C.CategoryTypeID = L.CategoryTypeID LEFT JOIN TicketNumber T on T.TicketNumberID = L.TicketNumberID <cfif len(FoundIssueIDs) eq 0 > where 1 = 2 <cfelse> where L.IssueID in (#FoundIssueIDs#) </cfif> order by 1 desc, case when L.parentIssueID is null then 1 else 2 end </cfquery> <cfquery name = "QSearchResult" datasource='#strDSN#' username='#strUID#' password='#strPWD#' result="rcr"> select * from QSearchResultRecord </cfquery>
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|looping over JSON Object and insert into query||3||78|
|Create array from a query and then loop it with coldfusion||12||99|
|CFIf Syntax and Logic||27||76|
|Is it possible to confirm someone has attached a document to a form using Cold Fusion before they can submit the form?||48||76|
Join the community of 500,000 technology professionals and ask your questions.