Skip to Content

Shared() mvSQL runtime function in Jitterbit App Builder

Summary

When linking to a page, criteria can be made available to the target page's data objects. This function will then access these values in several locations.

Syntax

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

Parameters

name

A string representing the requested criteria's name.

datatype

Data type, string is default, optional. Supported datatypes:

  • String (default)
  • Numeric
  • UUID
  • Boolean

Returns

A value of datatype datatype, or NULL if name references an unavailable column.

Remarks

More information is available on the overall Shared criteria page, including how to define the shared criteria and where this function can be used.

Examples

Given:

  • The page receives a shared criteria ActiveEmployeeId=5.
  • The page does not receive a shared criteria with the name LastRegion.

This rule could be created:

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

Which would evalulate at runtime to:

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