From c75080fd3a563891256751effe552e7721cb906e Mon Sep 17 00:00:00 2001 From: Matthew Lemon Date: Thu, 12 Dec 2024 13:30:36 +0000 Subject: Tweaks a select func --- tjp.sh | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/tjp.sh b/tjp.sh index 88b0595..8b6eaa7 100755 --- a/tjp.sh +++ b/tjp.sh @@ -39,10 +39,14 @@ list_personal_entries() { } # Function to select all MOD entries +# list_MOD_entries() { +# psql -h "$HOST" -U "$USER" -d "$DB" -c "\x" -c "SELECT * FROM journal_entries WHERE type = 1;" +# } list_MOD_entries() { - psql -h "$HOST" -U "$USER" -d "$DB" -c "\x" -c "SELECT * FROM journal_entries WHERE type = 1;" + psql -h "$HOST" -U "$USER" -d "$DB" -c "\x" -c "SELECT id, date_added, entry, comment, meeting_id FROM journal_entries WHERE type = 1;" } + # Function to list all MOD contacts list_MOD_contacts() { psql -h "$HOST" -U "$USER" -d "$DB_CONTACTS" -c "SELECT id, first_name, last_name, email, phone, contact_comments FROM contacts WHERE contact_type = 3;" -- cgit v1.2.3