Documentation Center

Configuring the SQL Identifier Hierarchy

In Identifier Hierarchy, specify the hierarchy that will appear in the WorldServer Explorer. At the top level is the table, then the identifier column or columns:
  • If there is more than one identifier column, you can change the order of the columns as needed by clicking Move up (for example, if ID and language are the identifier columns, you may want to place language higher than ID in the Explorer hierarchy).
  • Click Join to join the columns as a hierarchy level (for example, if you join language and locale identifiers, then English+England, English+US, and so on will be hierarchy levels).
  • Choose one of the identifiers to be the asset level. The asset-level identifier is the identifier that will become an asset in Explorer; it is the lowest hierarchical level visible in Explorer. Content that is hierarchically lower than the asset-level is contained within the asset-level.

    For example, you may want to designate the language as the asset level, which means that all of the content for the table that is in a particular language will appear as one asset in Explorer. This saves you from having a very large number of assets generated by individual strings.