The ##OB_KEYWORDVALUE_TABLE macro is used to return documents that have the specified Keyword Type applied to them. The documents returned can be optionally limited to the specified Document Types.
For Security Keywords, see also ##OB_SECURITYKEYWORDVALUE_TABLE.
This macro returns a sub-select table expression for accessing the document handle and Keyword Type value.
Encrypted Keyword values are not displayed.
This macro accepts two comma-separated arguments in this format:
##OB_KEYWORDVALUE_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_KEYWORDVALUE_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 Keyword Value Table.