Versions Compared

Old Version 15

changes.mady.by.user Nancy Cohn (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user Pamela Totas (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

You can customize the extract by using only several fields from the main Data Object without using any other child Data Objects (mashups), as shown below in Taxonomy mapping. 

There is an instance instant performance benefit in removing unnecessary fields from the taxonomy definition. The request is automatically optimized to remove unused columns and even whole tables from the query.

On this page

Table of Contents

Use Taxonomy Mapping Mode

After you select the main data object for your interface and click Create, you see the EDS Worksheet. You can use Taxonomy mapping mode there.

 In

 In Taxonomy mapping mode, the main Data Object you chose is at the left and the Taxonomy is at the right.

Taxonomy Mapping ModeImage Removed
Taxonomy Mapping ModeImage Added

Map a Field to the Taxonomy

To map a field from the main Data Object to the Taxonomy, use a drag-and-drop operation to drag a field from the main Data Object to a Taxonomy field. See the following figure. 

Image Removed
Drag a Field to the TaxonomyImage Added

Change the Name of Output Fields

You can change the Name of output fields by clicking the name you want to change and typing a new name.

Image Removed
Taxonomy - NameImage Added

Calculated Field Examples

It is possible to create calculated fields by using classic Message Center expression syntax. Here are some examples in the following table.

Expression

Meaning

|ENTITY_ID| + '_' + |ENTITY_NAME|

Concatenating entity id with entity name

iif( stringlength(|POST_DATE|) = 0, |EFFECTIVE_DATE|, |POST_DATE| )

Conditional assignment: if post date is empty, use effective date instead

convert( currenttime(), ''hh:mm:ss )

Current time in custom format

convert( today() - 1, 'mm/dd/yyyy' )

Yesterday's date in custom format