The mailing list for listmasters using Sympa

["Malcolm Waltz" <address@concealed>]

Something like:

SELECT user_admin,comment_admin,list_admin,date_admin FROM admin_table


I use the following query to generate a mailing list of list owners:
SELECT DISTINCT ON (user_admin) user_admin FROM admin_table WHERE
role_admin='owner'


Malcolm Waltz
Unix Systems Administrator III
Office of Information Technology
University of the Pacific

-----Original Message-----
From: address@concealed [mailto:address@concealed] On
Behalf Of Omen Wild
Sent: Thursday, September 23, 2010 11:59 AM
To: address@concealed
Subject: [sympa-users] Include user's name in SQL query inclusion?

I am looking for a way to include the user's name in a remote SQL
query.  To test I've been trying to pull data from the admin_table.

I tried the following combinations in SQL query:

SELECT CONCAT(user_admin, ' ', list_admin, ' ', date_admin) FROM
admin_table GROUP BY user_admin
SELECT CONCAT('"', user_admin, ' ', list_admin, ' ', date_admin, '"')
FROM admin_table GROUP BY user_admin
SELECT user_admin, list_admin, date_admin FROM admin_table GROUP BY
user_admin

With the first two the entire result get stuffed into the Email
column, so obviously incorrect.

With the last only the first column gets used, the Name column stays
empty.

Am I missing something simple?

Thanks,
   Omen

-- 
Omen Wild
Security Administrator
(530) 752-1700