Discussion Categories

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. 

hi! I´m trying to update a field of a record with new data (stored in local variable in my interface and passed correctly as a rule input) Even though the values are correctly saved, when I use the write records smart service it duplicates the rows and stores the value, with the rest of fields in null I just want to update that field of my record, not to create new entries. Should I use the a!update function? How and where can I configure it in my code? My interface code is the following: a!localVariables( local!DatosLineas: a!queryRecordType( recordType: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido', fields: { 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{fcfa4b36-4398-4430-8055-ecfa59daf13a}idLineaPedido','recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{71427dbb-12db-4f83-bd99-f625bf9af271}idPedido', 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{69e

Hi, my client wants the search box and the filter style of a common Record Type. We implemented a gridfield with a!recordData as "data", but with time, it became very slow. I would like to implement the pagination, but with the a!recordData is not possible. Even, I tried to use the a!queryRecordType() and it works fine (it's very fast!) but in this way, we lose the possibility of having the checkbox and the user filters and the Excel export button, and so on... Does anyone know how to help me? I already tried to maximize the performance of the record type with default filters, but I don't know how to face this issue. Thank you to whom will help me!

Hi I have an issue where process task instance was active at backend but in front end the task was not visible to the user  here in above screenshot in place of refresh task should come but it was coming in front end. Kindly provide if any suggestions on this

Hello everyone, I'm trying to figure out if it's possible to retain the data selection I make in an interface that I invoke in a dialog when I close and reopen the dialog. I had found an Appian plugin that handles these activities with cookies or something similar, but I can't seem to find it again. Can anyone help me? Thank you very much.

in googleComboChartField() is it possible to show drill down data grid below...,  up on selection on report

Hello, For storing date and time for (dateTime type variable) in record I'm using now() function. But in record type its format is like : 9/10/2023 12:50 PM GMT+05:30 and in database it is of this format : 2023-09-10 08:06:33.100000. I want in record type and database should have same format like this : 9/10/2023 12:50 PM GMT+05:30.  As I'm using stored procedure to get data between two dates, but I'm passing the date format as 9/10/2023 12:50 PM GMT+05:30 and in database it is in this format 2023-09-10 08:06:33.100000, so not getting the data after executing stored procedure. Thank you.

Hi Team, I am given a task to create users in Production. There is an account already existing in Production which I have to use as a mirror account. The mirror account is a part of lot of groups, and I have to enter these users in each of them. Is there an easier way to do this? Since it is production environment, I cannot use any smart service directly without approval from higher mgmt.  Any help is appreciated. Thanks, Ritika