Discussion Categories

I am trying to pull the records from a reference table.  There are 4 records in the table. However, the expression rule is only pulling three records. There are no filters on the record type. The Expression Rule a!queryRecordType( recordType: 'recordType!PMSO REF VolunteerRequestStatus', fields: { 'recordType!PMSO REF VolunteerRequestStatus.fields.VolunteerStatus_id', 'recordType!PMSO REF VolunteerRequestStatus.fields.VolunteerStatus' }, filters: { a!queryFilter( field: 'recordType!PMSO REF VolunteerRequestStatus.fields.isActive', operator: "=", value: true ) }, pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 10, sort: a!sortInfo( field: 'recordType!PMSO REF VolunteerRequestStatus.fields.sortBy', ascending: true() ) )).data

Hi All, Currently we are able to configure custom DL email ID (eg: testmail.com) in tomcat server for Appian process alerts (Appian process alerts which we will receive when process got failed or error).But how to configure Subject (eg: PROD) in tomcat server, so that if any Appian process fails or error we will receive process alert with Subject displaying PROD. This will helpful to identify the Production environment process alerts. Please let us know if more details needed. Regards,Sandeep

Hi Team, I have designed an interface which has 1 Rule Input  Now on the UI I am calling an integration and getting data from the integration The requirement here is to save the data coming from the integration to rule input  but without clicking any buttons. i.e. there are no buttons in the interface (if there were buttons I could have used the saveInto parameter of it)  Is there any alternative way to save the data to my RI ?

I want to check specific developers' changed objects based on date range, is there any way can do that?

Hii, I am getting this error while clicking on record Action: An error occurred while applying the context for the GAI Grant related action [identifier=253]. Details: The record data does not exist, has been deleted, or you do not have sufficient privileges to access it. How can i resolve this ? ), a!gridColumn( value: a!recordActionField( actions: a!recordActionItem( action: 'recordType!{8b4ab8ba-4c5b-4a6e-bf36-23ee7bb475b3}GAI Grant.actions.{4e3745c4-618f-44fe-a3de-3c29fd228894}editProjectObjective', identifier: { appId: ri!appId, projectObjectivesId: fv!row['recordType!{0b254c54-d92c-4674-a733-f9a9e4e2b147}GAI Application Project Objective.fields.{bd9fc329-44b3-4179-bd65-a400aee6091c}projectObjectivesId'] }

Hi team, Am working on an app which aims to updated external database(Mongo DB) and for this we are using Mongo DB connected system. Now we have a use case where we must update an existing collection entry with new details, and we are facing problem to update it correctly. Below is my collection structure.   Col A      Col B Col C [ {NestColC1A,     NestCol C1B,      NestColC1C}, {NestColC2A,     NestCol C2B,      NestColC2C}, ] Col D [ {NestColD1A,     NestCol D1B,      NestColD1C1[ {NestNestColD1C1A1,                    NestNestColD1C1B1,                      NestNestColD1C1C1}, {NestNestColD1C1A2,          &nb

Hi All I am working on version 23.3. My use case is to extract data from a PDF file; the data can be both hand written or system written. In case the content is system written; after few runs; the system is able to extract certain amount of data from the PDF (which is the expected behaviour from AI Document Extraction). However, if my input PDF document is hand written; no data gets extracted after multiple cycle runs as well. Can any one please guide as to how I can achieve data extraction from hand written document as well or what am I missing to achieve my goal. I am referring to the following link to achieve my goal (Note: Currently trying to capture PDF data in CDT; not in record for my POC): Create a Document Extraction AI Skill - Appian 23.3 Thanks in advance!!

Hello Everyone, I am working on a!gridField and need to select the rows which are of same status and other rows should be disabled(Non selectable). For Example : If I select any row with status :"Inprogress" then only inprogress rows should be selectable where other rows should be in disbaled.Later similarly if I select a row with Draft status then only draft status records should be selectable and other should be disabled. Please help me if anyone have worked this kind of requirement. Thanks in advance.

I have an interface created, It is an employee onboarding form, it is there on the website , so once an employee fills the form, the details gets stored to database table, now my database table is populated with the new employee detail. I have another tab, Update information if an employee needs to update information , so when an employee clicks on Update information it should automatically fetch my older details but is now, how can I make it hapen?

Good evening,Can anyone tell me if there is a method to handle all unknown exceptions during an execution of an automation flow? For example a Try and Catch error. Regards,Nicola

I've run into another problem I can't figure out during the Acceptance Testing portion of the Developer course. I've completed the "Configure Users" part and now I'm trying to load up the main site when logged in as Jodi Yeates. When I do, I get the following error: When I use this account to run the AIS (Appian Solution), everything runs properly. I've narrowed it down to something to do with the Assets record, but for the life of me, I can't figure out what is wrong. I've compared my Asset and Asset Type records, the Site file and the ITCentral interface with the solution and can't see any real differences. Can anyone point me in the right direction? I'm sure there's something I've missed or configured incorrectly, but I'm at a loss. Thank you, Carlo.

Hi, I have a rule in which I call an SP.I made changes to a field so that it accepts an array and now my Rule is not working.  I'm not getting an error, just nulls. Any idea?with( local!result: a!executeStoredProcedureForQuery( dataSource: cons!SOP_ARC_CONS_ALMACEN_DATOS, procedureName:"SOP_ARC_GETTOTAL_INFORMESLAS", inputs:{ a!storedProcedureInput( name: "STARTINDEX", value: if( isnull( ri!startIndex ), 0, ri!startIndex - 1 ) ), a!storedProcedureInput( name: "BATCHSIZE", value: if( isnull( ri!batchSize ), 100, ri!batchSize ) ), a!storedProcedureInput( name: "SORTBY", value: if( isnull( ri!sortBy ), "idinstancia", lower(ri!sortBy.field) ) ), a!storedProcedureInput( name: "ASCENDING", value: if( isnull( ri!sortBy ), true, tointeger(ri!sortBy.ascending) ) ), a!storedProcedureInput( name: "RESULTADOSMAXIMOS", value: cons!SOP_ARC_INFORMES_MAX_RESULTADO_PANTALLA_ONLINE[ri!codigoInforme] ), a!storedProcedureInpu

What's the best way to have a process report that filters for all processes that have hit the end node and its blue. Basically, this sub process was kicked off by a parent wrapper process. The parent would kick off this sub process, the user would go to the first interface, we had a timeout mechanic where if the user didnt take action within a set time, it expired and hit the end node. However, going to this end event did not end the parent process and now the process is staying open. We have since fixed this and made this End Event node a terminate node, but in our process dashboard now, theres 10,000+ processes that are stuck in active status because the node was not properly terminated and the parent process is keeping it alive. This is taking up memory in the system, and I want to try to identify all the processes where this happened so I can delete them. Is there also an easy to way mass delete these process models once I have a good report that only includes them? Our

Hii, I am unable to select NA option , for YES or NO Its  working fine , how can i resolve this,  i have to save a!radioButtonField( label: "", choiceLabels: { "Yes", "No", "N/A" }, choiceValues: { 1, 0, "NA" }, value: fv!item['recordType!{f42d5bd8-9c50-4910-b251-13ec6bf9fdb6}GAI App Review.fields.{899275d5-d9e3-4030-9291-883eaf45d2c6}reviewerAnswerBool'], saveInto: { local!a, a!save( fv!item['recordType!{f42d5bd8-9c50-4910-b251-13ec6bf9fdb6}GAI App Review.fields.{899275d5-d9e3-4030-9291-883eaf45d2c6}reviewerAnswerBool'], if(local!a = "NA", {}, local!a) ) }, this value in to boolean type column

I have created a Document Name filter for documents uploaded to the current application I'm working on. However, based on how documents are set up in Appian, I am only able to retrieve the document name through Appian's Document ID. I am using a!pickerFieldDocuments() to filter by documents, but the issue is that when I type in the document name it only pulls up results based on what the document name starts with. I would like the document name filter to use partial name searching instead so that instead of having to know what the document name starts with I can just type in any text included in the name to pull up the results. But I am finding this rather difficult to do using Appian's Document ID to retrieve the document's name property. Does anyone know how to resolve this? Thanks.

Hi, i am new to appian and intended to take exam (associate developer) exam on next week. I want to know that if Associate developer practice test help me? What topics i need to study more to pass the exam?

we use AQUAMAN and Peer review for our Appian packages before moving to production environment. how can we check components in package zip file for their performance related issues which are reported after they are deployed to Production? is there any way to add these rules in AQUAMAN? or any other plug in which can be used to PREVENT these issues in future releases?

Hi Champs, In one of the use case, we do need Case management and I see Appian comes up with it's Case Management framework ; but I am not sure how to use the same. Can anyone have use the same or any idea how to use it? Regards, Ghanashyam

Team, Do we have any cloud approved function which can provide constant using constant name ? Regards, Gaurav

Hi Community ,We have a requirement where we have to compare two lists of map , Both the Map have same values but these map are created from different query statement.I want those Keys where Values are different. For Eg : Map1 : [[id:230,no:0]; [id:223,no:1]; [id:232,no:1]; [id:264,no:1]]Map 2 :  [[id:230,no:1]; [id:223,no:2]; [id:232,no:1]; [id:264,no:1]] I need a expression rule which gives result as 230, 223 bcz Map 2 values are different in it. Many Thanks ! Regards,ASK

Hello Community Members, While using Export SQL to Excel Plugin, we are observing that it is over-riding existing file in same folder if file name is same instead of creating new file. Anyone observed this behavior before? Any workaround like changes in Parameter that may mitigate this. Keeping file name unique is alternative, but we have case where same file name can be present multiple times in same folder. So need to understand if it is the known plugin behavior and file name should always be unique if using this smart service "Export SQL to Excel"

Hello everyone, we have a new requirement to connect JDE integration I am not sure how to connect JDE from apian can anyone guide me please Thanks!

Good day everyone,  I am new to Appian and working on a project. I have a database with the following tables: Employees (1:M) Document Status (M:1) Training Document. I am trying to make a form that allows managers to assign each employee to multiple training documents at the same time. So, I have a form like below with a checklist of all training documents (fetched through an expression rule)  When the form submits, I need the process model to write to the database multiple times to the document status CDT. For example, based on the picture above, there would need to be three entries to DB tracking status for each training document and employee. How should I set up the interface and/or process models. Any advice/suggestion would be greatly helpful!  Best,  Harsha Gurram

Hi there, Is there any to convert word to pdf file? If yes, can we merge that pdf file with other pdf file? Thanks