WRD

WRD offers an 'entity, attribute, value' database with support for relations between entities and lifetimes for the entities.

WRD offers specialized types for storing personal, name and contact information, but a schema can be used to store any type of data.

WRD is split into separate schemas which all have their own structure and metadata.

• WRD relation types
• WRD Schema setup
• Address verification providers
• WRD API 2017

Main WRD Api

• OBJECT FUNCTION CreateWRDSchema(STRING tag, RECORD metadata)
  

  Creates a new WRD schema

• RECORD FUNCTION DescribeWRDAttribute(INTEGER attributeid)
  

  Give a quick description of a WRD attribute id

• RECORD FUNCTION DescribeWRDEntity(INTEGER entityid)
  

  Give a quick description of a WRD entity

• STRING FUNCTION GetCachedWRDFileURL(STRING baseurl, INTEGER64 fileid)
  

  Get a link to a file in WRD

• STRING FUNCTION GetCachedWRDImageURL(STRING baseurl, INTEGER64 imageid, RECORD scalemethod)
  

  Get a link to a (resized) image in WRD

• RECORD FUNCTION GetCloneableEntityFields(RECORD inrec)
  

  Delete fields that are generally removed when cloning or duplicating an entity

• VARIANT FUNCTION GetWRDSchemaSetting(INTEGER wrdschemaid, STRING keyname, RECORD options)
  

  Read a WRD schema setting

• STRING FUNCTION GetWRDSequenceNext(INTEGER wrdschemaid, STRING statekey, RECORD options)
  

  Get the next sequence number

• BOOLEAN FUNCTION IsValidWRDGuid(STRING guid)
  

  Does the GUID conform to WRD GUID formatting

• RECORD ARRAY FUNCTION ListWRDSchemas(RECORD options)
  

  Get a list of WRD schemas a user may schema-manage

• OBJECT FUNCTION OpenWRDSchema(STRING findname)
  

  Retrieves a WRD Schema based on it's name.

• OBJECT FUNCTION OpenWRDSchemaById(INTEGER schemaid)
  

  Retrieves a WRD Schema based on it's unique ID.

• MACRO RemoveWRDSchemaSetting(INTEGER wrdschemaid, STRING keyname)
  

  Removes a WRD schema setting

• MACRO SetWRDSchemaSetting(INTEGER wrdschemaid, STRING keyname, VARIANT value)
  

  Sets a WRD schema setting

• MACRO UpdateWRDSequenceParameters(INTEGER wrdschemaid, STRING statekey, RECORD options)
  

  Update parameters for calculation of the next sequence number

• RECORD FUNCTION WrapImageField(STRING field, RECORD method)
  

  Get an image field and immediately resize it

• OBJECTTYPE WRDEntity2017
  

  WRD entity

• OBJECTTYPE WRDSchema2017
  

  WRD schema object

• OBJECTTYPE WRDType2017
  

  WRD Type

Addresses and countries

• RECORD FUNCTION FixupAddress(RECORD inaddress)
  

  Normalize a WRD address record

• STRING FUNCTION FormatAddress(RECORD addressdata, RECORD options)
  

  Format a WRD address

• RECORD FUNCTION GetAddressField(STRING tag, RECORD options)
  

  Describe an address field, generalized for any country

• RECORD FUNCTION GetAddressFormat(STRING countrycode, RECORD options)
  

  Describe the address format for a country

• OBJECT FUNCTION GetAddressLookupAPI(OBJECT applytester, STRING country)
  

  Get an address validator based on siteprofile configuration

• RECORD ARRAY FUNCTION GetAddressValidationServices()
  

  Get a list of supported validation services

• OBJECT FUNCTION GetWRDAddressLookupAPI(OBJECT wrdschema, STRING country, RECORD options)
  

  Get an address validator as configured for a WRD schema

• STRING FUNCTION JoinHousenumber(STRING nr, STRING detail)
  

  Recombines nr and detail into a single housenumber

• MACRO SetupWRDAddressVerification(OBJECT wrdschema, RECORD settings)
  

  Configure address validation for a WRD schema

• RECORD FUNCTION SplitHousenumber(STRING indata)
  

  Split the 'detail' or 'suffix' from a housenumber

• OBJECTTYPE WRDAddressVerificationBase
  

  Base for addres verification providers

• OBJECTTYPE WRDNLAddressVerificationBase
  

  Base for dutch addres verification providers

WRD dialogs and Tollium integration

• OBJECTTYPE PSPSettingsExtensionBase
  

  Base tabsextension to derive a PSP settings component from

• MACRO RunWRDAttributesDialog(OBJECT parentform, OBJECT wrdtype, RECORD options)
  

  Make a WRD manage attributes dialog

• MACRO RunWRDAuditLogDialog(OBJECT parentscreen, RECORD options)
• MACRO RunWRDAuthenticationSettings(OBJECT owner, RECORD options)
  

  Configure authentication and login settings

• INTEGER FUNCTION RunWRDEntityEditDialog(OBJECT owner, OBJECT wrdtype, INTEGER entityid, RECORD options)
  

  Run an entity add/edit screen

• INTEGER FUNCTION RunWRDEntitySelectDialog(OBJECT owner, OBJECT wrdtype, INTEGER entityid, RECORD options)
  

  Run an entity selection screen

• MACRO RunWRDHistoryDialog(OBJECT owner, OBJECT entity, RECORD options)
  

  Shows a dialog with the changes for a specific entity

• MACRO RunWRDPendingPaymentsDialog(OBJECT owner, RECORD options)
• OBJECTTYPE WRDEntityEditScreenBase
  

  Base screen to implement entityedit screens with

Import/export of WRD Schemas and metadata management

• BLOB FUNCTION CreateWRDSchemaDefinitionFile(OBJECT wrdschema)
• OBJECT FUNCTION CreateWRDSchemaFromImport(BLOB importarchive, RECORD options)
• OBJECT FUNCTION ExportWRDSchemaDefinition(OBJECT wrdschema, OBJECT doc)
  

  Get a XML export of this schema

• RECORD ARRAY FUNCTION MakeGuidToWRDIdMapping(INTEGER schemaid, STRING ARRAY inguids)
• OBJECT FUNCTION MakeWRDDataImporter(OBJECT wrdtype)
• RECORD ARRAY FUNCTION MakeWRDIdToGuidMapping(INTEGER ARRAY inids)
• OBJECT FUNCTION MakeWRDSchemaExporter(OBJECT wrdschema)

Process and format names

• STRING FUNCTION FormatWRDNameField(STRING field, RECORD data, RECORD options)
  

  Generate a salutation, as specified by WRD

• RECORD FUNCTION SplitWRDName(STRING inname)
  

  Split a full name into wrd name parts