Discussion Categories

Hi I need to find out if a particular date which is stored in record type is from the previous month.  For example today in September I'm finding that 7th of August 2023 date (Already present in record type) is from August month.  How can I achieve this?  Please give me the suggestions. Thanks.

Hello! I need to know if it's posible to use a dynamicLink with the space bar or only can be used with the enter key? Thanks

Hi everyone, On a process instance, I'm trying to Write on Data Store Entity a string value with the following characters: Ω μs. But instead, I have the following error: "javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement: org.hibernate.exception.SQLGrammarException: could not execute statement: java.sql.SQLSyntaxErrorException: (conn=364712) Incorrect string value: '\xF0\x9D\x9B\xBA\x0A ...' " The field where I'm trying to store the value is varchar(4000), in Appian's database cloud mariadb.

Hi! I have created an editable grid with data of a record. To store the data, I created a local variable whose value is obtained by querying the record (local!DatosLineas)  Now, I would like to configure two things: 1) By now, the values of the grid are saved in the SAME RECORD (to which I executed the query). I want to show the values of the previous Record (CPF_Lineas_Pedido) but I would like to save the values in another record (f.e. CPF_Lineas_Recepciones). How can I do this? 2) I would like to add a new column, which must show no info (empty) and be filled in manually by the user. I want this values to be saved in the same new record as the point 1) (CPF_Lineas_Recepciones) ¿How can I add a new empty column to my local variable or to the grid? I have doubts because it is something "apart" from the query, independent. And I want the values to be saved in another record.  My code is below: a!localVariables( /*mirar para incluir colum

Hi All, How to validate an email address for users which are in same organization. If I am working in a abc organization and I want to validate that if users is not a part of an abc organization should show me invalid email address in textfield object in appian and if it is a valid user of that organization doesn't show me an error. Example: 1. hdhdh@abc.com 2. xyz@abc.com 3. adrfer@abc.com From above examples that users who is a part of abc organization then in textfield show me invalid email address. So my point is in one organization I need to validate users if it is valid no error should show in interface if it is not valid user then show me an error. Please guide me how to achieve these in a!textfield() function under appian 22.2 version?

Hello, I have an issue with the card choice layout. Consider the following code: a!cardChoiceField( label: "What's the number of possible answers?", labelPosition: "ABOVE", data: { a!map( id: 2, icon: "dice-two", primaryText: "2", secondaryText: "Two" ), a!map( id: 4, icon: "dice-four", primaryText: "4", secondaryText: "Four" ) }, cardTemplate: if( rule!UNI_FN_getPageWidth() = 1, a!cardTemplateBarTextJustified( id: fv!data.id, primaryText: fv!data.primaryText, secondaryText: fv!data.secondaryText, icon: fv!data.icon

Please find the below screenshot of dropdown, in this dropdown we have few values (ex: "a","b","c","Other"). Whenever I select "Other" option in the initial time it is allowing me to Save. but after Save, whenever I'm trying to Select second time in different dropdown as "Other" option then it is throwing below error. Can anyone please help me with this?   Error: Interface Definition: Expression evaluation error at function a!forEach [line 521]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!dropdownField [line 622]: A dropdown component [label=""] has an invalid value for "choiceValues". Duplicate items are not allowed in the choiceValues array, but choiceValues was [id=, name=Casing & Cementing, point=1, fluidPoints=1; 1; 1; 1]; [id=, name=HSE & Environmental, point=1, fluidPoints=1; 1; 1; 1]; [id=, name=Logistics, point=1, fluidPoints=1; 1;

How I make link for any page of my project . These are below  interfaces . I am in MyRequest page. How i visit to  last "Task " interface page from MyRequest page Work.....My new work.....My  task.....Task . "Work interface" is parent interface then "My new Work" is inside  the Work interface.Then "My task" interface is inside the "My new work" then Last "Task interface " inside "My Task" interface Ther are not in Records....

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!