Process Modeling

Hello, I need to configure a schedular which should run Monthly on first Monday. I'm not getting what to configure in month field. Please can anyone help me. Thank you.

Hello, I want to implement schedular in start node which will run Monthly on 1st Monday. How to implement it and want value should be passed to month field. Thank you.

Hello team, I tried to set up user input task reassignment via escalation following this logic: 1. I have a User Input task which is assigned to a group called "Processors". 2. The escalation is set up as recurring every 1 hour     2.1 If the user input task was not accepted by anyone from processors group members nothing will happen     2.2 If the user input task was accepted (owner is not null) then the timer will fire and in 5 minutes it will reassign the task back to processors queue I have set it up following way, but when the timer conditions are not met, the task is paused by exception and nobody is able to access it. Any advice there please? Thanks Timer conditions, where if the owner is not null it will return true(), if it is null (so not accepted) it will return false(). c10 represents the Owner column pv!contract.contracId is the identificator for the specific task not( rule!GBL_isBlankOrEmpty( index( a!queryProcessAnalytics(

Hello, I have an Interface. Within this interface user uploads excel file containing some emails. Next user submits excel and process model is started.  Interface is published on a website.  When user uploads excel and clicks submit interface looks exactly the same, no message if the process was successful or anything. I would like to create new popup window or some message when user submits and run process with uploaded excel.  I tried using onSuccess but it didn't work. Do you have any tips?  My code looks like this:  a!localVariables( local!cancel, local!WczytanePlik, local!NazwaPliku, local!Pracownicy: if( a!isNullOrEmpty(local!WczytanePlik), {}, rule!EA_TEST(local!WczytanePlik) ), a!formLayout( label: "Wczytaj plik", contents: { a!sectionLayout( contents: { a!textField( label: "Nazwa pliku", labelPosition: "ABOVE", instructions: "Wprowadź nazwÄ™ pliku",

HI Team I have a scenario , where I have to read User login logs daily and save into database. Solution: > I have created a process model to run in a scheduled manner i.e, daily once , In that I have used readcsvlog( "login-audit.csv." ) It is working fine when i debug process model. Issue: when the process model triggers in scheduled manner, it is unable to read csv file. Getting empty data Please feel free to advice any solutions

I have a csv template which is expecting few fields(could be 100 columns). First i created a dummy template to see if this even works and i am facing some challenges here, need some help in understanding what i did wrong. Below CSV has the data returned however not in expected format. These are supposed to print in 3 different rows but not in same row. Did a!foreach for each column to return its value and saved in respective variables... my actual template: a!localVariables( local!data: a!queryEntity( entity: cons!TST_DSE_TEST, query: a!query( filter: { a!queryFilter( field: "createdOn", operator: ">=", value: fn!datetime(2023, 7, 1, 7, 2, 5, 0) ), a!queryFilter( field: "createdOn", operator: "

Hi! I´m trying to use the smart service "Query Database" to change the value of a concrete field. I have managed to use the an "Update" and "Set" SQL statement to update a database used in the process model which works correctly The fact is that now I would like to do a similar query, but to update a record which is NOT BEING USED in this process model ("CPF Lineas Pedido") Even though I created the query and the process model runs OK, the value of the field "facturada" does not change properly. Also, I brought the new Record as a process variable, but its value does not change (I´m not using it in the process model because I only need to update one value, the one with the query) What can I do?

Hello everyone, I have one question : I need to generate 7-8 different types of reports and when the user clicks on the particular report it show get downloaded in Excel.  So, how to implement it and what to use? Thanks.

Hi Team, I'm using a single process model for creating employee and updating employee(related action). While creating employee simply i create a new folder and move employee documents there. But incase of updating i need to add documents to the same folder. I don't know how to achieve this. I tried with tofolder("emp 1") function with a or gate to check whether it's updation or creation but getting error. Then i removed or gate and checked with the create folder then move documents methods again for updation process it creating a new folder with same name. Need support on this.. Thanks in advance 

Hi! I´m trying to update a value in my process model by using an script task (change value to "true" and saves it into the field "facturada) and then using the writeRecords smart service My configuration is: 1. Script Task: The value "true" is saved into the field "facturada" of my record. It´s important to say that I´m updating an ARRAY 2. Write Records Smart Service In the beginning, I was updating the entire record, but this was causing that my data got duplicated (f.example if I created 2 rows, there were 4 rows). So I´m trying to update just the field I want ("facturada") (The target in my last picture is the field I want to update (recordLineas.....recepcionada)) The error that appears is the following: How can I fix this? Thanks a lot

Hi! I´ve just created a process model for invoices: first, the user fills the invoice fields, and then some checks are made in the process (logic nodes) to determine if the invoice is accepted or rejected (basically, if all the conditions apply then the field "status" of the invoice changes) Now, I´ve added an interface to create invoice lines. And I was wondering how can I make a similar logic (apply conditions for each row and then change the invoice line "status" to "accepted"). I know how to do it for one row, but not how can I "iterate" and make all the invoice line created to "pass" through the conditions Any help would be useful. Thanks a lot!

I am creating a new process model in an application and when I try to set the data type of a PV! to a record type (named "DA Transaction")  It doesn't show me the option to use this record type or any other from the same application. I looked in an older PM from 2020 in the same app and it does have PV! with the correct record type, but if i try to create a new PV in the old PM, again i cant find the record type... I have no clue how to approach this, has anyone seen this before? in the picture you see the old variables with the correct data type and here you see that when i search for it, it doesn't find it. (I tried searching many different ways)

Hi! I´m trying to query a database with the following code (SQL) into the QueryDatabase Smart Service of the Process Model SQL STATEMENT: ------------------------------------------------------------------------------------------------------------------------------------------------------------- Select sum(TotalLineas) as TotalFactura from ( Select PRECIO_UNIT*CANTIDAD as TotalLineas from CPF_LINEAS_FACTURA where ID_PEDIDO = ac!pedidogroup by ID_UNICO ) ------------------------------------------------------------------------------------------------------------------------------------------------------------- If I use the code selected in green it gives no problem. But If I try to include the second "select from"  I have the following error:  What can be causing this? Any help would be useful

How important or realistic is the recommendation to keep under 30 nodes? Has anyone had more than 30 nodes and ran into major issues? How does memory usage impact this?

We have this defect showing up as "High" in the HealthCheck (done each 2w) of our Appian infra: [Process Model Name] (44.4% of all CPU time, 67.6% of all operations, 117 mins of CPU time, 3213596 operation count) We don't have a huge number of processes of this type per day (around 600 complete), and the number of nodes is low. We also see in the same HealthCheck that the input interface it uses is called 1 million times! Interface.[Process Model Input Interface] (1056180 calls, 113 ms peak average) There is no way our one hundred users could call the interface one million times - there would be many more processes per day. Has anyone ever encountered such a repeated call to an input interface, causing huge CPU usage for a single process? Is it possible that the 1'500 such "Active" processes (kept as drafts of user input) be somehow regularly polled, thus calling the input task, and cause the huge number of calls to the interface ? If the above is pos

Hi! My process Model gives me the following error: When I searched into the process start form and rule inputs, I viewed the yellow message of the map. I don´t understand what is happening exactly Can someone explain me why is this error caused and what can I do to solve it? Thanks a lot!

Hi all, I currently have a process model that uses a HTML template to send a list of users, but since my list is saved in a process variable it eliminates any breaks between the names of the users. Write now when I sent the email the list looks like this: name1; name 2; name3; name 4; name5; and so on. But I would like to display the list in a vertical format so is easier to read for the person who is receiving the email. I have tried an expression, scripthml, but nothing seems to work. Does anyone know how can I over come this? maybe editing the template? but I dont think appian lets you iterate over a HTML template.

Hi, I am using doc extraction smart service by AI skill to extract the data from pdf , I have multiple files to extract and reconcile . Is there any way to assign all reconcilation tasks in a singel node?

Dear Community, Good Afternoon.. I have built a case management app based on a tutorial named "IT Ticket Journey". But, due to some issues, i was unable to create a record. Attached screenshot of the error for your reference Request you to kindly look into this and guide us to a solution and also where i went wrong during this  process ?

Hi All, I'm getting an error when I'm trying to write multiple rows to the database at the same time. When I only give one item to the process variable it works just fine, but when is multiple it throws this error. Details: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement: org.hibernate.exception.SQLGrammarException: could not execute statement: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated in table . I have everything correctly set up to accept multiple already, such as the process variable and the write to database smart service. any ideas of what could it be?

I am trying to remove user (System Admin) from all the groups he is part of by using "Remove Group Members" and "Remove Group Admins" in a process and running it as MNI one for each group but still the user was not removed from any group at all.I made the PM lane as Run as whoever designed this process model and I am also a sys Admin but still the Smart service is not working.Am I missing anything here?

I have two process variable that is CDT type. I need to if any of the process variable is null then related to that process variable entity data not executed. Like this:  = {    if(    a!isnotnullorempty(pv!dependencies),             null,    a!entityData(             entity: cons!DSE_COMMUNITIES,          data: pv!communityAllocation  ) ),     if(    a!isnotnullorempty(pv!dependencies),             null,           a!entityData(               entity: cons!DSE_DEPENDENCIES,               data: pv!dependencies    )  )} But it gives error: An error occurred while trying to write to the data store [Tables]. No values have been written. Details: org.hibernate.PropertyVal

I'm using Export to csv smart service but when i export the data it returns only the timestamp for the data time column.I want the date & time .here is my table on UI: here s the column in db: here is the CDT column: and here is the csv column:

Hi, Do we have any chance of removing the above highlighted mail ID and change to custom mail ID?? Thanks in Advance, Gousii.

 Is there any way to check how each node of a process model is performing? Like how long a node is taking to complete. I know we have two(Default Process Model Optimization Metrics,Default Process Optimization Metrics) out of the box reports present in appian objects but can we use them if the process model does not have any attended nodes? or is there any way around to get this info?