ItemExists (PQL)

Checks if the member coordinates or a data point (cell) contains an item. 

  • Returned Output: Boolean
  • Library: PQL \ Action \ Jump
  • Version: 2018.00.000
  • Compatibility: Any content (regardless of data source) in the relevant parts of the application

Syntax

ItemExists( <Text> )

* Click on the function's arguments above for more details on the input values.

Comments
  • The function will check if the coordinates of the cell that triggered the action contain a member that has one of the following:
    • the supplied caption name as text
    • the supplied unique member name as text
    • the supplied unique hierarchy name as text

Examples

The examples below use the following example grid and action.

This example returns true when an action is triggered from the highlighted cell:

ItemExists("Acme")

This example returns true when an action is triggered from the highlighted cell:

ItemExists("Accessories")

This example returns false when an action is triggered from the highlighted cell:

ItemExists("Bikes")

This example returns true when an action is triggered from the highlighted cell:

ItemExists("[manufacturers].[manufacturer].[Acme]")

This example returns true when an action is triggered from the highlighted cell:

ItemExists("[manufacturers].[manufacturer]")