The Miscellaneous Folder (Relational Model)

Figure 1 shows the Miscellaneous folder.

Figure 1. Miscellaneous folder (Report Design Language locale)
Hierarchy of the Miscellaneous folder

Table 1 lists the items in the Miscellaneous folder.

Table 1. Miscellaneous Folder
Folder/Query Subject Description

CURRENCIES

Contains query subjects related to system currencies.

REPORTING_PERIODS

Contains query subjects related to system reporting periods.

ALL_DOCUMENTATION

Returns a list of all objects in the system and the count/type of documentation that is attached to each object.

The following prompts are defined for this query subject:

  • Entity ID
  • Set ID (always set = 1)

I18N_INT_OP_CALENDAR

Contains the definition of all dates in the system translated to other date values. By creating a relationship with a date field, you can filter the field by the date parts in this query subject.

CHECKED_OUT_OBJECTS

Used to find all objects that are checked out.

The following prompt is defined for this query subject:

  • Sort Order

Sort order is an optional prompt that accepts one of the following values:

[NAME] = 3 
[FULL_PATH] = 4 
[CONTENT_TYPE] = 5 
[DESCRIPTION]= 8 
[CHECKED_OUT_BY] = 9
[CHECKED_OUT_DATE] = 10
[PARENT_NAME] = 11 
[PARENT_FULL_PATH] = 12 
[PARENT_CONTENT_TYPE] = 13
Note: If no sort value is selected, the value defaults to 3 (the NAME query item).

LOCALIZED_CONTENT_TYPES

Returns the list of all object types defined in the system.

LOCALIZED_PROPERTY_DEFINITIONS

Returns the definition of all properties defined in the system.

NON_ASSOCIATED_OBJECTS

Returns all orphaned objects in your system.

The following prompts are defined for this query subject:

  • Sort Order
  • Set ID (always set = 1)

Sort order is an optional prompt that accepts one of the following values:

[NAME]= 2
[FULL_PATH] = 3
[CONTENT_TYPE] = 4
[DESCRIPTION] = 7
[CREATOR] = 8
[CREATION_DATE] = 9
Tip: If no sort value is selected, the value defaults to 2 (the NAME query item).

USERS_AND_PROFILES

Contains the relationship of users to their login profile.

WF_PROCESS_LOG_VIEW

Contains the event log history for each workflow process instance. It includes the following information: process events that occurred, for example, start event, stage changes, owner, assignee, and subscriber changes, success and failure messages, and so on.

WF_PROCESS_REPORT_INFO

Contains information about every workflow process instance that is in the system. It includes the following information: meta information, resource information, dates, stages, owners, assignees, subscribers, comments, and so on.

ADVANCED

Contains advanced query subjects that have been created to create complex reports.