Discussion Categories

Requirement - Appian application has to fetch data from the external system and it has to be real time (If there is a change in the external system it should reflect immediately in Appian). How to handle this scenario? Do I need to schedule process model every 5 seconds or is there a way to monitor the changes in external system?

Dear Team, I am new comer to Appian have background of IBM BPM, Can you please guide where to find  inner exception details (log for this error) of a smart service ( Move to Collab). It is giving error  com.appiancorp.suiteapi.process.exceptions.SmartServiceException: java.lang.Exception: Invalid File Path: /webattachments/path/foldername//info@alwaha-qatar.com/qid20220327080031286QID_&_PP.pdf we are using to move files from file server to appian mount path but it is completed sometimes & gives above error some times.

I have three tables, SpeakerEvent, ParishEvent and a junction table that joins SpeakerEvent to ParishEvent, JNC_Speaker_Event_Parish_Event I need an Appian query that can tell me which SpeakerEvents have not been assigned to a Parish as well as another query that will tell me a Parish has not be assigned to a SpeakerEvent. If I were creating a view in SQL, this would be done easily with a left join and checking to see if the ParishEventId is null. SELECT SE.* FROM `PMSO_SPEAKER_EVENT` AS SE LEFT JOIN `PMSO_JNC_SPEAKER_EVENT_PARISH_EVENT` AS JSP ON SE.SPEAKER_EVENT_ID = JSP.SPEAKER_EVENT_ID WHERE JSP.PARISH_EVENT_ID IS NULL In Appian, I am trying to create an Expression Rule to do the same thing.  I tried several version of using a a!queryFilters as well as a!queryLogicalExpression.  I'm guessing that it has to do with the fact that there are no records on the other end of the relationship (JNC_Speaker_Event_Parish_Event). if( a!isnotNullOrEmpty(ri!speakerId), a!queryR

How am I supposed to on a addRowLink, add an empty document file to my list of documents files? The thing is: on a interface, the fileUploadField is working, but it doesn't work on the site addRowlink: a!dynamicLink( label: "Inserir novo documento", /*value: { id: null, doc: "", tipo: "", descricao: "" },*/ value: 'recordType!{1f7c4a8e-ee45-44c7-8872-dc5542133555}GC Documento Proposta'( 'recordType!{1f7c4a8e-ee45-44c7-8872-dc5542133555}GC Documento Proposta.fields.{9edd3c74-2a43-4d35-a34a-f15156e24008}nome': null ), saveInto: { a!save(ri!documents, append(ri!documents, "")), a!save(ri!record, append(ri!record, save!value)), } ), rowHeader: 1, )

Is there an easy way to switch tabs from process to monitoring, or split the tabs? It's so struggling to be clicking all the time

Hi guys, I am trying to delete old active process instances by using a send/receive message event. This is the parent process which fetches old instance ids and sends the message to those active instances Here i have defined a process uuid property which captures the uuid of the process model In the receive message event, I have applied the condition if the uuid matches the specific value The issue i have is the messages are sent successfully, however it's not being received because of the condition. It worked fine when I used the processModelId property. Since it changes in every environment, i want to use uuid. What am I doing wrong in this configuration?

I'm trying to get the list of the custom data types that uses date and time field in it, from the whole application. Kindly post your suggestions, Thank you.

How can we get 1st index elements of each array in different new array. Like{2,13,65}{7,15,45}{14,3,56}So output of 1st elements should be {2,7,14}And for 2nd and 3rd {13,15,3}{65,45,56}

Hi All, We have installed Appian on Kubernetes, but the current file upload size limit is 1MB. Could you please advise on how to increase this default upload file size? Thanks in advance.

I have a record type called "Case", and it has a field called "assignee". I also have an interface, in the interface, I have a grid field that show all cases, with multi-selection enabled a dropdown field allow user choose an assignee a button, called "Assign Selected Cases in Batch", after user multi-select cases and select assignee from dropdown, allow user to click this button to assign multiple cases to 1 assignee in 1 click To do so, I created: a batch assignment process model (works perfectly) In the interface, I declared: a refresh counter called local!caseDataRefreshCounter, initialize with 0 local!cases, as a refresh variable, with refreshOnVarChange set to local!caseDataRefreshCounter, and it is corresponding to the "data" field under my a!gridField the button widget implementation of "Assign Selected Cases in Batch" is a!buttonWidget( label: "Assign Selected Cases in Batch", saveInto

I have in my Record Types two fields, Created By and Modified By.  Both of those data types are set to user.   They are also linked to the Appian User. I have a Process Model kicked off by a Portal.  I would like to get the initiator of the process to be saved into one of these two fields.  I have used: pp!initiator - From the Process Properties pv!processUser - This is a process variable of User type that I created by saving the pp!initiator to pv!processUser touser(pp!initiator) touser{pv!processUser) "PMSO_ServiceAccount) - the text value of the portal User Name for Service Account.  I verified that the User Name does indeed exist and is the account that runs the portal. touser("PMSO_ServiceAccount") In all of these cases, I got the process error (Could not cast from User to User. Details: CastInvalid) (Data Outputs)!!!  This works in all other areas of the application, just not in the process model kicked off by the Portal.

Hi people, I have requirement where i need to find the X path of an XML file. We have functions to retrieve a value using the X path. But our requirement is retrieve the X path instead of the value, So that the user will use that and cross verify the xml file whether its matching. Here is an example. Input: <Document> <customer> <details> <name>xyz</name> <address>abc</address> <contact> <phone>45667778</phone> <employee> <company> <department> <id>6786</id> </department> </company> </employee> </contact></details> </customer></Document> Output: for Retrieving the name XYZ this would be the X path "<Document><customer><details><name>" this is actual output we require And this is the output we need for nested X path. "<Document><customer><details> <contact><employee><company><depa

I want to add a certain number of zero to the left of an integer number and save it to an Integer rule input..I was using text(value,"0000") this function which gave me exact format but when I save that to an Integer variable , all zeros had been removed. Id type is Number(Integer)for ref:  { a!textField( label: "Text", labelPosition: "ABOVE", value: text(tostring(ri!Id), "0000"), saveInto: ri!Id, refreshAfter: "UNFOCUS", validations: {} ), a!buttonArrayLayout( buttons: { a!buttonWidget(label: "save", style: "OUTLINE") }, align: "START", marginBelow: "NONE" )}

Hi Community, I'm working in a project where data ingestion is very important and we get data from csv files. The problem I have at the moment is that with the plug in ps-plugin-ExcelTools in particular with the smart service Import CSV to Database I need to set the charset input (e.g UTF-8 default or UTF-16). Due to the fact that I could receive files in both encoding format, the question is: Is there any solution to get the encoding of a file?  I find a solution saving the document in Base64 into Db and analyzing the string obtained. Does anyone have a smarter solution? Thx in Advance. Bye bye

Is there an easy way to smoothly switch from a asynchronous subprocess to a star process?? I'm getting the following message: "Subprocess node is set to run asynchronously and is either used in a loop or configured to run MNI..." i hope really there is a way to do that with just a few clicks, if there isn't, then there goes a suggestion

I am in need of creating a basic data entry interface where it is just one text box where the user can input and item number, hit tab, writes to a record , clears out and they are ready for the next item.  Looking for very minimal screen navigation. Thoughts?

Hi! I have 2 related tables that I have access to BUT do not own. Let's say the 2 tables are Recruiters and Members.Recruiters has an interface showing recruiter records. This is the entry point of the portal.I want to have a column in the Recruiter interface that holds links to the Members interface. The Members interface must show records in the Members table depending on the value of multiple columns of the recruiter row clicked.Take note that I do not control any of the 2 tables so I cannot make the "blessed way" of using those columns to build a composite primary key. I need a way to pass those column values to query and filter the records in Members table and display them in Members interface.How do I structure this UX / logic in "idiomatic" Appian?

I have a record configured to sync data with an on-premise table using a 'SQL Server Data Source' connected system to connect to the database. Due to changing requirements, I’ve disabled the scheduled sync in the record type and deactivated the user ID on the SQL Server to prevent data fetching. However, I still see authentication requests to the server, which I believe are from the connected system object. Is there a way to disable the connected system without deleting it?

I'm setting up an embedded interface using my local Appian installation as well as a local web application running on a local tomcat server. When accessing my web app I am prompted to log into my Appian account as expected but after providing credentials I get and error to enable cookies. I made sure my chrome settings were set to allow third-party cookies and tried again with the same error. Does anybody know what I need to configure to get past this error?

I'm trying to change the color of the validation in dateField(), but I'm not sure if we can do it. Does any one know if it can be done? Thank you.

{ a!localVariables( local!data: a!recordData( recordType: 'recordType!{bdbacce6-755b-4a52-ab85-3ea4b00c7bfd}VWHIAP_DD_REVIEW_STG', filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!{bdbacce6-755b-4a52-ab85-3ea4b00c7bfd}VWHIAP_DD_REVIEW_STG.fields.{1ce64732-409c-43eb-ad89-865ecbd09000}CURRENT_REVIEW_STAGE', operator: "=", value: "Initial Review" ) }, ignoreFiltersWithEmptyValues: true ), fields: { 'recordType!{bdbacce6-755b-4a52-ab85-3ea4b00c7bfd}VWHIAP_DD_REVIEW_STG.fields.{6aa0c857-afe2-486b-bdeb-6a01ff3ed63f}id', 'recordType!{bdbacce6-755b-4a52-ab85-3ea4b00c7bfd}VWHIAP_DD_REVIEW_STG.fields.{ef25fa56-4caa-4eed-bafa-10a295456244}LOAN_ID', 'recordType!{bdbacce6-755b-4a52-ab85-3ea4b00c7bfd}VWHIAP_DD_REVIEW_STG.fields.{1ce64732-409c-43eb-ad89-865ecbd09000}CURRENT_REVIEW_STAGE', 'recordTyp

Hi , I want to know the character limit that the Appian Private AI (GEN AI) - Document Extraction. I've uploaded a document with table value of 43 rows. But in the response , I can get only 30 rows as incomplete. I have altered the prompt also, but its not the problem. I've searched about the character limit of Extraction , But couldn't able to find it ..  Can anyone help me with this matter?

Hi, I am using Appian's Execute Gen AI Skill smart service for unstructured document extraction. I want the document extraction ID similar to what I have in the Document Extraction Smart service. Is it possible to obtain the document extraction ID in this case?

As title says are there any way to check who has deleted the version of specific process model, or is there any way to prevent users from deleting the process model version?

Hello I have a template that I have created where one sheet is "protected" so that it can only be edited with a password. When I use the "Copy Document" smart service, that protection remains in the copy. However, when I use the Export Data Store Entity to Excel smart service, the protection goes away. Is there any way to keep this protection or some other way to make a sheet read-only within Excel upon completion of the Export Smart Service? Thanks