Extend a Schema

Avatar

Avatar
Validate 1
Level 2
davidm1708369
Level 2

Likes

9 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Shape 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
davidm1708369
Level 2

Likes

9 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Shape 1
Boost 5
Boost 3
Boost 1
View profile
davidm1708369
Level 2

29-06-2021

How can I add an enumeration to the existing state field in the Delivery table. 

In a similar way how can I change the length of an existing field in the recipient(profile) table.  E.G. change length of first name from 30 to 50 characters? 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Shape 1
Level 4
CedricRey
Level 4

Likes

36 likes

Total Posts

78 posts

Correct reply

19 solutions
Top badges earned
Shape 1
Boost 25
Applaud 5
Affirm 5
Give Back 3
View profile

Avatar
Shape 1
Level 4
CedricRey
Level 4

Likes

36 likes

Total Posts

78 posts

Correct reply

19 solutions
Top badges earned
Shape 1
Boost 25
Applaud 5
Affirm 5
Give Back 3
View profile
CedricRey
Level 4

30-06-2021

Hello @davidm1708369 

You can use the schema extension, this is exacly what it does.

You have to create a new schema (usually, we use the same name, and a custom namespace, ex: nms:recipient => cus:recipient), with the specific attribute "extendedSchema" on the main "srcSchema" element. If you use the schema creation Wizard, you'll see the "Schema Extension" option that guide you for the creation.

<srcSchema entitySchema="xtk:srcSchema"
           extendedSchema="nms:recipient" name="recipient"
           namespace="cus" xtkschema="xtk:srcSchema">

  <enumeration basetype="byte" name="newEnum">
    <value label="Value 0" name="value0" value="0"/>
    <value label="Value 1" name="value1" value="1"/>
  </enumeration>

<element name="recipient">
<!-- New element/attribute creation-->
<attribute name="myNewAttribute" enum="newEnum" type="byte"/>

<!--Override existing attribute spec by targeting its name-->
<attribute length="50" name="firstName"/>
</element>

</srcSchema>

 That way you can also add values into an existing enumeration.

 

Cedric

Answers (0)