Creating query variables

  1. Navigate to Admin > Customize Space > Variables, click Create. Specify an expression that returns the mapped data.

    Example query for a multi-tenant environment, using a variable you created that returns the tenant ID: SELECT [MyMapping.FullyQualifiedName], [MyMapping.MappedName] FROM [ALL] WHERE MyMapping.TenantID=GetVariable('MyTenant'). Example query for user-based localization: SELECT [MyMapping.FullyQualifiedName], [MyMapping.MappedName] FROM [ALL] WHERE MyMapping.Locale=GetVariable('UserLocale$')

    Note: For multiple subject areas, when you want to provide different mapping for the same field in different custom subject areas, you can provide that information in a Subject Area column in the source and then add it to the WHERE clause.
  2. Click Validate.
  3. Click OK.