Process Modeling

I have a requirement where I have to update a particular field of all the rows of an existing table(Master Table). An API will be called with the PK of the table and the based on the response, data will be stored in the field. And this will be a scheduler which will run daily. How can I achieve this? Thanks in advance.

Hello All, I am not able to complete a task that is created for any attended node by using the a!completeTask smart service from a web api. I am able to successfully complete any user input tasks but not any attended task for any other process nodes. I can complete the same task successfully from Tempo. Also I have used the same assignment group for the user input task and the attended node. Did anybody else face this issue in 21.4? Or is there any other workaround.

Hi Appian DevsI am getting  an email for everytime i hit the process model, in my test environment.The process is to add a template, basically a file upload field in the interface which is linked to a folder, "templates" inside the Knowledge center.The email on every hit of adding the template is here below:amzad.hussain@telusinternational.com has requested a change to add a new file "Short_Name Template File" to the "TCT_KC" Knowledge Center. Click here to Approve or Deny the request.

I'm trying to update     with a  stored procedure but  the procedure doesn't work   these are some pictures  not even this stored procedure works i don't know why 

Hi, I'm experiencing the following behaviour. To the best of my knowledege it is not the expected one, but maybe I'm wrong. I have a process with an usertask node assigned to two groups. Lets call these groups A and B. User1 belongs to Group A, and dont belog to Group B. When the process is started, it creates the task, lets call it task 1, corresponding to mentioned usertask assigned to groups A and B. I check on a report task of type "Task attributed to user" with User1 in context, task 1 is included. So far so good. Then I remove User1 from Group A. What I expect is that task 1 disappear from the report, but it remains on the report (of course I refresh it once and again) until no less than half an hour. After 30 minutes more or less, it is not an exact measure, report shows correct tasks, I mean, task 1 is not showing any more on the report. I assume that this is not the expected behaviour ¿Am I wrong? Regards

Hi All, How to handle exception while  using Import Excel to Database in Process Model . In other ways, I want to show an Error Message in the interface if Import Excel to Database throws an error.

Hello all,  I have a process that is trigerred by a timer event.  I want this process to be trigerred on a quartelry basis, with the first trigger date on March. How can I specify the month that I want the process to start ? Thanks in advance

difference between terminate and end event, also  if i add asynchronous process model to the terminate process event then how process model and instances behave?

I am doing the Acme Auto Exercise for the Appian Developer coursework and am having some issues saving configuring the XOR gateways to save the condition pathways. The instructions as listed under "Appian Step-by-Step #9": Configure the Cancel XOR Gateway In this process, if a Mechanic cancels the start form, the process will end. If a Mechanic submits the form, the process will continue to the next process node. Follow the steps below to configure the Cancel? gateway. Drag and drop an XOR Gateway into the Maintenance swimlane to the right of the Start Node. Rename it to Cancel? Drag and drop an End Event into the Maintenance swimlane above Cancel?. Rename it to End - Cancel. Connect the Cancel? and End - Cancel nodes. To connect, hold down SHIFT on your keyboard, and then click from one node to another. SHIFT will automatically toggle your pointer to the connector tool. You can also use the Connect icon to connect the nodes. Drag and drop an XOR Gateway into th

I was watching the course Advanced Appian Developer > Design for Scale Using Patterns and Anti-Patterns > Process Management Patterns. https://academy.appian.com/#/online-courses/9eec0cd2-199a-4c4e-85a8-cb7d044c0718 At about the 2:10 mark the instructor states "Text variables used by a process remain in cache until the next restart so archiving does not immediately remove all data. Do not save large amounts of data in text strings ..." This sounds an awful lot like a 'memory leak' to me. I thought that all memory for a process was released when the process is deleted or archived? Is this not the case? When is this memory recaptured? When the server is restarted? If so, how are clients who license Appian through the cloud impacted?

Hello, Currently Im tryimg to set up a deadline for task completion - add 5 working days to the creation date and display the deadline in the tasks grid in case the task is triggred

Hi Everyone, The "Reassign Button" is getting displayed to the users even when they have Basic user privileges. The User input task is also configured not to have "Reassign" option in Assignment tab.  And this issue is not occurring consistently, if we create new cases for those users, we are not able to see reassign button. Please let me know if anyone have some idea.

Hi Guys,              I was upgrading the application from 17 to 21 version where a!toJson works good in older one but throwing error in the newer one while giving record constant as values. Help with this issue. Thanks in Advance. Regards, Kavya

I am exporting a report that contains data on two tabs and am using two Export DSE to Excel nodes. Some tabs share the same columns but there is inconsistency in the format. 1. Column Headers are bold in tab 2, not in tab 1 2. ID formatted as number in one, text in another An ID from Appian that should be exported is 000002233403600018 In the respective column, the ID is exporting differently on each tab: Tab 1:  2.2334E+12 Tab 2: (this cell also says an alert message: The number in this cell is formatted as text or preceded my an apostrophe). 000002233403600018 How can I apply the formatting from tab2 to tab1?

Hi All, Emails from send email Smart Service are going into recipients junk folder  .Can anybody help  me on this

How does one send an email to a process? I have the following flow, sending email works fine, but did not understand how to configure receiving email (in Managed Service / cloud): I am currently using Appian Community Edition Thanks in advance!

Given a string containing a username (this can change easily to user first + last name), I would like to assign a task. I am using the following expression to get the user =touser("Yoel.Feuermann-yoel.feuermann@zencargo.com", "-")[1]) if I try the above in a FORM - it works. but If I have it in the assignment expression - it doesn't assign properly it gets assigned, but to an empty user: 

As someone who likes to have code with easy to read comments explaining what everything does and why, I like to use the annotation feature on my process models. However, the annotation boxes have the baffling functionality of obscuring nodes beneath them. I'd ideally like to just stretch an annotation box over a pack of nodes and note "These nodes are here for purpose x" so the next person who looks at them doesn't have to dive into the nodes to figure it out. Is there any way to do that currently without obscuring the nodes I've put the annotation box around? And if not, can we request that for future updates?

Hi,  I have a webapi created in appian that starts a process model, it always returns a 200 status code because starting the process correctly, but this process can fail. Is there any way that this webapi does not return statusCode 200 if the process fails at some point? Thanks

Hi, I just designed a simple process which has only three nodes. They are: Start node, Write to data store entity node, and a end  node. When i click on submit, its says that action completed. But when checked the database the data is not inserted. When checked the process monitor its shows only two nodes(Not sure Why). Please let me know what's happening in back end, and what might be the reason for showing only two nodes.  My CDT looks like below Id --- Primary key autoincremented Name --- Using cons for list of names Money --- entered by user in interface Transaction_id --- entered by user in interface from_bank. --- Using cons for list of Banks Transaction_Date --- now() is used to update date. Description: The interface has only Name, Money, Transaction_id, from_bank; a cancel and submit button when summitted the data need to written directly into the database. (Which is  not happening) Let me know where might be the error and first point to check. Thanks in Ad

Hi! As I am new to Appian, so I have faced a problem while creating a process model. I wanted to know how can we check in a process model whether the employee id of the user already exists in the database but is in the inactive state or it is a new user? 

Hello, The basis of this question is in the subject. What is happening is that we have a trigger function in our database that creates a 32 varchar UUID for each record when they enter our database. My issue is that since the UUID is not generated by Appian in the Data Type it doesn't pull it into the process. Since everything is a process variable I would need to pull information into the process model. Where I am coming into an issue with is how I would do this. More information no other column in the database is Unique so querying from the database would be difficult as things may repeat. Any information is helpful thank you in advance!

Hello, I’m evaluating the Appian tool for a customer, and one of the criteria I’m looking at is the ability to separate customers in the same flow. Is multi tenancy a feature of process flow? How can this be achieved? Thanks in advance!

Hello Appian Community, I am using "Create User With i18n" smart service in a process model to create a user. I am getting error " The following fields have invalid characters [Last Name: Abc Defghi Jk Lmno Pqrstuv WxyzAbcdefg Ijklm] *Name fields  may only contain letters, numbers, whitespace, and the _ or - special characters and username can only contain letters, numbers, and the following special characters: @ . _ - .  It must not match an existing username regardless of case." As you can see there is no special character in field "Last Name". and I also checked username is not present in appian. Still it shows this error.  Does that field has any limit on number of characters ?? Thanks, Shikhar Barve

Hi, We have a requirement where we need to send an email with the start process link and as the user clicks on that it will open the first chained user input task in that process. I have tried adding the above component in the expression editor in the message body but the email does not have the link and showing the attributes of the component. Thanks,Sanjay Joshi