Lookup values lists are the lists with all the actual string values on different languages using on Arkadia. For example, these lists contain all language versions of property categories, currency codes, types of invoices, also the different resource strings like captions, labels, button titles and other.

Lookup lists provide the good way to internationalize the web-site. They contain also the most required lists for the work of web-site like geographical places, property categories etc.

Common lookup values list is connected with some table in database. For example, lookup values list with resource strings is connected with the table “RESOURCE_STRING” and uses all the data from the rows of this table. Physically lookup list looks like array of TStringList indexed by their ID and language.

You can also create a TLookupValues object (That will be named LookupValues) via a call to <#lookupvalues[…]>

none

The function <#lookupvalues> is intended to return any lookup list and output its data to the page. The syntax to use this function is typical array syntax:

<#lookupvalues[<#const_lookuplists_resourcestrings>][usa]>

It references to the TStringList with all the english values of lookup list with id defined by the const “const_lookuplists_resourcestring” (you can find complete list of the IDs below).

Then you can use the content of this list by the same way as you use content of plain TStringList. Few common examples:

1. I want to print count of the elements in the list

  <#lookupvalues[<#const_lookuplists_resourcestrings>][usa].count>

2. I need to scroll all the list and print each value

  <#for var="i" from="0" to="<#lookupvalues[<#const_lookuplists_title>][usa].count> - 1">
    <#lookupvalues[<#const_lookuplists_title>][usa].valuefromindex[<#i>]>
  <#endfor>

This will output the content of lookup list with all the civilities.

  Mr
  Ms
  Mrs

const_LookupListId_BooleanYesNo = 76;
const_LookupListId_BrokerListingImportType = 74;
const_LookupListId_BrokerSubscriptionPackageType = 78;
const_LookupListId_BrokerSubscriptionStatus = 72;
const_LookupListId_BrokerSubscriptionDurationType = 8;
const_LookupListId_ContactClassification = 47;
const_LookupListId_ContactTitle = 7;
const_LookupListId_ContactType = 61;
const_LookupListId_Continent = 30;
const_LookupListId_ContinentUrl = 79;
const_LookupListId_Country = 15;
const_LookupListId_CountryByContinent = 60;
const_LookupListId_CreditcardType = 2;
const_LookupListId_CurrencyCode = 34;
const_LookupListId_CurrencyCodeSymbol = 40;
const_LookupListId_EuroToUnitRate = 80;
const_LookupListId_InvoiceStatus = 56;
const_LookupListId_Language = 58;
const_LookupListId_LeadType = 89;
const_LookupListId_ListingContractRenewalType = 27;
const_LookupListId_ListingContractType = 28;
const_LookupListId_LookupList = 97;
const_LookupListId_MeasurementSystem = 65;
const_LookupListId_MeasurementSystemLength = 46;
const_LookupListId_MeasurementSystemSurface = 43;
const_LookupListId_Month = 69;
const_LookupListId_Nationality = 5;
const_LookupListId_PaymentMethod = 71;
const_LookupListId_ProductType = 59;
const_LookupListId_PropertyCategory = 88;
const_LookupListId_PropertyClassification = 52;
const_LookupListId_PropertyCondition = 20;
const_LookupListId_PropertyFeatureType = 24;
const_LookupListId_PropertyHeatingCombustible = 18;
const_LookupListId_PropertyHeatingType = 17;
const_LookupListId_PropertyListingType = 55;
const_LookupListId_PropertyOrderby = 23;
const_LookupListId_PropertyOrderbyCommercialForRent = 85;
const_LookupListId_PropertyOrderbyCommercialForSale = 84;
const_LookupListId_PropertyOrderbyEquityRelease = 95;
const_LookupListId_PropertyOrderbyNewConstruction = 94;
const_LookupListId_PropertyOrderbyResidentialForRent = 83;
const_LookupListId_PropertyOrderbyResidentialForSale = 82;
const_LookupListId_PropertyOrderbyVacationRentals = 86;
const_LookupListId_PropertyRentPeriodDurationType = 29;
const_LookupListId_PropertyrequestClassification = 50;
const_LookupListId_PropertyrequestStatus = 51;
const_LookupListId_PropertyStatus = 25;
const_LookupListId_PropertyStatusActiveInactive = 87;
const_LookupListId_PropertySubType = 13;
const_LookupListId_PropertySubtypeApartment = 36;
const_LookupListId_PropertySubtypeBuilding = 38;
const_LookupListId_PropertySubtypeBusinessOpportunity = 96;
const_LookupListId_PropertySubtypeHouse = 37;
const_LookupListId_PropertySubtypeMisc = 22;
const_LookupListId_PropertySubtypeOffice = 41;
const_LookupListId_PropertySubtypeParkingSpace = 39;
const_LookupListId_PropertySubtypeWarehouse = 42;
const_LookupListId_PropertyTransactionFeeRateCalc = 54;
const_LookupListId_PropertyTransactionFeeRateCalcEquityRelease = 93;
const_LookupListId_PropertyTransactionFeeRateCalcForRent = 67;
const_LookupListId_PropertyTransactionFeeRateCalcForSale = 66;
const_LookupListId_PropertyTransactionFeeRateCalcNewConstruction = 92;
const_LookupListId_PropertyTransactionFeeRateCalcVacationRentals = 68;
const_LookupListId_PropertyTransactionType = 26;
const_LookupListId_PropertyType = 14;
const_LookupListId_PropertyTypeCommercialForRent = 45;
const_LookupListId_PropertyTypeCommercialForSale = 33;
const_LookupListId_PropertyTypeEquityRelease = 91;
const_LookupListId_PropertyTypeForRent = 4;
const_LookupListId_PropertyTypeForSale = 9;
const_LookupListId_PropertyTypeNewConstruction = 90;
const_LookupListId_PropertyTypeResidentialForRent = 44;
const_LookupListId_PropertyTypeResidentialForSale = 32;
const_LookupListId_PropertyTypeVacationRentals = 31;
const_LookupListId_propertyCommentType = 1;
const_LookupListId_UnitToEuroRate = 81;
const_LookupListId_YearMinusOnePlusTree = 70;
const_LookupListId_GmapMapType = 3;
const_LookupListId_GmapApiReturncode = 6;
const_LookupListId_ResourceString = 10;