Do you have a list of Goldmine Dashboard Macros

Posted on 2011-05-03
Last Modified: 2013-11-24
I am looking for a comprehensive list of Goldmine Dashboard Macros for GM 9.01.  I am looking for both formats like {{contact_db}} and the <<~CURRENT_USER>>

I sure would appreciate a list and a description of how it is used.
Question by:mfleet100
    LVL 11

    Expert Comment

    Sorry, there is no such list.

    Author Comment

    It answered the question adequately - but unfortunately it did not help my problem - but not the responders shortcoming - I was just asking a question which apparently has no answer
    LVL 12

    Expert Comment


    Sorry but there is a list, maybe not very comprehensive but certainly does not give examples on how to use

    This was taken from the help

     Dashboard Macros

    Below is a list of supported Macros that can be used when creating SQL query statements for a New Data Source.
     Date Macros
    This group can be used only with date/datetime fields (OnDate, CREATED, etc.)
    l <<~CURRENT_YEAR>> current year
    l <<~CURRENT_MONTH>> current month
    l <<~CURRENT_QUARTER>> current quarter
    l <<~CURRENT_DAY>> current day

    This group can be used only with date/datetime fields (OnDate,MODIFIED, etc.)
    l <<~LAST_YEAR>> last (previous) year
    l <<~LAST_MONTH>> last month
    l <<~LAST_QUARTER>> last quarter
    l <<~LAST_DAY>> last day
    l <<~CURRENT_DATE>> current date
    l <<~FY_END>> when fiscal year ends (month)

     User Macros
    l <<~CURRENT_USER>> logged/current user
    l <<~IS_CURRENT_USER_MASTER>> replaced by
    l <<~USER_GROUP_MEMBERS>> user group’s name, replaced by group’s members list (“, ‘USER1’, ‘USER2’)

     Contact Macros
    l <<~CONTACT_FILTER>> contact filter
    l <<~CONTACT_GROUP>> contact group

     Runtime Filters
    l <<__INACTIVE_STATE__>> ignore runtime filter (by default value will be placed)
    l <<__IGNORE_STATE__>> ignore runtime filter and its default value
    l <<VALUE>> shows place where value from part will be replaced
    l <<VALUES>> the same as <<VALUE>>, but several values can be replaced (our grid supports multi selection)

    Author Comment

    Greetings - this is the standard list of values that Frontrange produces in their very limited documentation.  Which I already have.  What I am really looking for are the ones that are not in the documentation for use in the Data Source queries.

    For instance {{contact_db}} - is not in the list above - but can be used to identify a specific database in a multi database installation.  There are a number of others like this.  I can see them when I look at the data source queries for the dashboards that are provided by Frontrange - but there is no place I can find a comprehensive list or even an explanation of what they are.
    LVL 12

    Accepted Solution

    ok, so i done some digging in the EXE and found all this


    Open in new window

    i have not produced or looked at any dashboards so not sure here but i suspect that {{}} will also be a field name in many cases

    Hope it helps a little.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
    These days socially coordinated efforts have turned into a critical requirement for enterprises.
    Learn how to automatically add page numbers in your next InDesign project. This can be very helpful in multi-page books and magazines that you are designing. Make sure your Pages window visible.:  In the document you wish to add page numbers to. Act…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now