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
Note 1
The North52 formula that executes this function (via a user) needs to have the System Administrator role. Or the formula needs to have its 'Execute As' field set to 'System User (Administrator)'