Foundation

I am also facing this issue but I have checked it everywhere like XSD, DB and CDT.every Every where the PK is defined in the right way, I am not getting where I went wrong, can anyone help me with this error.   @Table(name="SHA_listType") @Id @GeneratedValue @Column(name="listingId", nullable=false, unique=true, columnDefinition="INT") @Column(name="propertyTypeIdFk", columnDefinition="INT") @JoinColumn(name="propertyTypeId") @Column(name="propertyName", columnDefinition="VARCHAR(255)") @Column(name="status", columnDefinition="VARCHAR(255)") @Column(name="propertyDescription", columnDefinition="VARCHAR(255)") @Column(name="floorPlanName", columnDefinition="VARCHAR(255)") @Colu

I have the below expression rule, and which is pointing to an entity using a constant. a!queryEntity( entity: cons!AT_EMPLOYEE2, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "status", operator: "=", value: ri!status ) }, ignoreFiltersWithEmptyValues: true ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 10, sort: a!sortInfo( field: "employeeId", ascending: false ) ) ), fetchTotalCount: false ).data and I have the below code, and which is containing a grid and the data getting loaded based on the "Status" dropdown selection. I am getting an error while exporting the data into an excel. Can someone advise what needs to be done. The error is at the line " entity: 'type!{urn:com:appian:types:AT}AT_employee2(rule!AT_getEmployeeDetailsByParameters(status: local!sta

Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridField [line 497]: A grid component [label="null"] has an invalid value for "data". "data" must be sourced from a Record Type, a query, a list of Dictionary, a list of CDT, or a data subset. Received: Text I'm trying to refactor the code to display the data in read-only grid the previous version is with a!gridSelection() which is passed form expression rule to an interface to handle a!pagingInfo() and as per my understanding a!gridSelection() is deprecated and instead a!gridField() should be used. rule!abc_expression(      select:rule!selectionFilter(),      queryFilters:{               rule!queryFilter(),               a!queryLogicalExpression()              },     pagingInfo: ri!grid

Hi  I want to record my own voice and play it via button or link. is that possible?

    How to remove values in this grid?

Hello, I would like to add color (red) to the label of a textField() in my interface. I know I can use a!richTextDisplayField() and then use the a!richTextItem() to change the colors of the value. Below code displays Red color value; But I need the label to be in Red color: a!richTextDisplayField( label: "Red Text", labelPosition: "ADJACENT", value: a!richTextItem( text: "Red Value", style: "PLAIN", size: "STANDARD", color: "NEGATIVE" ) ) How can I change the color of the Label here? Thanks in advance for any help in acheiving this.

Hi All, I am getting error for pattern  below   ("^[a-z._-@'0-9A-Z]+$") Error is illegal character range near index 8 . it is near dot. Please let me know if  any acceptable pattern for below charater.  thanks Sushma.

Hi , My requirements are i need to get the above images based on the no of listing id's i have. I also need to get  the address  and price and all details should be dynamic also . Can anyone please help me out here .  Below i have attached my  code  a!localVariables( local!houses:rule!SHA_qe_getDocuments( entityId: index(ri!Document,"entityId",null) ), local!address:rule!SHA_qe_toGetPropertyAddressDetails( listingId: ri!listing.listingId ), local!listingData:rule!SHA_LISTING_EXPRUL(listingId:ri!listing.listingId), local!numCols: 3, local!selectedCard, local!selectedInterface, { a!columnsLayout( columns: a!forEach( items: enumerate(local!numCols)+1 , expression: a!localVariables( local!colIndex: fv!index, a!columnLayout( contents: { a!forEach( items: local!houses, expression: a!cardLayout(

a!textField( label: "Date Of Application", labelPosition: "ABOVE", value: ri!today(), saveInto:{ri!today(), a!save(ri!LM_CustomerDetails.loanid.dateOfApplication,today())} , readOnly: true ) i need to save the date in database . i have tried various means but cannot find correct way. can anyone solve this. thanks  Yeswanth

I Create a validation query that check if the emails exist in the RDBMS, if email does not exist the validation shown like this, but I struggle in the multiple message because I used a!foreach for that.How this text make as one only?

One of our process model is being used inside a WEB API as startProcess, Some external System has hit the Web API 50k times & that particular process model & its sub processes has started 53k+ times. Due to this the Appian Server & the other process are not running . Monitoring tab is also not accessible. What is the easiest way to delete all this 50K instances so that the server can work properly

Hello,  I am thinking how I can achieve something like this with seal only,  a!localVariables( local!data: if( isnull(local!a1), updatedictionary(), /* Second Condition */ if(isnull(local!b1), ), ), null ), local!data ) basically if condition for null value, if it is null exit, if it is not null do action and that check next value, problem is that in the if there are condition, true(), false()) where it does not allows a action with another if inside the result part.  Any idea which is the best approach ?

Hi Friends, Logically how to change the date field mm/dd/yyyy to dd/mm/yyyy. Tried many way but to me not getting correct answer. Please share your ideas.

Hi All , I am build an interface in which two card layout are there for Approve and Reject , and In link field of card Layout I am performing an action . I am facing an issue while refreshing the page when an action is performed via link field of card layout . Please tell me how to refresh a page automatically . Thanks in Advance

Hi All, We have a requirement of closing the current tab in a browser when user clicks on link/button in Appian. For Instance, in a browser I have multiple tabs opened and among that one of the tab is Appian. I have a screen built in Appian and when user clicks on that particular link/button the current tab should be closed. Any thoughts would be helpful in this area. Thanks In Advance!!

Hi ,We are generating report using HTML and converting it into PDF. We are using HTML to PDF smart service for conversion.Now we need to show/hide few section in the  report based on some conditions. We used style="display: none" in html. but this is not supported by HTML to PDF smart service.P.S: We already tried using PDF from HTML smart service, but due to some design issues we started using HTML to PDF smart service.Is there any other possibility to hide/show some sections in report which is supported by HTML to PDF smart service?Thanks in Advance.

Hi team, my requirement is : I called my record type into a interface to show in grid format, want to show all the images i have uploaded for all the respective  id's of grid and i tried using expression rule and but facing problem in passing the id of the record into the expression rule, please help me with this.  a!localVariables( local!selectedInterface, local!ammenities:'type!{urn:com:appian:types:SHA}SHA_newAmmenities'(), local!list:'type!{urn:com:appian:types:SHA}SHA_listType'(), local!Document:'type!{urn:com:appian:types:SHA}SHA_document'(), local!docImage:rule!SHA_qe_getDocuments( entityId:ri!listing.listingId ), /*local!data: a!recordData(*/ /*recordType: 'recordType!{f5a15e34-42fe-43a9-b8c0-e51ffd299618}Student list type',*/ /*filters: a!queryLogicalExpression(*/ /*operator: "AND",*/ /*filters: {*/ /*a!queryFilter(*/ /*field:'recordType!{f5a15e34-42fe-43a9-b8c0-e51ffd299618}Student list type.fields.{listingId}listingId',*/ /*operator: "=",*/ /*va

Hi Team, We have a requirement to place a signature in PDF. We created two ways of solutions. Please find the below details, 1.Signature Component and PDF Utilities plugin. 2.Docusign integration As per my organization suggestion, Docusign needs to purchase a license. But here we want a solutions for R&D purpose. Hence we are not able to purchase any third party license. We used signature component and PDF utilities(Image to PDF) to merge the signature into PDF. Question: But we need to send X and Y coordinates to place a signature in right place in PDF. Is there any way of solution can User picks X and Y coordinates in Appian else share your suggestion too. Thanks, Pradeep Sridharan

Is there a way to restart the course. I am not able to see the activities again. Only course vedio can be restarted.

Hi, I have defined the below process model and an interface with milestone. I don't have any mandatory fields inside the "Previous Employment" tab (form), but still by current process is creating an empty record inside PreviousEmployment table with an employeeId. Can someone advise, how can I stop creating an empty record. Basically, I need to check whether PreviousEmployment CDT is empty or not. Where and how I can do this? Thanks in advance.

Hello, is there a way to optimize the reading of excel file with Excel Tools Plug-in. In general the reading time it takes to long, for example to read 70 cells it takes about 5 minutes, for something like that :  a!localVariables( local!data: 'type!{urn:com:appian:types:BTR}BTR_D1_B'( /* 18 */ c18_1: excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {4}, rowNumbers: {39}), c18_2: excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {10}, rowNumbers: {39}), c18_3: excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {12}, rowNumbers: {39}), c18_4: excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {14}, rowNumbers: {39}), c18_5: tointeger(excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {17}, rowNumbers: {39})), c18_6: excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {20}, rowNum

How to hide custom picker field and display a textbox for creating new record when there is no matching data available in custom picker in selection coming from DB & Vice-versa. Can anyone help me out for this logic??

Hi, I have an expression rule. Please refer to the below screen I have designed a horizontal milestone inside an interface and calling the above expression at  local!steps. When I run the interface, I was able to see proper tabs (Main Employee Form & Review). But, the Issue is when I navigate to "Review" tab, it was showing hidden tabs layout also. Any one is having any idea, how can I avoid this issue. I would like to show only the screens which are visible during load. I don't to see hidden tab screen details in the "review" tab.

Hi all, Recently been facing issues with the Email Smart Service. Often, it will fail to send an email if there are multiple attachments (PDFs). Has anyone faced issues with it before where it says "failed to process attachments" although the documents are available? It's causing me a major headache, so I'm thankful for all kinds of input. Thanks in advance, Matthias 

Hi there, can "Newline" (Enter Key) character be accepted in "Text" field on the interface? and can be checked if "Newline" (Enter key) character being input (Enter key pressed)? what I am trying to do is that finding the user finishing inputting the data, while dont want to move the focus (the text field is set as "Keypress" for "Refresh After"). regards, Lin