Foundation

My requirement is that i have an editable grid which has lets suppose 1000 rows and i have to only sent the updated one to Database. i.e. if user change 3 out of 1000 rows then only 3 should be sent to process model or a!writerecords for updating this to DB rather than sending the whole 1000 rows. So what i did i created two variables for fetching record data from DB. 1 containing the original data and second containing the changed data, Now my requirement is to compare both these variables so that i can find the changed data which can then be sent for update.

For a while now we are getting JAXB errors in several different process models with the following error or similar to this error. Difficulty is that even if it will return the same error; where the error happens might be in different parts of the same process model (see below), but mostly it will break on the start process nodes from what I can see. We tried removing special characters or smileys from any fields that are passed to the process with clean(), since we feel like this might be causing the errors, but so far no luck yet. Any help would be appreciated!*Please note that I have redacted a large piece of the errortext for privacy purposes. Including parts that might contain the possibly disallowed characters/smileys etc. In this specific example I think it might have been the character ü, but we have found that it is also possible that the character that will break the process is only visible in our main database (not in the MariaDB) as a blank space which makes findin

Let me explain my situation: I have a workflow where certain actions are performed. When a user, let's say XYZ, initiates the process, they are initially assigned as the assignee. However, I need to be able to change this assignee. To handle this, I've created a separate workflow where I only capture the latest active tasks. From this list, I select the task for which I want to change the assignee. Once I reassign the task to a new user, let's call them ABC, I need all subsequent tasks initiated by input to go to this new assignee. To clarify, after initiating the process, I continue working with the same input task when I am the assignee. However, after reassigning the task through a different process, I need to capture the latest assignee for that process, even new assignee's information is already saved in the database. Please let me know if you need more information or if you have any suggestions.

What are three ways to trigger a process from a process model?   Use a!recordActionItem().   Use a Start Process smart service.   Run a!startProcess() from a script task.   Call a web API.   Use a subprocess 

You are configuring a Related Action for an entity-backed record type. What is the proper domain prefix to reference the record data that will be passed into the Process Model as context for the Record Action?  ac!  rv!  pv!

We have a few draft models saved by a developer that is no longer around. Though the same have been updated and published, when the process runs, it shows the ex-developer as process initiator. Is this a known behavior? Is there a way those draft models can be deleted?  Thanks in advance.

I am creating a dynamic intake form in case management studio where the visibility of few fields depends on values of previous fields. Without using local variables, I am facing cache issue when the values/selections are changed in the previous fields . In the interface I don't see any submit or save button to pass no the values from local variable to rule inputs. Please suggest how to handle this situation.

Hi Community, I have an issue when I want to deploy a constant to another application. The constant value is: 5jb899cdn1ag1gm28jvcyacrp The error that happened in Deployment Log is: content _a-0000e8aa-454b-8000-9c1a-011c48011c48_3537223 "TFO_KEY_CONST": An error occurred while creating content [uuid=_a-0000e8aa-454b-8000-9c1a-011c48011c48_3537223]: The constant [id= uuid=_a-0000e8aa-454b-8000-9c1a-011c48011c48_3537223] was not created because a value for the constant must be provided in an import customization file when it is environment specific (APNX-1-4071-054) (APNX-1-4071-007)

Hello, Is the Rule Event node supposed to break activity chaining? If yes then could someone point me how to achieve something similiar? I've got to wait for all incoming 0 to 4 flows to finish and then start the Statuses PM, all without breaking AC so i thought rule event was perfect for that but its breaking the AC. I know adding XORs and dummies in each route going into AND would solve this but im running low on nodes so maybe theres more efficient way. I'm on Appian 23.4 Thanks!

Hi, I have two environments (one is hosted, other on premise). In hosted environment Send Email Smart Service works without problems, while same code in on premise installation doesn`t.We`re using the service to send an email to the person who started a request. The configuration is following: = toemailrecipient(user(rule!HR_GetUsernameByEmployeeId(pv!recordsUpdated['recordType!HR Absence Request.fields.employeeId'])[1],"email")) Do you know what could be the reason for this to work in one setting and not in the other? Kind regards, Nejc

hi, I am trying to build a landing page with three panes.  middle pane has a grid with 10 columns, It ends up showing three and adds horizontal and vertical scroll bar. Is there a way where I can adjust the pane, so that it fits perfectly and shows entire grid. Already tried width component of the pane. Doesnt add difference

Hello I'm trying to build interface where 2 tables are connected.Now for the first table I have interface where user can click on record action and create the record, but for the next table i want user to go under the summary of the first interface and then create record for second table which have relationship many to one with the first table. Is there a way to create record action with just pulling the ID from the summary to be associated with the second interface.So on press it will auto populate the ID where it has one-to-many relationship and user will enter rest of the information and click create.

Hi  I am using the group function to get the attributes related to the group  group(<groupId>, <property>) I am using this in an interface used on my site.  But what I have come to notice is when logging into my site as a basic user, there seems to be an issue where in the user has insufficient privileges for group() function  Can anyone please help me in this ?  Error Screenshot  

Hello I'm trying to get the task id from my read only grid with selection function of grids. I'm trying to store the task id in rule input, but what this is doing now is when I select one row it's storing all task id's in the rule input not only the single which I have selected and it's not updating the selection in the UI it's refreshing and the selection is gone. And when I load the interface by default it's showing 1 selected.I want to be able to select one row pick the task id store it in rule input and show in the UI that the row is selected, then the same if I select another one save the task id and update UI if something is unselected remove that value from the rule input and update the UI.pageSize: 20, selectable: true, selectionValue: local!report.data[1]["c19"], selectionSaveInto: a!save( saveInto: ri!test, value: local!report.data["c19"] ), showSelectionCount: "ON", rowHeader: 1

Hello,  I am having trouble getting validations to show up using a multiple dropdown component. When I pass in "Show Validation" for validations, nothing is shown on the component. When I do this for a dropdown component, it works as expected: My message is displayed with red text underneath the component. How can I show validations underneath the multiple dropdown component? Thank you, Nicholas

Is there any way to get the list of all the process model ids in an application.

Hi Everyone, I'm currently working on a group of applications that represent different departments of the same company. We've  also implemented a Landing Page for unifying the access to a single link. The challenge I'm facing is a request to be able to return to the Landing Page from each department site. Since for each department we're using different Site objects, it's not possible to have a 'Home' on the top ribbon that allows to return to Landing Page. We can return to the interface but the other pages/page groups remain visible and the request is to have them hidden. Obviously we can create a custom link or button somewhere in the site to allow the users to return to landing page but I haven't found any good front end ideas to do this in an organic manner. By the way, the users don't prefer the icon that shows the different sites on the top right, they even requested it's removal but I don't think that's possible.  Thi

Hi, I have a word template in which Signature is a field.  I am capturing all the fields of this template in an Appian form.  I am capturing signature using signature field, I am using the XML functionality to populate the fields in the word template.  I am able to populate all the fields, but how can I populate the signature which is stored as a document in Appian.  Can you please help me? Thanks

Hello Team, Here i'm trying to display record data in read-only grid. Interface Definition: Expression evaluation error at function a!gridField [line 2]: An error occurred while retrieving the data for "MS Typology". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. Can someone suggest what steps would i need to take

I have a grid  where i implemented custom check box,  a!gridrowLayout { contents:{ a!richTextDisplayField( label:"", labelPosition: "COLLAPSED", value: { a!richTextIcon( icon: "square-o", link: a!dynamicLink( saveInto: { a!save({local!selectedIndex},fv!index), a!save(local!selectedrows, append(local!selectedrows,fv!item)) } ), linkStyle: "STANDALONE", showWhen:{if(and(local!editProcedures,tointeger(local!selectedIndex) <> fv!index),true,false)}, color: "SECONDARY", size: "MEDIUM" ), a!richTextIcon( icon: "check-square-o-alt", link: a!dynamicLink( saveInto: { a!save(local!selectedIndex,null), a!save(local!selectedrow, remove(local!selectedrow,wherecontains(fv!item[ recordtype!fields.id],local!selectedProcedure[recordtype!.feilds.id))), } ), have drop downs and text fields below  } Now , if i edit the row and select teh check box, it saves the updated value from the row to local!selectedrow, bu

Hi  When i am trying to access one particular interface in dashboard options getting the error like below could you please suggest on it  Error: Error Evaluating UI Expression Expression evaluation error [evaluation ID = f4ac9:0c850] in rule 'amd_pendingtaskgrid' (called by rules 'amd_dashboard' > 'amd_dashboard_requests') : Rule 'CS_joinassigneearray' has 1 parameters, but instead passed 5 parameters. a!gridTextColumn( label: "Assigned To", field: "c23", data: if( local!datasubset.totalCount = 0, {}, apply( rule!CS_joinAssigneeArray, local!datasubset.data.c23 ) ), alignment: "LEFT" ), code in rule!CS_joinAssigneeArray: joinarray(rule!CS_getTaskOwnersNames(ri!assignees)," | ") in data local variable we are getting process report in that one particular column called Assigned to details we are getting and passing that to rule available in apply condition. Tried checking in process report in

for the text field need to give validation, when user enters the value along with text,number,special character then need to show the validation like  only alpha/letters but how can i show this, text field will allow alpha numeric and special character as well

ValidationGroup is not working as expected, when applied against a file component. It is validating entire form and not restricted to fileUpload component only.  Requirement: When user clicks on "Upload File" button it should only validate file specific validations. PS: I did try setting Validate: false for button component. But it did not work.  Thanks for help in advance a!fileUploadField( labelPosition: "COLLAPSED", target: tofolder(ri!appianFolderId), instructions: "Please click on ''Upload File'' button to upload the file in system", validationGroup: "UPLOAD_VALIDATE", validations: { if( and( a!isNotNullOrEmpty(fv!files.extension), contains(cons!VALID_FILE_EXTENSIONS, upper(fv!files.extension)) ), "", "File extension is not supported" ), if( fv!files.size > cons!FILE_SIZE, "Attachment file size is more than 10 MB", "", ), }, value: ri!uploadedDocument, saveInto: { ri!uploadedDocument }, maxSelections: 1, ), a!buttonArrayLayout( buttons: { a!buttonWidget( l

What is the best way to study for the Appian development process models section ot the exam.  I have score very low in this section of the exam,  Thank you for your help.

I want to update a specific row in my recordtype with data in one of the columns as follows:  Here I am using my id (the primary key of the table) to specify which row I wish to update, in this case i want to update case number 80 and update the casestatus column with "accepted", however upon doing so I get the following error:  I am guessing that my syntax is incorrect, but I can't seem to figure out what I am doing wrong exactly.