Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Verified Answer
+1
person also asked this
people also asked this
Replies
16 replies
Subscribers
7 subscribers
Views
7477 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
I am building XSD where i need to map My -SQL ENUM data type . I tried like be
vineeta6579
over 10 years ago
I am building XSD where i need to map My -SQL ENUM data type . I tried like below but Appian doesn't recognize it as enum type
_______________________________________________
<xsd:element name="car">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Audi"/>
<xsd:enumeration value="Golf"/>
<xsd:enumeration value="BMW"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
____________________________________________________
Attached: XSD and table structure.....
OriginalPostID-113805
OriginalPostID-113805
Discussion posts and replies are publicly visible
0
vineeta6579
over 10 years ago
.
emp.xsd
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Aleksi White
Appian Employee
over 10 years ago
Did you use the @Enumerated annotation?
forum.appian.com/.../Defining_a_Custom_Data_Type
Under the section "Using Annotations in Your XSD"
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
vineeta6579
over 10 years ago
Yes I tried this also. but it shows annotation validation error while creating data store..
<xsd:element form="qualified" name="gender" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Enumerated(EnumType.STRING)
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Aleksi White
Appian Employee
over 10 years ago
What is the specific error you are getting?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
vineeta6579
over 10 years ago
Attached: Error screenshot
When i click on Verify it show error .
I think its because i am not providing enum constant (M,F) in xsd file.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
vineeta6579
over 10 years ago
Attached table sql.
employee.sql
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Aleksi White
Appian Employee
over 10 years ago
Try adding the constant you mention and see if that works
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
vineeta6579
over 10 years ago
I tried every possible combination but not working
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Aleksi White
Appian Employee
over 10 years ago
I was able to import and map this without issue in 7.5 (the enum facet was ignored). What version of Appian are you doing this in?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
vineeta6579
over 10 years ago
Yes. instead of taking it as enum its taking it as text. [See the attached screenshot]
In my case I have already existing db with gender as enum type and importing the above data type is creating new table instead of referring to the existing table..
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>