i'm trying to get the billNo of this invoice object
but when i try to retrive it i get null values if i use the index function if i don't use index function i get an error saying the error that i just wrote in the subject the only way for me to get this information is just getting all the values how could i get just one value ? bellow i'm gonna let you some examples of what i see.
Discussion posts and replies are publicly visible
xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:tns="urn:com:appian:types" targetNamespace="urn:com:appian:types"> <xsd:include schemaLocation="%7Burn%3Acom%3Aappian%3Atypes%7DBBO_PayStamp.xsd" /> <xsd:include schemaLocation="%7Burn%3Acom%3Aappian%3Atypes%7DBBO_PaymentType.xsd" /> <xsd:complexType name="BBO_Invoice"> <xsd:sequence> <xsd:element name="id" nillable="true" type="xsd:int"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Id @GeneratedValue</xsd:appinfo> </xsd:annotation> </xsd:element> <xsd:element name="solicitedDate" nillable="true" type="xsd:dateTime" /> <xsd:element name="solicitedBy" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(length=255)</xsd:appinfo> </xsd:annotation> </xsd:element> <xsd:element name="emitedDate" nillable="true" type="xsd:dateTime" /> <xsd:element name="emitedBy" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(length=255)</xsd:appinfo> </xsd:annotation> </xsd:element> <xsd:element name="billNo" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(length=255)</xsd:appinfo> </xsd:annotation> </xsd:element> <xsd:element name="payStamp" nillable="true" type="tns:BBO_PayStamp"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@OneToOne(cascade=CascadeType.ALL)</xsd:appinfo> </xsd:annotation> </xsd:element> <xsd:element name="index" nillable="true" type="xsd:int" /> <xsd:element name="comment" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(length=255)</xsd:appinfo> </xsd:annotation> </xsd:element> <xsd:element name="amount" nillable="true" type="xsd:double" /> <xsd:element name="detail" nillable="true" type="tns:BBO_PaymentType"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@ManyToOne(cascade=CascadeType.REFRESH)</xsd:appinfo> </xsd:annotation> </xsd:element> <xsd:element name="caseID" nillable="true" type="xsd:int" /> <xsd:element name="status" nillable="true" type="xsd:int" /> <xsd:element name="createdDate" nillable="true" type="xsd:dateTime" /> <xsd:element name="currency" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(length=255)</xsd:appinfo> </xsd:annotation> </xsd:element> <xsd:element name="department" nillable="true" type="xsd:int" /> <xsd:element name="exempt" nillable="true" type="xsd:boolean" /> <xsd:element name="taxes" nillable="true" type="xsd:double" /> <xsd:element name="amountPlusTaxes" nillable="true" type="xsd:double" /> <xsd:element name="clientId" nillable="true" type="xsd:int" /> <xsd:element name="type" nillable="true" type="xsd:int" /> <xsd:element name="autoRequesDate" nillable="true" type="xsd:date" /> <xsd:element name="autoRequest" nillable="true" type="xsd:boolean" /> <xsd:element name="NCF" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(length=255)</xsd:appinfo> </xsd:annotation> </xsd:element> <xsd:element name="QuickinvoiceId" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(length=255)</xsd:appinfo> </xsd:annotation> </xsd:element> <xsd:element name="facturaEnviada" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(length=255)</xsd:appinfo> </xsd:annotation> </xsd:element> <xsd:element name="DueDate" nillable="true" type="xsd:date" /> </xsd:sequence> </xsd:complexType> </xsd:schema>
this is the xsd of the cdt
also i send you the print screen of the expression rule that i obtain the invoice from these two codes "ri!cliente[1].billNo" , "ri!cliente["billNo"]" dont work either i don't know what to do
edit: property() is getting the same result as index()
Seems like this is a record type.
docs.appian.com/.../reference-records.html
thanks for your support that was my problem i referred to the record type of the invoice object