Discussion Categories

Hi good day, I'm trying to create a download csv/excel file from a list of dictionary from my data.1st Step - Fetch Data from DSE2nd Step - Transform Fetched Data to Specific Dictionary (with Formula).3rd Step - Convert Transformed Data (Dictionary) to CSV/Excel Document.4th Step - Put Document in Document Download Link.Note: This is going to be perform in Interface.

calworkminutesplugin is working fine in expression rule. But when i call the expression rule from the process model getting the below error message. Expression evaluation error in rule 'xxxxx' at function 'calworkminutesplugin' [line xx: ) (Data Outputs) Any Suggestions Please.

After runnig the example test getting error

Hi, I ahve a gridField setup like shown below: (just a excerpt of full interface code) local!posiciones: a!forEach( local!posicionesBDI, { cod_descripcion: fv!item.cod_descripcion, estado: fv!item.des_estado, tecnologia: fv!item.des_tip_tinst, topologia: fv!item.des_conf_posicion, num_calle: fv!item.num_calle, juego_barras: fv!item.cod_matricula, afectada: if( a!isNullOrEmpty(ri!expCon), "-", if( contains(ri!expCon.codigo,tostring(fv!item.cod_descripcion)), "SI", "No" ) ) } ), a!gridField( label: if(isnull(ri!expCon),"Posiciones del parque afectado por el informe","Posiciones del parque afectado por el expediente"), data: local!posiciones, columns: { a!gridColumn( label: "Código", value: a!richTextDisplayField( value: a!richTextItem( text: fv!row.cod_descripcion, style: if(

Hi All I am using the plugin to import Excel to a database in Appian while importing data in to appian cloud database the null values are stored as empty strings. Many Thanks in advance

Hi Community, Is there a way to zero in to a task using the task URL..? The task URL looks something like this - /suite/rest/a/task/latest/nyRHm7PRCKoujsVRqz/form and I would like to understand specifically what task it corresponds to.

Hi, I have a Web API which has around 5830 characters. Since Web API has restriction to use only 4000 characters. So am planning to write codes in Expression Rule and call in web API. If i call Http!request in Expression Rule its throwing error. Can someone help me with example how to call expression rule in Web API.

a!forEach( items: ri!pdmDocuments, expression: a!update( ri!DocumentDetails, { 'recordType!PRO Lead Documents.fields.pdmDocumentId', 'recordType!PRO Lead Documents.fields.updatedBy', 'recordType!PRO Lead Documents.fields.updatedDt', }, { index(fv!item,'recordType!PDM Document.fields.documentId',{}),loggedInUser(),now()})), input ri!pdmDocument is {110407,110408}, input ri!DocumentDetails is  List of PRO Lead Documents - 2 itemsPRO Lead DocumentsleadId6699(Number (Integer))workItemId:31206(Number (Integer))createdBy:"test@scar.com"(Text)workItemFolderId:110429(Number (Integer))isActive:true(Boolean)updatedBy:"test@scar.com"(Text)documentId:110444(Number (Integer))documentName:"_Test_Contract_2_"(Text)updatedDt:9/14/2023 2:49 AM EDT(Date and Time)leadDocumentLookupRefId:278(Number (Integer))createdDt:9/14/2023 2:49 AM EDT(Date and Time)description:""(Text) PRO Lead Documents leadId:6699(Number (Integer))wor

Hi, I am getting huge amount of data and needs to write it in database. Its taking so much time  Have used  a!writeTodataStoreEntity(dataStoreEntity:cons!APM_DSE_VALUES, valueToStore: local!data) In local!data  am calling rule Can someone help me how to convert it in forEach loop or in batches. Please help with code

Hi is there any function as if i change the count to 2 in list item of 4 it should return only 2 items..as shown below this is list of record type ... now based on count i want to retrive items.. like if count is 2 it should give me first 2  list of record types shown below from 4 . List of PRO Lead Documents - 2 itemsPRO Lead DocumentsleadId6699(Number (Integer))workItemId:31206(Number (Integer))createdBy:"test@scar.com"(Text)workItemFolderId:110429(Number (Integer))isActive:true(Boolean)updatedBy:"test@scar.com"(Text)documentId:110444(Number (Integer))documentName:"_Test_Contract_2_"(Text)updatedDt:9/14/2023 2:49 AM EDT(Date and Time)leadDocumentLookupRefId:278(Number (Integer))createdDt:9/14/2023 2:49 AM EDT(Date and Time)description:""(Text) PRO Lead Documents leadId:6693(Number (Integer))workItemId:31206(Number (Integer))createdBy:"test@scar.com"(Text)workItemFolderId:110429(Number (Integer))isActive:true(Boolean)updatedB

Dear Forum users, How can we know the appian generated custom mobile application is compatible with which version of android and what is the Api level of the apk file.

Are there any way that the id of an instance of a process model can be reused? example when you delete instance, or across the different engines, or if my enviroment had a RollBack?We use those ids, as primary for a registar of one our tables.

I am trying to access changed ri variables from an interface of user input task. I am accessing it by using ac domain with the rule input name in the node output  and saving the ac variable to a new pv. But the new pv is coming as blank.  There is no button click in the userinput task. The userinput task is exited on exception flow. Is it possible to save the change rule input value back to a new process variable.

Hi! I have created an editable grid in which the user can add a quantity to the "Cantidad Recepcionada" field.  This value is saved in two records (Field: CantRecepAcum) After this, I wanted that, each time the user runs the process and saves a new quantity, the value is added to the previous existing value of the field "CantRecepAcum" In order to do this, I configured the following code in the interface (I save the value of fv!item in my rule input each time. Every time a user enters a value, there is a sum between the curren value of the ri! and the new value of fv!item, for the field "CPF_Lineas_Pedido_CantRecepAcum": In the interface, when I click the submit button, it is not acumulating OK (I´m going to try to explain. If I put 1,0 in the rows, both fields increment +1. If I continue with 1,0, its a +1 for each field too. But when I change and put 2,0, then the first field goes a +2 up and the second a +1. If I repeat then with 2,0,

Hi All, While uploading incorrect / corrupted Excel sheet, readexcelsheet() function itself failing. How to catch the expression evaluation error when readexcelsheet() function fail to read incorrect / corrupted Excel sheet? For your reference we have attached the screenshot: Regards,Sandeep

I want to use the toggle button (highlighted below) in my user interface - similar to that used in the Profile Settings --> Email notifications interface. Is this available anywhere or on the Appmarket? Thanks!

Hi, is it possible to have 2 eventlogs loaded and connected with each other in Process Mining? Following use case:  - eventlog A with activites for a customer order as case ID - eventlog B with activities for a customer shipment as case ID It is a 1:n relationship between customer order and customer shipments. I can analyse each eventlog seperatly but as they are connected in real life, is there a way to connect them within Process Mining and analyse them?  Thanks for a reply Himanshu

Hi All, I have one query related to time zone conversion. I have start and end date with EDT time zone, and i have to convert this date with given time zone like Mountain, Pacific, Eastern so on. Can any one help me with same. Thank you

I have create a table through records in DB, when I am trying to run a process model the primary key id is not generating in process where as the id value is getting stored in Records as well as in DB.

Hi All, I ma using the start process smart service in parent process model with activity chaining enabled in both parent and child process. The node start process smart service is taking long to execute. Can anyone please suggest how to reduce the time taken by the start process service. Thank you!

Hi, I have an requirement to trigger appian rpa based on email body content to download file

Hi, I am trying build read only selectable grid. a!localVariables( local!businessModuleStatus: rule!CR_QE_getModuleStatusForBusiness( cif_int: ri!cif_int, moduleId_int: ri!moduleId_int ), a!boxLayout( label: index( local!businessModuleStatus, "workflowDesc_txt", "" ), style: "ACCENT", contents: { a!gridLayout( spacing: "DENSE", headerCells: { a!forEach( items: cons!CR_MODULE_STATUS_GRID_FIELDS_FOR_BUSINESS, expression: a!gridLayoutHeaderCell( label: fv!item, align: "LEFT" ) ) }, columnConfigs: { a!gridLayoutColumnConfig( width: "DISTRIBUTE", weight: 2 ), a!gridLayoutColumnConfig( width: "DISTRIBUTE", weight: 2 ), a!gridLayoutColumnConfig( width: "DISTRIBUTE", weight: 2 ), a!gridLayoutColumnConfig( width: "DISTRIBUTE", weight: 2 ), a!gridLayoutColumnConfig( width: "DISTRIBUTE", weight: 2 ), a!gridLayoutColumnConfig( width: "DISTRIBUTE", weight: 2 ) }, rows: { a!forEach( items: l

I have a use use case, when any developer uploads their package in one interface  and that should go through the XML code and return if any objects in that package are using any deprecated functions. To achieve that , is there any function that would read the XML file

I have a page where the label I am dynamically passing from database. I have a dropdown menu with 3 values and I want to make sure when I select any of the values and click on submit, my selected value should be updated on the Page label. The problem I am currently facing is for every refresh I am able to see the update value and can't we make it possible without any page refresh??I already used refreshVariable but didn't work. Please let me know your inputs. Thanks.

I want to show record when task status not equal to  1,Completed 2.Rejected 3.Cancelled should I used or () , or  not() conditions. I think or() should apply because at a time only on status come in task status not all status come