Discussion Categories

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

Hi, we need to configure VPN Tunnel for a new Cloud Environment. Client ask us if IKE use Aggresive Mode. We check, but we didn't find any information in documentation about it Could you help us? Thanks

Hi All,There is a requirement in my application to display a form (process) by clicking on the link from external system (Google chat). Initially once form is ready a link will be sent to the users(on Google chat), Then users can click on the same link and form should be loaded.Please suggest the better way to do this.

user(pv!servicesDelivered.iss_analyst,"firstName")& " " & user(pv!servicesDelivered.iss_analyst,"lastName")Above is the code I have, simple user fuction to grab first and last name for user. Currently getting this error:  (Expression evaluation error at function 'user': Null argument not allowed) (Data Inputs)Any insight to why? Than you in advance! 

When I upload more than one files and then going to download thes files .only first file is downloading not all files are downloading. what sould I do so that all uploading files are able to downloaded................. code:--- a!localVariables( local!docData:rule!PM_getAttachmentDetailsByReqId(ri!requestId), local!docId:index(local!docData,"docId",null), local!attach:index(local!docData,"attachmentId",null),a!gridField( labelPosition: "COLLAPSED", emptyGridMessage: "No activity entries available", data: local!data,a!gridColumn( label:"Details", sortField:"details", value:a!richTextDisplayField( value:{ a!richTextItem( text:{ a!richTextItem( text:fv!row.details, showWhen:if( fv!row.action=cons!PM_TASK_NAMES[3], false, true ) ), a!richTextItem(text: "Download Attachement File :" , showWhen: fv!row.action=cons!PM_TASK_NAMES[3]), " ", a!richTextItem( text: a!richTextIcon( icon:"download" ), lin

i want to ask about editable grid that i have some problem with it 1- the first one is when upload the first document when upload another document it will duplicate the document again  2- how can bring the document id for the document that i uploaded , please answer quicly 

Hi, I have a case where we have nested cdts, I need to call integration only when nested cdt value changes,  Value referring like - ri!products[ri!index].loan.loanType inside this loan we have other fields also like payment source etc. applied refresh variable -  refreshvariable(value: rule!callIntegration(), refreshonreferencedVarChange: true), This value will be updated by dropdown selection, what is happening if i change another dropdown paymentSource, It is still calling integration. Kindly guide me why is this happening, how this can be resolved? Thanks in advance.

Hi all,I have the requirement to replicate certain services, with functionality and endpoint already defined. The problem is that when creating a web api it does not allow to use the character "/" to compose the URL, which makes it impossible for me to replicate certain URLs. For example: /add/vehicleI know I could use the "add-vehicle" variant, but it is imperative to keep the same structure for the other systems.Is there any possibility to do this in Appian? Thanks in advanced!