Skip to Content

Shared() mvSQL runtime function in Jitterbit App Builder

Summary

The shared() function retrieves criteria values passed to a data object. These values can be provided when linking to a new page or when binding panels together within the same page.

Syntax

SHARED(<name> [, <datatype> ])

Parameters

name

A string representing the name of the shared criteria or panel binding column.

datatype

An optional string specifying the data type. Default is String. Supported types include:

  • String (default)

  • Numeric

  • UUID

  • Boolean

  • DateTime

Returns

The value as the specified datatype. Returns NULL if the requested name is unavailable.

Remarks

This function bridges data between different application layers without requiring complex joins. While it is commonly used in page links, it is also supported through Shared Panel Binding. More details on defining these variables can be found on the Shared criteria page.

Examples

The following example demonstrates using shared() in a SELECT and WHERE clause to filter results based on an active session or parent panel value:

SELECT CustomerId, shared('ActiveEmployeeId') as ActiveEmployeeId
FROM Customer
WHERE CustomerRegionId <> shared('LastRegion', 'UUID')

In this case, if ActiveEmployeeId is '5' and LastRegion is missing, the runtime evaluates to:

SELECT CustomerId, '5' as ActiveEmployeeId
FROM Customer
WHERE CustomerRegionId <> '00000000-0000-0000-0000-000000000000'