Tweaks a select func

1 files changed, 5 insertions, 1 deletions

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;"