I am trying to run this SQL Query for a "View" that I have but I keep getting the following error:---- #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '% SQL SECURITY DEFINER VIEW `cycleTimeStatusDMAssigned` AS select `Appian`' at line 3----ALTER ALGORITHM = UNDEFINED DEFINER = appian@% SQL SECURITY DEFINER VIEW `cycleTimeStatusDMAssigned` AS select `Appian`.`asoestatus`.`sowid` AS `sowid`,`Appian`.`asoestatuslkp`.`statusid` AS `statusid`,`Appian`.`asoestatuslkp`.`statustype` AS `engagementstatus`,min(`Appian`.`asoestatus`.`statusstartdate`) AS `startdate`,max(coalesce(`Appian`.`asoestatus`.`statusenddate`,`NowInGMT`())) AS `enddate`,`DurationFormat`(sum(timestampdiff(SECOND,`Appian`.`asoestatus`.`statusstartdate`,coalesce(`Appian`.`asoestatus`.`statusenddate`,`NowInGMT`())))) AS `EDAcceptedRejected` from (`Appian`.`asoestatus` left join `Appian`.`a...
OriginalPostID-126220
Discussion posts and replies are publicly visible