rimashah25 commented on code in PR #6544:
URL: https://github.com/apache/trafficcontrol/pull/6544#discussion_r846457281


##########
traffic_ops/traffic_ops_golang/server/servers.go:
##########
@@ -468,9 +443,7 @@ RETURNING
        offline_reason,
        (SELECT name FROM phys_location WHERE 
phys_location.id=server.phys_location) AS phys_location,
        phys_location AS phys_location_id,
-       profile AS profile_id,
-       (SELECT description FROM profile WHERE profile.id=server.profile) AS 
profile_desc,
-       (SELECT name FROM profile WHERE profile.id=server.profile) AS profile,
+       (SELECT ARRAY_AGG(profile_name) FROM server_profile WHERE 
server_profile.server=server.id) AS profile_name,

Review Comment:
   I'm ok either way.



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to