##OB_SECURITYKEYWORDVALUE_TABLE - Reporting Dashboards - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Reporting Dashboards

Platform
OnBase
Product
Reporting Dashboards
Release
Foundation 23.1
License

The ##OB_SECURITYKEYWORDVALUE_TABLE macro is used to return documents that have the specified Keyword Type applied to them, but also respects Security Keywords.

Note:

Dual-table Security Keywords are not supported.

The documents returned can be optionally limited to the specified Document Types.

Tip:

For normal Keyword Types, see also ##OB_KEYWORDVALUE_TABLE.

This macro returns a sub-select table expression for accessing the document handle and Keyword Type value.

Note:

Encrypted Keyword values are not displayed.

This macro accepts two comma-separated arguments in this format:

##OB_SECURITYKEYWORDVALUE_TABLE{(arg1,arg2)}
  • arg1 is the unique system ID for the Keyword Type to use to locate documents. This value is required.

  • arg2 is the unique system ID for the Document Type used to limit the documents returned. Multiple Document Types can be included in a comma-separated list (e.g., 101,102,103).

The expression returns a table of values and so must also include the table alias. In this example, the results are optionally limited to Document Types 101, 107, and 110, and the table alias is set to t0:

select * from ##OB_SECURITYKEYWORDVALUE_TABLE{(1,101,107,110)} t0

The table returned contains the following columns:

  • itemnum: The unique system ID of the document that contains the specified Keyword Type, also known as the document handle.

  • keytypenum: The unique system ID of the Keyword Type.

  • keyvalue: The Keyword Type value of the Keyword Type.

In the Insert Macro menu, this macro is listed as Security Keyword Value Table.