====== <#Tlookupvalues> ====== 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. ===== How it looks like? ===== 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 [[en:public:developer:template_system:tags:string:TStringList]] indexed by their ID and language. ===== Properties ===== ^ Name ^ Type ^ Description ^ | Items | [[en:public:developer:template_system:tags:miscellaneous:TLookupValue]] | An array containing all [[en:public:developer:template_system:tags:miscellaneous:TLookupValue]] object. You can access one specific lookupvalue by it's index, ex: <#LookupValues[<#Const_LookupListId_ResourceString>] | | Count | integer | the count of [[en:public:developer:template_system:tags:miscellaneous:TLookupValue]] in the items property | ===== Constructors ===== ^ Name ^ Type ^ Description ^ | [[en:public:developer:template_system:tags:miscellaneous:tlookupvalues:create]] | String | construct a TLookupValues object | You can also create a TLookupValues object (That will be named **LookupValues**) via a call to <#[[en:public:developer:template_system:tags:miscellaneous:tlookupvalues:create|lookupvalues]][...]> ===== Functions ===== none ===== Exemples ===== 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 [[en:public:developer:template_system:tags:string: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 [[en:public:developer:template_system:tags:string: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 ===== List of IDs of lookup lists ===== 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;