SQL Learning Center - GoldMine

Description:This query is for a dBase hosted GoldMine. It returns the field names organized by field screen.

SELECT
 f52.label AS ScreenView
,f51.label AS ScreenName
,f51.fldname AS Fieldname
,f51.fldpos
FROM fields5 f51
 JOIN fields5 f52
  ON f51.viewid = f52.viewid
WHERE
 SUBSTRING(fldname FROM 1 FOR 1) = 'U'
 AND f52.fcol IS NULL
 AND f52.label = 'Tech Support Screen'
GROUP BY
 f52.label
,f51.label
,f51.fldname
,f51.fldpos
ORDER BY
 f51.fldpos

DescriptionThis query is for dBase hosted GoldMine. It returns counts by user for deleted emails that need to be emptied from deleted folder.

SELECT
 mb.userid
,mb.folder
,count(*)
FROM
 mailbox mb
WHERE
 mb.folder not in
( 'X-GM-INBOX'
,'Sent'
,'Filed'
,'X-GM-DRAFTS'
,'X-GM-FOLDERS'
,'X-GM-GROUPS'
,'X-GM-HTMLTAB'
,'X-GM-ICALINFO'
,'X-GM-OUTBOX'
,'X-GM-PROP-HTMLTAB'
,'X-GM-RULES'
,'X-GM-TEMPLATES'
,'X-GM-SMIME-CA'
,'X-GM-SUBSENT'
,'X-GM-SUBFILED'
,'X-GM-TD-ITEMS'
,'X-GM-WEBIMPORT'
)
GROUP BY
 mb.userid
,mb.folder
ORDER BY
 mb.userid
,mb.folder

SELECT
 c1.contact
,concat(cs.contsupref,cs.address1) AS EmailAddress
,c1.accountno
FROM
 contact1 c1
JOIN contsupp cs
 ON c1.accountno=cs.accountno
WHERE
 cs.rectype = 'P'
 AND cs.contact = 'E-mail Address'
 AND cs.zip LIKE '_1__'