Process Modeling

Hi,  I Have a Requirement that, post to event smart service should run at different times specified.We have two role based users,Creator :who can create an eventAttendee : whom are invited to the event.Event start time will be saved into the startDateTime ruleinput.creator can send remainders to the Attendees with the available options as before 5min, before 10 and before 30min.Remainder time will be saved as an integer array.  So we need to post the event to the attendees at a specified time, I have used this function , which gives datetime after subtraction of minutes .=subtractminutes(startDateTime,remainderTime) My query is, how can I trigger a node multiple times, with a multiple datatimes.

Suppose there is a sub process in a main process. When we execute main process multiple times then it will generate multiple instances for main process as well as sub process. So how to identify which sub process instance belongs to which main process instance?

I'm trying to load in a grid on interface an excel file content. I use a file upload component, and on submitform button i use a "startprocess". "OnSuccess" event i'm trying to get a PV that contains the parsed value, return null. I have had a first problem that going to fail the process but i introduce a 1 second delay on a node and now the process end everytime successufully, but i cant get that value in my interface. With same sintax i'm trying to get a pv that i'm just passed like process parameter, so that variable (a simple number) i have successufully recovered, from the same process.

Hi, I have a CDT meeting_details, in that I have a field attendees with type CDT  Child CDT named Attendees is the foreign key in the parent table In Interface I have used User picker, and collecting multiple users into text format, further I will be using those users to create a group and users into that.When i am trying to use write to multiple data store entities and giving a single user in the interface, the parent as well as child table is getting updated, but when there is a array of users from interface, then it is populating this error. I am providing here the code for configuring of write to multiple data store entity smart service = { { entity: pv!meetingDSE, data: { pv!meetingDetails } }, { entity: pv!attendeeDSE, data: { pv!attendeeData } }}I am providing here the process variable snippet Can anyone help me out from this issueThanks in advance Prithvi

Does anyone know, when a process model is republished, who gets the email?  I always thought it was the designer/author of the process model.  However, our objects in an upper environments have a service profile as the designer/author.  The service profile has a distro list as it's email address.  I'm told (I'm not on the list), that for our application they are getting the "Alert: Sub/linked process models are republished" emails, but for another application they are not.  Is it possible to configure these emails by application or object when a republish happens?

can we retrieve the data from database using stored procedure

Hello everybody.I have a problem: I would like to start a Process, which is depending on the value of a particular Link's string.For example, if I click on a Link with "CC1" value, I would like to start a Process called "TagName_CC1". a!columnLayout( contents: { a!forEach( items: index(local!rowsLevel_3, "LEVEL_3"), expression: a!cardLayout( contents: a!richTextDisplayField( value: a!richTextItem( text: fv!item, link: a!startProcessLink( processModel: /* TagName + rowsLevel_3*/ ), linkStyle: "STANDALONE", color: "ACCENT", size: "MEDIUM_PLUS", style: if( fv!item = local!selectedliv3, "STRONG", "PLAIN" ) )

Hello community, Could you please advise me. I am trying to figure out how handle some timeout or problem during get data from database.For the displaying partly of my interface I need to get data from the Database. This data is not mandatory only optional. Have you got any idea how handle situation when that database will be unavailable or reach timeout -to continue display data in my interface? Because now I will receive error message and all interface(application) is affected - because data is get for construct the interface.My idea was create an asynchronous sub-process for retrieving data from the database - but I was not able to find this solution in the best practices and on the other hand I was not able to create it - because to starting the process the system wait to any trigger/input. Have you got experience with it?Thanks in advance,Pavol

An error occurred while evaluating expression: workflowDetails:rule!CNAM_GC_qeForAllTables(Flag:"WorkflowbyWorkFlowId",wfid:pv!workflowDetails.workflw_id) (Expression evaluation error in rule 'cnam_gc_qeforalltables' at function a!queryEntity [line 254]: An error occurred while retrieving the data. Details: Memory threshold reached during output conversion (rule: [queryentity expression], type: [CNAMGCWORKFLOWDT41204], threshold: [1,048,576 bytes], objects successfully converted: [12,000])) (Data Outputs)

I would like to extract process variables info from an existing process instance with out using using a a!startprocess() function.. Is there any solution for this usecase. input: processid output: list of key value pairs of process variables. 

Hi,We have a situation where we need to proceed to the next node when a smart node fails. Now, we have to manually start the next node and this is not a efficient way since the process will run for several hours. I tried using the timer in the exception flow but this doesn't seem to work. Any ideas on how this can be achieved to prevent manual intervention? Smart Service used is "Move To Filesystem" under FileSystem Services. In the exception flow, I have used Timer set to 1 minute(exception tab) so it would take exception flow if the node stays for more than a minute.  Any help is appreciated. Thanks, Meena

Hi all, I have a process that I want to run, for the amounts of data/records on an array, BUT, I want to control the number of instances it runs each time. For example, I have 20k records but I want the process to execute 30 each time.

Hello, I'm working on a process model and I'm seeking advise on a way to save (extract) a document that was stored in a SQL table and store it into Appian Knowledge Center Document repository. The file is stored as binary in the SQL table, I have already created a queryEntity to return the records from the database, the next step is saving that data field into Appian Knowledge Center as a standard file/document. Thanks in advance.

Suggestion: I'd like to suggest you update this tab values to an expression, so we can set constant values instead of literal values All of the other tabs already have their values as expressions. Reason: I'm having a 'corno job' changing more than 300 processes by hand. If I could change this to a constant, it would be easily changed by the next unfortunate one that needs to update this by just changing one constant.

Is there a way to store tp variables before a task is completed? I am making task reminder emailer subprocess with customized emails and reminder delays based on tp!name of active processes. I have a requirement to avoid using queryprocessanalytics due to appian telling us it is costly for a daily reminder emails.  Instead I am trying to keep track of the list in process. Example: I have 12 tasks going in parallel and need to keep a list of tp!ids and tp!names for active tasks.  Then pop them off the list when done.

Hi, Could you tell me if it is possible to launch a modal user task from a process ? I need to display a simple interface B (with only readonly data) above another interface A, but I need the later interface to be not refreshed, so I would need a modal dialog. It seems we can do such a thing with RecordType options (choose the modal dialog appearance), but I need to do it with a simple process (without any RecordType). Is there any parameter for this ? Regards

HI Appian support, We need to create webAPI for starting a process model, which has a receive message smart service at the starting point of the process  model. This scenario we require for the Approval/decline workflow to be integrated using teams, that is, Approval from the teams app is associated with Approval API from the Appian web API, which will start a process model with receive message smart service event. How will I achieve the same work flow using Appian web API and process model, can anyone help me with this? Thanks Sunu Sam

1. I have a process model "Main_Process". It wants a pv!letter from the below process it runs 2. Inside I have a Start Process node that calls a process model "Apple". It wants a pv!letter from the below that it runs. 3. Inside "Apple" I have a synchronous sub process "Core" inside that outputs to its parent an important value we will call pv!numberOfSeeds I can send data between 1 and 2 with activity chaining and outputting variables i want with AC!processinfo.pv My issue is that when 3 "Core" is involved, I can get nothing out of it, and any variables changes done during or after it are no longer visible in "Main_Process" Any ideas on how I can get values out of Core to my Main Process? Main_Process_______________________________________ Apple________________________________________ Core_________________________________________

Hi Guys, I have added this PDF Doc from template after my Write to DSE smart service so I can get the values in the pdf doc. But I tried using "###book_name###" and other sample template. The flow is working but I can't open my pdf file and its showing this. If you have any sample templates or any links or any walk through snaps that could be useful just share it in this forum. Thanks in advance!!!

Hello, I want to insert a list of a CDT to the database. In an Interface, I create that list, and after, I want to insert multiple rows to the database (one for each item of list).How can I accomplish that?That interface is connected with a Process Model.With a forEach in the Interface, I can only insert 1 value, I think.It is possible to do a cycle to iterate the list in the Process Model?Thanks, David

Hi Everyone,  In Process model write to multiple data store Entity is breaking with this format error :---> error converting typed value TypedValue... to XML in order to convert it to java type " while saving .Please can anyone help me out in this and suggest .

Hello community, I wonder if this a bug or I am doing something wrong.we use Appian 20.4. If I try to get the data of a map using index or property it always returns default value when present.This behavior only occurs in the process model and not in a expression object.e.g.pv!testMap: a!map(errormessage: "something went wrong"), then this code property(pv!testMap, "errormessage",  "default") or the same using Index function.Will return "default". dot notation works: pv!testMap.errormessage wil return: "something went wrong".property or index without a default works: property(pv!testMap, "errormessage") wil return: something went wrong". Maybe I overlook something, got it working by the way by casting the map to a map but that makes no sense off course. Kind Regards, Erik    

Good morning, We have the need to set up an integration to call us and return a response from a file. We are creating a WebApi that receives an XML and raises a processModel, does the validations and returns the response. The problem is when we have to make that it does not exceed 20 seconds. We are putting a control timer, but this timer makes that when calling the WebApi it finishes without waiting the 20 seconds. Thank you Alex

The variables present in the HTML template is not getting replaced (substituted) with the values in "Docx from HTML" node when there are two "Docx from HTML" nodes present in a Process model to generate two different documents.

Hello Appian Community [emoticon:c4563cd7d5574777a71c318021cbbcc8] Goal : I'm looking for a way to call a specific sequence in my database without having a huge amount of process nodes for each sequence I have.Additional information : Depend on the context, I have to call a sequence. So for 50 contexts, I have 50 sequences. I previously made 50 nodes to call my specific sequence depend on the context.What I've newly done : In my process model, I have a node to create an SQL query where I inject this query to call the sequence I want, depend on a given context. As you can see, the query variable "ac!sequence" is my SQL where I try to get the NEXTVAL of a given known DB sequence.But by doing that, my process model rise an error : "There was a problem executing the SQL query. SQL Message : Invalid SQL type: sqlKind = UNINITIALIZED" Questions :I guess is not a proper way to do that, but what can I do to fix it (if it's possible) ? How to reach