Discussion Categories

Actually I am having editable grid which is shown below .. contains components  dropdown and  file upload field and Text Field  I want to preload the required values of dropdown , when user opens the page he should see the grid with selected dropdown values. as shown below  all other functionality of grid will work as it is .. like removing adding new row .. please find the code-snipet attached (in the snipet Local!required Documents .. is just an id label we are storing in lookupref Table  so we can get from there) local!selectedDocuments: if( a!isNullOrEmpty(local!data), { 'recordType!{e5935b72-2349-43df-bd15-908d316468be}PRO Lead Documents'() }, local!data ), local!requiredDocuments:{198,199,191,193}, a!gridLayout( label: "", headerCells: { a!gridLayoutHeaderCell(label: "Document Type"), a!gridLayoutHeaderCell(label: "Document"), a!gridLayoutHeaderC

Hi all, I'm trying to see what is the best way to assign a minimum character number for a text component in a interface?

HttpResponse statusLine: "HTTP/1.1 200 OK" statusCode: 200 headers: Dictionary Date: "Thu, 07 Sep 2023 12:24:23 GMT" Content-Type: "application/json" Content-Length: "317" Connection: "keep-alive" Server: "Apache" Access-Control-Allow-Origin: "*" Access-Control-Allow-Headers: "origin, x-requested-with, accept, content-type, Authorization" Access-Control-Max-Age: "3628800" Access-Control-Allow-Methods: "GET, PUT, POST, DELETE, OPTIONS" contentType: "application/json" body: "{ "Apttus__APTS_Agreement__c" : { "success" : "false", "errors" : { "message" : "Upsert Agreement Failure:\n\nError Status Code: INVALID_FIELD;\nError Message: OBJ: Apttus__APTS_Agreement__c - Foreign key external ID: CO-UK-977-6935 not found for field Name in entity Protocol__c\n" } } }" Hello All,  We are getting this above error while sending data to third party system using POST MENTHOD. What mi

Hi  I want to create an interface in which a user can click on a button which will open the editable child interface and the edited values can later will be saved into the parent interface. how can i achieve this.

Hello! I am trying to figure out the best way to manage the Breadcrumbs Pattern, but I can't seem to grasp the way it is intended to be used. { a!localVariables( local!currentNodeId: 4, /* This variable would normally be retrieved with a rule like rule!getBreadcrumbsForIdentifier(identifier: local!currentNodeId). */ local!nodes: a!forEach( items: enumerate(local!currentNodeId) + 1, expression: choose( fv!item, a!map(name: "Home", identifier: 1), a!map(name: "My Documents", identifier: 2), a!map(name: "Strategy", identifier: 3), a!map(name: "2018 Road Map", identifier: 4) ) ), { a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!forEach( items: local!nodes, expression: if( fv!isLast, a!richTextItem(text: fv!item.name, style: "STRONG"), { a!richTextItem( text: fv!

Hii ,  I want to add value but getting erroe like - Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = PBWBF] : An error occurred while executing a save: Expression evaluation error at function 'todecimal' [line 285]: Could not cast from Record Field to Number (Decimal). Details: CastInvalid how can i resolve ? here is my code - a!localVariables( local!application: rule!GAI_getApplication(applicationId: ri!appId).data, local!grantorProjectActivityEval: ri!grantorProjectActivityEval, local!yaProgTypeId: cast( typeof(5), ( index( rule!GAI_getRefProgramType(programTypeAlias: "YA").data, 'recordType!{9d188bef-069b-4767-9d00-29432411f0cc}GAI Ref Program Type.fields.{4c3d4dd0-1f33-4086-9aee-27a44d619e83}programTypeId', null ) ) ), local!refGrantorProjActivities: rule!GAI_getRefGrantorProjectActivity(fkProgramTypeId: local!yaProgTypeId, ).data, local!metricTotal:rule!GAI_Add

I want to execute store procedure as soon as i called the rule and in this store procedure i am trying to update some of the field on the basis of conditions. At the very first time it is working perfectly fine but after 4-5 minutes something wired is happening. It is updating all the rows data and not considering the condition which we have written in the procedure. Example: SQL query which we are executing: "update projectProject set isEditMode = 1, isEditCurrentUser = @currentUser, isEditTimeStamp = GETDATE() where IDprojectProject = @projectId " 2nd time it is not considering the where condition and updating all the project. I know it is already been written that executeStoredProcedureForQuery function could run more than once, do not use it with stored procedures that modify data to avoid unintentional changes but i am not able to find any other solution. Below is the code which i am using in rule. a!localVariables( local!data: a!executeStoredProcedureFo

Hi! I´m trying to do the following query with the "query database" smart service: UPDATE CPF_LINEAS_PEDIDOSET FACTURADA = true where ID_PEDIDO = ac!pedido and MATERIAL = ac!Material The variable ac!Material can be multiple (f.example Material 1, Material 2). This is because in a previous step in the process model, the user can enter several rows. Because of using a list of string in the clause "WHERE" (I´m using it as a filter), I think I´m returning the following error: How can I fix this? Thanks a lot!

Hi, In the process model I am not able to get all data as the output. To replicate the issue please find below details The process details Could you please help me in this

Hi! I have created a process model in which the user can add new rows.  I´m saving the value of the different materials (pv!Record....material) in a process Variable ("MaterialesDefi") In this pick, you can see the value adquired and saved in the process variable. In this case: zz;vv The fact is that I want to use this materials in a WHERE clause (SQL syntax),and it is not working. Even though I tried to use a function like SUBSTITUTE() when assigning the value, trying to substitute the ; for the ",", the result of the pv is always the same I know that to use it in a where clause, I must use the operator "in" and also the string should be (string1,string2). But I haven´t managed to do so, the value of the pv! remains like untouchable What can I do?

Hi! I have made a process in which my Invoice Lines (Record 1) are set with the status "Billed" in the end, after passing multiple logics. Now, I would like to query the Purchase Order Lines (Record 2) from my process model and set their status to "Billed" too. In this case, I have to apply the following conditions: 1) The Purchase Order ID is the same as the used in my process  2) The materials of the Order Lines are the same as the ones created in the process I have been trying with the query database smart service (update-set-where) but it gives me problems when trying to filter by a more than one string (materials) How can I afford this "update" in my process? Which smart services do you recommend me to use?

I need to make a gridLayout with several fields per row, in which the row number is what I indicate with a local variable, so that when saving in a rule input I can update what is already in it with what I add to the call the interface for the second time initialized again so that it does not show what is already there.I thought I could use the id of the GridRowLayout to identify each row, but it doesn't take it, and starts the rows at id = 1.Has something similar happened to anyone?

I have a process variable of map type and i am getting data like below array.How can i cast this to map.{id=1, Name=,class=12, sub=, }

What are the features that can be obtained to use Appian in the cloud and "on premise"? My company is partner. Thank you.

An email is send by the client to appian mailbox, Appian needs to autodetect and pickup the attachement from the mailbox automatically. with the attachements as a input we have to triggered  the process where input is the attcahements of mailbox. is it possible to autodetect an new email with the attachment from the mailbox? in case if it auto detected, how to trigger an appian process with the attachment as the input?

We have requirement where we need to pull data from one of the table(Not Relational Database and it is Big Data environment)  to our schema or application. Data will be off appx 90 columns and 15+ column may have defined length of 4000 Char. And At a time it will provide 250+ rows.  We need to pull this data via Appian without doing Databasse to database integration though We just need to dump this data into our schema and landing table. I am thinking it may have impact on performance of the enviroment or Time out with API call but want to understand if any solution can be done via web API or any other way.

Hi! I have created the following editable grid: Appart from the fields shown in the editable grid, I would like to create for each row a CONCAT() from two fields (idPedido, Material), BUT NOT SHOW IT IN THE EDITABLE GRID, only saving it into my local variable  I´ve tried with the following code but when I try to add a new row an error appears: fv!item not detected (line 189). Is my approach of trying to save it in the append correct? In case it is correct, how can I fix the code and the fv!item? If not, which is the best way to save it in the local variable or another way? Thanks a lot! a!localVariables( local!LineasPedido: {}, { a!sectionLayout( label: "LÃ%ADneas Pedido", labelIcon: "list-alt-solid", contents: { a!gridLayout( label: "A continuación, incorpore las lÃ%ADneas de pedido correspondientes y pulse el botón de creación", headerCells: { a!gridLayoutHeaderCell(label: "Linea Pedido"), a!

Hello, I need to configure a schedular which should run Monthly on first Monday. I'm not getting what to configure in month field. Please can anyone help me. Thank you.

Hi! I have an editable grid in which the user can add new rows. I have a problem with the field "Clave Única". Its value is the concat() function of other two fields of each row 1) It appears correctly written in the editable grid  2) It seems not to be flowing correctly to my local variable What can I do to fix this? Is my code wrong? My code is below (line 60 is where I configure the value and saveInto for the field): a!localVariables( local!LineasPedido: {}, { a!sectionLayout( label: "LÃ%ADneas Pedido", labelIcon: "list-alt-solid", contents: { a!gridLayout( label: "A continuación, incorpore las lÃ%ADneas de pedido correspondientes y pulse el botón de creación", headerCells: { a!gridLayoutHeaderCell(label: "Linea Pedido"), a!gridLayoutHeaderCell(label: "Pedido"), a!gridLayoutHeaderCell(label: "Proveedor"), a!gridLayoutHeaderCell(label: "Material"),

How to append time constant to today's date so that I can compare it with now() which is of datetime type?

We have created a Webapi , that will be invoked by external system every 10mins to get data from our application. is there any way to check how much resources it is consuming and see whether it is impacting any performance.

Hi All, I created a process report and one of the column definition is a record field(pv!record.orderNumber)  and am not able to see it in report. When i check in documentation, I could see as below But when i try to query using a!queryProcessAnalystics, the field is still showing blank for me. Am i missing anything? Thanks in advance!

Hello, I want to implement schedular in start node which will run Monthly on 1st Monday. How to implement it and want value should be passed to month field. Thank you.

I have a rule rule expression which returns a datasubset in which the data has repeating rows. Since the data is coming from a view in mysql backend, I want to handle this in appian by getting only unique rows and remove all duplicate rows while still maintaining the paging. The data should be unique for 'stateroomRequestId'. I have tried using union but it does not work with datasubsets and only data a!queryEntity( entity: cons!BUS_ENTITY_REQUEST_VIEW_DETAILS, fetchtotalcount: ri!fetchtotalcount, query: a!query( selection: if( rule!APN_isEmpty(ri!selection), null, a!querySelection( columns: a!forEach( items: ri!selection, expression: a!queryColumn( field: fv!item ) ) ) ), aggregation: ri!aggregation, logicalexpression: a!queryLogicalExpression( operator: "AND", logicalexpressions: ri!logicalexpressions, filters: { ri!filters }, ignorefi

Hello team, I tried to set up user input task reassignment via escalation following this logic: 1. I have a User Input task which is assigned to a group called "Processors". 2. The escalation is set up as recurring every 1 hour     2.1 If the user input task was not accepted by anyone from processors group members nothing will happen     2.2 If the user input task was accepted (owner is not null) then the timer will fire and in 5 minutes it will reassign the task back to processors queue I have set it up following way, but when the timer conditions are not met, the task is paused by exception and nobody is able to access it. Any advice there please? Thanks Timer conditions, where if the owner is not null it will return true(), if it is null (so not accepted) it will return false(). c10 represents the Owner column pv!contract.contracId is the identificator for the specific task not( rule!GBL_isBlankOrEmpty( index( a!queryProcessAnalytics(