diff options
| author | Grant Limberg <[email protected]> | 2021-08-20 10:30:37 -0700 |
|---|---|---|
| committer | Grant Limberg <[email protected]> | 2021-08-20 10:30:37 -0700 |
| commit | 3ec23f92ec7a860d1fcd3754f5090fe64c571b85 (patch) | |
| tree | d4d471d515070df840364f1d3ceeeb1e7ad87032 /controller/PostgreSQL.cpp | |
| parent | 6baac1b4e0ffa0c977f9bdc394edae392e19afb4 (diff) | |
helps to add part of the query
Diffstat (limited to 'controller/PostgreSQL.cpp')
| -rw-r--r-- | controller/PostgreSQL.cpp | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/controller/PostgreSQL.cpp b/controller/PostgreSQL.cpp index 46257d36..6d2e78a8 100644 --- a/controller/PostgreSQL.cpp +++ b/controller/PostgreSQL.cpp @@ -640,7 +640,8 @@ void PostgreSQL::initializeMembers() " INNER JOIN ztc_network n1 " " ON n.id = e.network_id " " WHERE e.network_id = m.network_id AND e.member_id = m.id AND n.sso_enabled = TRUE AND e.authentication_expiry_time IS NOT NULL " - " ORDER BY e.authentication_expiry_time DESC LIMIT 1) AS authentication_expiry_time " + " ORDER BY e.authentication_expiry_time DESC LIMIT 1) AS authentication_expiry_time, " + " ARRAY(SELECT DISTINCT address FROM ztc_member_ip_assignment WHERE member_id = m.id AND network_id = m.network_id) AS assigned_addresses " "FROM ztc_member m " "INNER JOIN ztc_network n " " ON n.id = m.network_id " |