• State Not Answered
  • +1 person also asked this people also asked this
  • Replies 10 replies
  • Subscribers 8 subscribers
  • Views 6642 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

I created a view that includes a calculated field which came in with a type '

judym598
Certified Senior Developer
I created a view that includes a calculated field which came in with a type 'bigint(21)' that I can't seem to change. I'm trying to create a data type for this view but I can't seem to get it mapped correctly. I tried to make this field a 'bigint' in the xsd file using the jpa notation. I can create the data type but when I add it to the data store and try verifying the mapping, I get this error:

A type mapping annotation is invalid: identifier mapping has wrong number of columns: IPSActiveUsersVDT2506 type: integer (MappingException) (APNX-2-4055-000)

Here's my xsd file (note: I tried deleting the first jpa notation associated with the 'id' and also tried to remove the primary key on 'nbrActiveTeams' in the data type since that's not a primary key but so far nothing's helped.

<xsd:schema xmlns:xsd="www.w3.org/.../XMLSchema" xmlns:tns="urn:com:appian:types" targetNamespace="urn:com:appian:types">
<xsd:complexType name="IPS_ActiveUser...

OriginalPostID-168979

OriginalPostID-168979

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer
    ...s_v">
    <xsd:annotation>
    <xsd:documentation><![CDATA[Data Type associated with the ipsactiveusers_v (View)]]></xsd:documentation>
    <xsd:appinfo source ="appian.jpa">
                        @Table(name="ipsactiveusers_v")
               </xsd:appinfo>          
              </xsd:annotation>
               <xsd:sequence>
    <xsd:element name="id" nillable="true" type="xsd:int">
    <xsd:annotation>
    <xsd:appinfo source="appian.jpa">
                         @Id
                         @Column(columnDefinition="bigint NOT NULL")
                         </xsd:appinfo>
    </xsd:annotation>
    </xsd:element>
    <xsd:element name="lastName" nillable="true" type="xsd:string" />
    <xsd:element name="firstName" nillable="true" type="xsd:string" />
    <xsd:element name="userEmail" nillable="true" type="xsd:string" />
    <xsd:element name="appianUsername" nillable="true" type="xsd:string" />
               <xsd:element name="nbrActiveTeams" nillable="true" type="xsd:int">
    <xsd:annotation>
    <xsd:appinfo source="appian.jpa">
                         @Id
                         @Column(col...
Reply
  • 0
    Certified Senior Developer
    ...s_v">
    <xsd:annotation>
    <xsd:documentation><![CDATA[Data Type associated with the ipsactiveusers_v (View)]]></xsd:documentation>
    <xsd:appinfo source ="appian.jpa">
                        @Table(name="ipsactiveusers_v")
               </xsd:appinfo>          
              </xsd:annotation>
               <xsd:sequence>
    <xsd:element name="id" nillable="true" type="xsd:int">
    <xsd:annotation>
    <xsd:appinfo source="appian.jpa">
                         @Id
                         @Column(columnDefinition="bigint NOT NULL")
                         </xsd:appinfo>
    </xsd:annotation>
    </xsd:element>
    <xsd:element name="lastName" nillable="true" type="xsd:string" />
    <xsd:element name="firstName" nillable="true" type="xsd:string" />
    <xsd:element name="userEmail" nillable="true" type="xsd:string" />
    <xsd:element name="appianUsername" nillable="true" type="xsd:string" />
               <xsd:element name="nbrActiveTeams" nillable="true" type="xsd:int">
    <xsd:annotation>
    <xsd:appinfo source="appian.jpa">
                         @Id
                         @Column(col...
Children
No Data

© 2024 Appian. All rights reserved.