Discussion Categories

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

Hi All, In our application,  there are slowness integration. Pls need solution

Hi All, I'm trying to move some documents from one folder to another by using a process model that runs once a day, I'm trying to use the Move Document smart service but it only lets you move one at a time. Can someone give me some feedback or alternatives? maybe I'm implementing it incorrectly thanks in advance

I am new to Appian. I cannot get the test result: :the cage field in the RPT_CAGE_Info variable contains the CAGE string returned by the robotic task   after finished the step "Add the Execute Robotic Task node" in the process model which is the step before "Add an XOR gateway" when following online training docs.appian.com/.../tutorial-retrieval-process.html .  I have checked all possible causes, but no idea. Your advices and suggestions how to debugging are very appreciated!  This is the result I got in PM history        

I am trying to explore the AI Skills option to extract a PDF document , While doing this I am using a!docExtractionStatus(pv!DocExtractionId)  to find the status of this extraction , it always comes as Invalid status  as i feel the id returns as text  459e03db-62f5-4a7c-bb96-9047e4391783 , Where as method used to find the extraction status looking for number how to change this  type and find the extraction status ? 

In case of record sync failure, I want specific people to be informed instead of all system admins.

Hi, We have a requirement to integrate a component that is based on a javascript library. The instructions given tell us to include into the consumer application page, an HTML script tag and a div tag with some specific attributes to setup the behaviour of the component.  As far as I know, there are no other way to get this kind of integration that build a plugin, ¿is that correct? I'm trying to establish the alternatives we have, I would like ti be sure I'm not forgetting some easy way behind. Thank you all

Hi all, We're on Appian 23.2 and have noticed an issue where when we have a disabled dropdown field, the dropdown list will appear if the user clicks the field and then enters a key stroke. See the screenshot below: Does this look like a bug with Appian or could it just be in our code? It's reproducible for all of our dropdown fields. The value doesn't get changed if you select one in the dropdown list but I don't think the list should be appearing. Thanks!

Hi All, We have observation from our VA testing team, that while uploading file it should not contain double extension like as shown below: FileUploadBypass.php%00.xlsx Currently Appian is allowing to upload the file in to application because of extension .xlsx but VA testing team suggested us to file name should not contain double extension. Any suggestions on this, how to validate this kind of observation? Regards,Sandeep

Hi! I would like to change the primary key in my record and use another field instead (the created field would be a concat() from other two fields). Even though I have been trying, I´m finding trouble when trying to change the condition of primary key and give it to another field. I don´t want this primary key to be AUTO-INCREMENT and, when I try to put another field as primary key, an error occurs. Is it possible to eliminate the primary key and convert the other one into a primary key? Otherwise, how can I solve this?

.

How I get download file name in interface

Hello everyone. I have tihis error message in a "Write Record": Unable to write to the source because the data source did not respond. Error Details: Field 'MortgageId' doesn't have a default value I understand the problem sems to be that 'MortgageId' has not value and the database is refusing my update, but I don't understand why, because when I open the process and watch the varibles, 'MortgageId' is filled: Indeed, I have other "Write Record" smart service that is doing something similar and, in that case, all work fine...

Hi everyone, Is there a way to track every time a task has been reassigned to another user with the user input task? Thank you

I disabled the reassign option in tasks, but the option still appears when starting the task. How can I hide that option for the user?

Hi Team,I have a requirement for creating an audit table in that i need compare the existing data and updated data and need to add only changed field values. for this 1st I'm querying the existing data in a local var, then after changing some fields in the UI, I'm performing a save into operation which involves a!foreach which compares the queried data & UI rule input fields so when there is a difference I'm appending one row for that changed field in audit record type rule input(array). but if there is no change I no need empty- row in audit table. but some how my code appending empty rows for fields with no changes. Kindly provide suggestion it'll be helpful.Thanks in advance here I didn't change anything in one field but it gets adding null value

I have an HttpResponse type pv holding following value: [statusLine=HTTP/1.1 500 Internal Server Error, statusCode=500, headers=[object Object], contentType=application/json, body={"type":""title":"Internal">www.w3.org/.../rfc2616-sec10.html","title":"Internal Server Error","status":500,"detail":"Error connecting to underlying system","instance":"XXXXX/error/uuid:XXXXxXXXXXXXXXX"}] I am passing it to and expression rule and indexing "body" into a local variable responseBody , which is wprking ok, However when I try to index any of the attributes within body , such as "title", "type","detail","status", Index is not working and returning default value. I am trying as follows: errorDescription: if(ri!success,"",if(a!isNullOrEmpty(local!responseBody),"",index(local!responseBody,"type",""))

Hi! I´m trying to make a query in order to update certain rows of a column in one Record (CPF_Lineas_Pedido) with the exact values of the columns of Record 2 (CPF_Lineas_Recepcion), where the variables "IdPedido" and "Material" are the ones used in the process Query: " UPDATE CPF_LINEAS_PEDIDO, CPF_LINEAS_RECEPCIONES_V3 SET CPF_LINEAS_PEDIDO.CANT_RECEP_ACUM =  CPF_LINEAS_RECEPCIONES_V3.CANTIDAD_RECEP WHERE CPF_LINEAS_PEDIDO.ID_PEDIDO = ac!pedido AND  CPF_LINEAS_PEDIDO.MATERIAL IN (SELECT material FROM CPF_LINEAS_RECEPCIONES_V3 WHERE ID_PEDIDO = ac!pedido) " The query changes the values of the desired rows of CPF_Lineas_Pedido,  but instead of picking the same value of the other table, it takes random values 1) I introduce the value of "Cantidad Recepcionada" for each Line, and the record is written 2) Database CPF_Lineas_Recepcion written (ok) 3) Database CPF_Lineas_Pedido written (not ok) How would you link this fie

Hi, I want to fetch email address of the user, based on first name and last name.