Community

I have been using the 'Send Email' node recently, and after a while (and some trial and error) I realized the node was sending the emails to my spam folder. Is there a way to specifically tell the node to send it to a specific folder/inbox (such as my main inbox)?

Hi,I had a requirement, has to provide a link for the box layout header, 

can anyone please give suggestion how to resolve this error ?

An error occurred while trying to write to the entity "StudentEducationDetails" [id=d95007c3-ee01-472a-b90c-0dbf8570a6e0@5696, type=StudentEducationDetails (id=4074)] (data store: StudentBasicInformation). Details: javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: could not execute statement: org.hibernate.exception.JDBCConnectionException: could not execute statement: java.sql.SQLTransientConnectionException: (conn=468975) Data truncated for column 'StartYear' at row 1: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Data truncated for column 'StartYear' at row 1: java.sql.SQLException: Data truncated for column 'StartYear' at row 1 Data: TypedValue[it=4074,v={<null>,<null>,Jabar,B.tech,2017-11-01,2021-12-07,90,1,2022-11-28 04:30:00.0,NRT}]

error is : ???An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.???  I have an excel with 4 columns  Column names are same. I don't understand the error. File name I am passing as process variable. Number of columns to be read is 4 as i have 4 columns in file. Table name is my datatype name and data source is jdbc/mydatabase. What am I missing? 

Please help me check if the given number is between 1 & 20 digits and doesn't contain any alphabet in it. Like we have like(fv!item,"[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]") to check the given number should be exactly 10 digits and no alphabets in it.

Hi, I am facing a strange issue.. pls let me know if you can see where the problem is or if you need more data to answer this feature is - when an user deletes a record in a table (noc_area) - I am trying to capture the details of noc_area to another table noc_area_audit + 3 more fields. I am triggering this inside the delete function at saveInto rule inputs are areaaudit and record areaaudit is CDT  record is CDT so when the user is deleting a record.. I am capturing the  1) areas (text) from record and passing it to areas (text) of areaaudit 2) areavalue (integer) from record and passing it to areavalue (integer) of areaaudit 3) areacomment (text) from record and passing it to areacomment (text) of areaaudit ------->>>>>>> not happening and some hardcoded and system generated values to the remaining fields of areaaudit.  When I delete a specific record all values are getting successfully populated except for areacomment. It is space

How to auto refresh a page that is being called in a site. for example, when I click on Change Department and fill the form and submit. the changes must be reflected on the User screen without refreshing manually

Hi, i am looking how to achieve multi transaction using Appian. Is there any bottleneck  to achieve this? e.g parent and child transaction should commit at the same time. Thanks in advance Chetanshi

I started the process with an interface (Create Exam) and then I want to store it in the database, but I guess there is some problem with the database or Record type, Can anyone please help me understand what I am doing wrong?  

Hello Everyone,This is AEW live build challenge demo. I want to write the value to WINNER_COUNTRY_ID OF the database table WC_COUNTRY.I want to select the country name from WC_COUNTRY.Can you give me some ideas how to work on this process.

How to call a record view in an interface.

Hi All,I was trying to show tasks related to the order  in that order details interface, I was trying to write code but most of the time it comes half baked.I would like your help in this case. I understand I need to use looping, indexing and if condition to get this done , But I was not able to get the correct form of logic.  If any sample code is available for this scenario is very helpful for me to understand.Thanks in Advancefor example(The desired outcome), below for an order it is showing approval task related to that order:

Dear All,I am very new to Appian, kindly guide me how to get MyAppian page in Appian Community Cloud Platform. Guess, it's available on paid version only, in this case, I am trying to upgrade from community to paid version, but I am unable to do, please guide me, I have gone through the documentation. But couldn't solve my problems.Mainly I want to connect my existing Cloud Databases (Azure SQL Database & Aurora MySql database) to Appian Cloud platform. Your early response is highly appreciated. With best regards

Hi In my task report there are 3 active tasks, but when I tried to query that report in Interface it is only showing 2 active tasks.Can you please help me to know what is the issue?Code for the same:a!localVariables( local!pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ), local!report: a!queryProcessAnalytics( report: cons!TS_Constant_Process_Approval, query: a!query(pagingInfo: local!pagingInfo) ), a!gridField( label: "My Tasks", instructions: local!report.description, data: local!report.data, columns: a!forEach( items: local!report.columnConfigs, expression: a!gridColumn( label: fv!item.label, sortField: fv!item.field, value: if( fv!item.configuredFormatting = "TASK_STATUS", index( { "Assigned", "Accepted", "Completed", "Not Started", "Cancelled", "Paused", "Unattende

Lesson 4 Exercise: academy.appian.com/instructs me to "Log into your Appian Community Edition environment, and select the Acme Exercise application."I cannot locate "Acme Exercise" where I could work with an Expression Editor."Acme Solution Site" takes me to https://swmi.appian.community/suite/sites/acme-exercise-sitebut  I am not able to locate an Expression EditorWhere is "the Acme Exercise application"?

Hi All, "Request Re-Opened Details are updated" should change to "Request reopened details are updated" can anyone please help on it Regards, Supriya

Hii All, I want to know how to maintaine audit log like if I have an any request form then I fill all the fields and submit the form. Then the form is submitted and then user wants to edit some fields in the form & submit it. 1)How to show those changes in grid for every Action(create request, update, cancel)? 2) How to show all the activity for that request?

Hi All, How to get the tasks which are requestedOn/created today, Need to return only today's date & time requests thanks in advance

How to index department from one of the index where empId is same as loggedin user Id. here allUsers stores Record data.

For example, I have process variables arrays         name : {"a","b","c","d"},         age : {1,2,3,4},         email : {"@e","@r","@t","@w"}and I have a CDT which has {name,age,email} How can I save those array values in my CDT  in process model? bcz when I try to use script task to save the array values in CDT and write in the db using cdt  then only first row is getting written in db.

Hello I am using Appian 22.4 version & Using Appian, I need to create Login Page which I did (Using Interface) but what configurations are needed to Validate it with the database and check if the Username and Password are correct or not, if correct and then only redirect it to DASHBOARD page Till now I have made the pages using Interface, but I am confused because END Users will be using Tempo/Site and not Interface Can someone please guide me on these issues

a!localVariables( local!chooser:1,{ a!columnsLayout( What I did here is I created 4 different interfaces (Create New Exam", "Manage Exam","Attempt Exam","Exam Analysis) and now I want all these different interface inside one interface i.e The one I am working on which is facing this error. What I want is to use Radio button and when I click on 1st option I want the 1st interface(Create New Exam) to display and for option 2 the 2nd interface and so on. How can I resolve this error or maybe other way to bring the interfaces in one single one? Below is the code for the 5 the interface I am working on columns: { a!columnLayout( contents: { a!radioButtonField( label: "Exam Module", labelPosition: "ABOVE", choiceLabels: {"Create New Exam", "Manage Exam","Attempt Exam","Exam Analysis"}, choiceValues: {1,2,3,4}, value: local!chooser, saveInto:local!chooser, choiceLayout: "STACKED", validations:

I'm passing multiple values in fields above except id (Id field is emoty as i have cofigured in cdt as autogenerate),Like paasing a code in userId which returns {2,2,2,2}code in product id returns {1,2,3,4}code in userProduct quantity returns {100,55,68,75}code in total price returns {100,230,45,67} isactive is trueCan you help me what is the issue here?

What's the difference between thingworx composer and Appian?