Object Macros

The macros described in this section extract attribute data from the binary data used to store custom attributes. These macros operate using the same parameters, but return data from different tables.

Each of the macros in the table below use these parameters:

Temporary table name
WHERE clause applied to the table containing the binary blob
List of system attribute key names to add as columns in the temporary table

Anytime a system attribute key name is used as a column in the temporary table certain rules have to be applied. The first rule is that the ‘.’ used as the dimension delimiter is replaced by the ‘@’ symbol. The second rule is that ‘-‘ are replaced with ‘_’.

Anytime the # StripHTML attribute is used at the beginning of the macro, rich text formatting of the query results will be enabled (# StripHTML=false) or disabled (# StripHTML=true). Rich text formatting is enabled by default.

This is done so that the system attribute name will be a compatible database column name.

Macro Database	Table Where Data is Extracted
PES_MACRO_AGILE_WORK_ITEM	PES_AgileWI
PES_MACRO_CONFIGURABLE_LOG	PES_ConfigurableLog
PES_MACRO_DEPENDENCY	PES_Dependency
PES_MACRO_INVESTMENT	PES_Object
PES_MACRO_PROJECT_ASSIGNMENT	PES_ProjectAssignment
PES_MACRO_PROJECT_NONLABOR	PES_ProjNonLaborAsgn
PES_MACRO_PROJECT_TASK	PES_ProjectTask
PES_MACRO_RESOURCE	PES_Resource
PES_MACRO_RESOURCE_ALLOCATION	PES_ResourceAllocation
PES_MACRO_TIMEPHASE_ATTRIBUTE_DETAIL	PES_TimephaseAttributeDetails
PES_MACRO_TIMESHEET_DETAIL_APPROVED	PES_TimesheetDetailsApproved
PES_MACRO_TIMESHEET_DETAIL_PENDING	PES_TimesheetDetailsPending
PES_MACRO_WORK_ITEM_ASSIGNMENT	PES_WorkItemAssignment
PES_MACRO_WORK_ITEM_TASK	PES_WorkItemTask

The following example shows a select statement that returns the Budget and plan start milestones for all projects in the system.

SELECT * FROM PES_MACRO_INVESTMENT(tmp, cls_UID = 6, Budget, StartMS@Plan)

Each of the macros in the table above can be called using a similarly structured SQL SELECT statement. The macros in the following sections are more complicated and are treated separately.

The following example shows using the StripHTML attribute to disable rich text formatting in a report's output:.

# StripHTML=true
SELECT * FROM PES_MACRO_INVESTMENT(tmp, cls_UID = 6, Budget, StartMS@Plan)

For more information, see the following topics: