Foundation

Hi Community, I followed the Appian quick start installation guide, and ran all commands:  <APPIAN_HOME>\services\bin\start.bat -p <password> -s all <APPIAN_HOME>\data-server\bin\start.bat <APPIAN_HOME>\search-server\bin\start.bat <APPIAN_HOME>\tomcat\apache-tomcat\bin\start-appserver.bat Everything ran successfully, but when I went to my browser and navigated to http://<FQDN>:8080/suite/design/users, it wasn't connecting, tried different browsers same result. I replaced the FQDN with what I entered in conf.suite.SERVER_AND_PORT= and it is un-commented so is conf.suite.SCHEME=. I'm not sure what else could have went wrong. If anyone have resolved a similar issue your input would be most welcome. Thanks, Eric

Hello, I posted a couple of minutes ago about a dropdown field doing something similar to this except now it is a custom picker field. I put the code below although you cant test because it has a rule in it. If you want you its just countries so you can use USA, UNK, GER etc. The issue is that I need to save the value into the local variable array. Every time I select a option it just deletes the option and I have surmised it comes out of the issue of list of text vs list of null because list of null sets it to be blank and you can pick but list of text fills it with blanks regardless of null value being present in list of text.  Here is the code: a!localVariables( local!pubProdCtry: cast(typeof({null}), repeat(4, null())), local!dataProdCtry1: cast(typeof({null}), repeat(4, null())), local!count: 1, local!datacount: 1, local!primary1: repeat(4, null), local!primary2: repeat(4, null), { a!cardLayout( contents: { a!forEach( items:

The idea that I want to do is be able to save a specific answer into a specific spot into an array. I want to be able to select multiple drop downs save it into one array and then put that in the CDT to be referenced. I do not want to use a multiple dropdown because thats not in the scope of what I have to do nor is it plausible for the problem I have to complete. The basis of this interface is supposed to be able to click the add button add another option and then select if its the primary or not and then save those. This code you can play around with yourself: a!localVariables( local!pubProd: {null}, local!dataProd1: {null}, local!count: 1, local!datacount: 1, { a!cardLayout( contents: { a!forEach( items: enumerate(local!count), expression: a!columnsLayout( columns: { a!columnLayout( contents: { a!dropdownField( label: "Producing Or

Hi all, my requirement is to send the user details through email, for that I Created html document with my required fields and saved in html with .html extension and uploaded in choose upload document  and re-scanned document but the fields are not populating and not getting any error, the below is my html code, please help me where I went wrong. Make Model

How to use user input task in-process model workflow to accept task by more than one manager (each manager have a manager for him)

Hi, I am facing an issue while importing applications into different environments due to nested CDTs. Getting error "An error occurred while creating datatype [uuid={urn:com:appian:types:ADMIN}ADMIN_DF_PI_createConfig]: The XSD could not be imported because it references a missing type: {urn:com:appian:types: Q1}ADMIN_DF_PI_resource. No types have been imported. (APNX-1-4049-001) (APNX-1-4071-007)" here ADMIN_DF_PI_createConfig is parent CDT, and ADMIN_DF_PI_resource is child CDT, both are existing in the same application Due to this remaining CDTs also not imported "The datatype [{urn:com:appian:types:ADMIN}ADMIN_CRE_siteDetails] could not be transported. Cause: The data type [{urn:com:appian:types:ADMIN}ADMIN_CRE_siteDetails] could not be imported because another data type failed to import. In order to ensure consistency, unless all data types inside and outside the package successfully import, no data types are created or updated. (APNX-1-4071-019) (APNX-1-4071

Hi all, uploaded the documents and showing those documents to the user but i facing error in site page showing  "expression evaluation error [evaluation ID = aae0b:d617b] in rule 'sha_imagelist' at function a!forEach [line 23]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!billboardLayout  [line 35]: The image in a billboard layout has an invalid value for "document". "document" must not be null". I checked it by using different function like fco_hasvalue and fco_isnullorempty still i have this issue can anyone help me to resolve this error a!localVariables( local!listingData:rule!SHA_LISTING_EXPRUL(listingId:index(ri!listing,"listingId",null)), local!houses: rule!SHA_qe_getDocuments( entityId: index(ri!Document,"entityId",null) ), local!address:rule!SHA_qe_toGetPropertyAddressDetails( listingId: local!listingData ), local!appCount: length(local!listing

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