xCacheGetGlobalTable

Description

Returns the xCache Table value for the given key for the Global xCache.

Signature

xCacheGetGlobalTable( 'key', 'tablename', 'fieldname', 'filter', 'defaultvalue', 'rownumber', 'sortorder', 'datereference' )

Example 1

xCacheGetGlobalTable(
  'Fema_BaseRates',
  'Leveed',
  'InlandFloodContents',
  'Region = "SC" and Segment = "Segment 1" and SingleFamilyHome = "Yes"',
  '0',
  '0'
)

Returns 1.256

Example 2

xCacheGetGlobalTable(
  'Fema_BaseRates', 
  'Non-Leveed', 
  'InlandFloodContents', 
  StringFormat(
    'Region LIKE "*{0}*" and Segment = "{1}" and SingleFamilyHome = "{2}"',
    GetVar('Region'),
    GetVar('Segment'),
    GetVar('SingleFamilyHome')
  ),
  '0' 
)

Returns 1.554