Skip to main content
Mitratech Success Center

Dynamic Filters

Within Suite, default filters are listed on the Filters tab for almost every module. The default filters for each module are those most commonly used. These filters can be edited to meet your company’s needs or new filters may be created.

Dynamic SQL macros created by Mitratech that can be used in the dynamic filters include the following:

SQL Macro

Product

Description

$TODAY$

All

Substitutes today’s date.

$MRU$

All

Substitutes the most recently used record(s).

$APPROVED$

eCounsel

Substitutes all invoices that have been approved.

$MYAPPROVALS$

eCounsel

Substitutes all invoices in the logged in user’s queue to be approved.

$MPLAYERS$

eCounsel

Substitutes all people/entities that have been assigned to a matter based on the insurance policy being viewed. This macros should only be used for the Insurance tab in the Matters module.

$ASSIGNEDPLAYER$

eCounsel

Substitutes all people/entities that have been assigned to a matter.

$ME$

All

Substitutes the events (tasks/appointments) to which the logged in user is an invitee.

$CURRENTUSERID$

All

Substitutes the user identifier for the logged in user.

$CURRENTUSERLOGIN$

All

Substitutes the login name for the logged in user (does not add quotation marks around login name).

$CURRENTUSERENTITYID$

All

Substitutes the person identifier for the logged in user (substitutes −1 if the user is not associated with a person record).

 

  • Was this article helpful?