1
General Board / Re: Deleting a discussion
« on: August 22, 2025, 10:51:12 pm »
Ok, logging in with the actual administrator account allowed me to delete discussions.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
decoration GreenTick
{
image("GreenTick",0,0,15,15);
}
SELECT goal_obj.ea_guid AS CLASSGUID, goal_obj.Name AS goalName,
outcome_obj.name AS outcomeName, package_obj.Package_ID AS PackageID
FROM t_object goal_obj
INNER JOIN t_package package_obj ON goal_obj.package_id = package_obj.package_id
INNER JOIN t_connector goal_outcome_connector ON goal_obj.object_id = goal_outcome_connector.end_object_id
INNER JOIN t_object outcome_obj ON goal_outcome_connector.start_object_id = outcome_obj.object_id AND outcome_obj.Stereotype = 'ArchiMate_Outcome'
WHERE goal_obj.Stereotype = 'ArchiMate_Goal'
--AND outcome_obj IS NULL
AND package_obj.Package_ID = 2396;-- 2396 is the Package ID of REDACTED