Discussion Categories

Hi All, We are using MariaDB. Is it mandatory to provide after keyword in alter table query while adding new column? We are moving from lower environment to higher environment. In lower environment, the columns are in a certain order and in higher environment, we are trying to add the columns in the last and not in the same way as lower environment. Eg: In lower env, table is like firstname, middlename, lastname. In higher environment, it will be like middlename, firstname, lastname. But both environment CDTs will be like firstname, middlename, lastname. Will these cause any issues??

Hi Team,I have a few doubts in start node triggers. My requirement is to trigger a process model when certain conditions are met. So, what we are doing is we created a interface for users to schedule the process when to occur. we storing the date & time in separate constants. Try 1: then in the process model start node trigger we added a time recurrence to daily and it's time to value from the time constant = pm!timezone and checking whether the date constant is today or not in timer conditions (advanced options) and delay to 0 mins. each time after the trigger the process model will update the date constant to future date. Issue: working for the first time only(while publishing) after the constant update its not working.Try 2: process model will trigger daily at 00:00 , a xor to check whether its today or not, and a script task with scheduler (delay until the datetime mentioned in the constant). Issue: if the user sets the schedule to 06:00 but trigger star

i want an interface as "TEST 1 APPROVAL" with  fields name, section and class with cancel,approve and reject button .once we approve another interface with same fields must display with title "Test 2 approval" 

Hi All, If somebody has worked on Jira integration, Let me know if we can get the data based on list of project ids.(if i pass single project id it is returning the data).Solution i Have :- i can use a!foreach in order get whole data

Hello techies,  I need to use the merge() function on a dynamic list but it isn't proving easy.  Please check the following code snippet and suggest applying it on the dynamic list local!a.b a!localVariables( local!a: { { a: 1, b: { 1, 2, 3 } }, { a: 2, b: { "asdf", 5, 6 } }, { a: 1, b: { 7, 8 } } }, { merge({ 1, 2, 3 }, { "asdf", 5, 6 }, { 7, 8 }), /*working*/ merge(local!a.b[1], local!a.b[2], local!a.b[3]), /*not working*/ merge(a!forEach(local!a.b, fv!item)) /*incorrect result*/ })

We have a record type hooked up to a table.  Adding new records works well.  But, there is an issue with record edits.  The record gets updated in DB, but the auto record sync following the record update fails.  Here is data from error email: Problem: An error occurred in executing an Activity Class. Details: Unable to sync due to a system failure. Recommended Action: Examine the activity class to correct the error and then resume. Here is some relevant data from tomcat-stdOut.log: [http-nio-8080-exec-734] ERROR com.appiancorp.record.service.RecordReplicaUpdateService - Loading updates to synced record type(s) in ADS failed, invalidated record type(s): ...com.appiancorp.suiteapi.common.exceptions.AppianException: Unable to sync due to a system failure. (APNX-1-4521-016)...Caused by: com.appian.data.client.AdsUserInputException: APNX-3-1000-030: Invalid transaction data. Cannot update the same entity multiple times in the same transaction. Invalid id(s): ... Note: E

In my "Request " CDT  , i have a field named "branch" of type number.  I am trying to display the branch ID  on the interface , from the query "GetRequestData".  value: rule!GetRequestData(ri!documentID).branch, ri!documentID holds the ID of the request.  when I test the query it returns the data correctly, but on the interface it doesn't show. when i debug the process model it shows ((Cannot index property 'branch' of type String into type List of Variant))  i don't quite understand the error message. how can i display it correctly ?    

a!localVariables( local!selectedPermission, local!selectedArea, local!selectedComponent, local!selectedDepartment, local!departments: a!refreshVariable( value: rule!MECMS_getDepartmentList(activeFilter: true), refreshOnVarChange: { ri!refreshInt } ), local!area: a!refreshVariable( value: if( rule!APN_isBlank(local!selectedPermission), null, rule!MECMS_getRefArea( selections: {"id", "value"}, permissionId: local!selectedPermission, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1) ).data ), refreshOnVarChange: { ri!refreshInt } ), local!component: a!refreshVariable( value: rule!MECMS_getRefComponent( selections: {"id", "value", "areaId"}, areaId: if( a!isNotNullOrEmpty(local!selectedArea), local!selectedArea, if( rule!APN_isEmpty(local!area), -1, local!area.id ) ), pagingInfo: a!pagingInfo( startIn

Hi All, Second error: Appian environment went down and became very slow. From Appian admin we received the tomcat.std logs: 2022-11-22 03:00:07,489 [RecordSyncScheduler_Worker-1] ERROR com.appiancorp.core.expr.portable.storage.StorageDoubleTimestamp - Incorrect type (java.sql.Date) for DateTime variable (2022-06-08). Expected Type: java.sql.Timestamp. Auto-correcting to "2022-06-08 00:00:00.0" 2022-11-22 03:00:07,489 [RecordSyncScheduler_Worker-1] ERROR com.appiancorp.core.expr.portable.storage.StorageDoubleTimestamp - Incorrect type (java.sql.Date) for DateTime variable (2022-06-15). Expected Type: java.sql.Timestamp. Auto-correcting to "2022-06-15 00:00:00.0" 2022-11-22 03:00:11,412 [RecordSyncScheduler_Worker-1] INFO com.appiancorp.record.service.quartz.LoggingTriggerListener - Trigger [group: record_load_group, name: 2] completed for job [group: record_load_group, name: 2] 2022-11-22 04:00:00,708 [RecordSyncScheduler_Worker-2] INFO com.appiancorp.record.service.quartz.LoggingTrig

I have created a PM to get Json data, next I have created a webApiPost Start Process, I have tested the request, status code:200, after filling the body {} with json data, is passed to a process variable. But the purpose is to store all the data with mutliple table, through one CDT.

How I know what are the new objects come in Appian 23.3 and 23.2 versions  Please share me docs.appian.com page link for new release of 23.3 and 23.2 versions

Using integrations, I am retrieving outlook emails, but only receiving 255 characters rather than the whole body. Is there any way to get the whole email body?

I'm a newbie to Appian, looking for the documentation on initial steps for creating the promote-to-production landscape.  )This is assuming an "enterprise application" architecture (think: multiple users creating POs and then a Purchasing Dept. making buys), and not a mobile app architecture where we have to deploy an applet to multiple devices.) I have found the documentation on "Deployments" and "Packages," but not the precursor documentation on how to set up the landscape, declare where Dev is and where Test is and where Prod is, how to add a Training environment into the landscape if desired, how to set up Primary Dev and HotFix Dev, etc., such that a Deployment can move applications and objects from a Source to Target. Tried searching on "landscape" but that took me to portrait-vs-landscape in document orientation.  Other ideas on what search terms to use, or can anyone point me directly to the documentation?

I have "requestID" as a foreign key in 2 tables "attachment" and "Document"  i passed it as process variable through a task script. When i debug the process it works but it saves the foreign key "Null".  what might be the reason? 

Hello, Having two environments (PAM and PRO, both on cloud), I want to copy the database schema from PRO to PAM under the name "Appian_pro". After that, on PAM environment, I want to delete the "Appian" schema and rename the copied schema as "Appian", all of this to operate with Pro data on PAM.Would be possible to perform these steps? Thank you in advance. Regards

Hello,  Does anyone know if it is possible to make a related action visible or not depending on the user?.Because I want only the user who performed the action to be able to edit it again, this is my table Thank you very much

Hello, I have been struggling with an issue for almost 2 days so far. I have an integration in a process that is triggered by a web API. I am repeating this integration up to 5 times the response was not successful. In the case where the response of the integration is successful in the first time, I am getting back the required response that is a json format that I am indexing from a process variable. In the case where the integration is repeated twice or more, the response I am getting back is empty as if the process variable was returned as a null value. The response i am indexing is the variable where I am saving the httpresponse from the integration. So again, if integration goes through from the first time, the response is filled, if it goes through on the second time or more, the response is empty as if the web API only considered the first value saved in the variable where i am saving the httpresponse and it's not updating it; and when i check the process variable

Hi, please archive? thank you!

Hello  How to pass the Values of the local variables to the Docx????   a!localVariables( local!data:ri!DocData, local!name:rule!SKJ_GetCustomerByAcc(AccountNum:ri!Number), local!resonDes:ri!resDes, /*to collect the data*/ concat( /*Parent */ "", /*Name*/ "", local!name['recordType!{a0871cca-bd3d-4d03-b9ce-d1652bfa9dc0}SKJ Customer.fields.{b06eb39c-bf2f-4bb4-b283-cdbb894e406d}name'], "", /*Reson Des*/ "", local!resonDes, "", "", datetext(now(),"yyyy/MM/dd"), "", /*for each*/ a!forEach( items: local!data, expression: "" ), "", ), )

Hi, Please suggest some links or videos where i can learn how to create Suite page, test page and what is significant. how to maintain test scripts  for an applicaton. Thank you in Advance.

Does Appian SAML SSO work with http (not https) IDP requests. Is it mandatory to have all the systems running under https rather than http to be compatible with saml SSO? What is the rule?

Hello: I am trying to use a!writeRecords() to write a list of records (of the same recordType) to the DB and it is writing a column of one-field to each field in the DB (images below).  The debugging section shows the values before I click on 'Submit'.  The second image is the data in the DB (Data Preview screen). My understanding was that a!writeRecords smart service would insert two records - one for each row of information.  Obviously, I am not correct in my understanding of the service.   How do I get each row to be written as a record in the DB? As always, thanks for the help! a!localVariables( local!userSelection: null(), local!ListOfOptions: rule!FST_getGuidelines(), local!ListOfChoiceValues: enumerate(length(local!ListOfOptions)) + 1, local!ListOfCategories: {}, a!formLayout( label: "Category Management", contents: { rule!FST_UserSelection( ListOfOptions: local!ListOfOptions, ListOfChoiceValues: local

a!localVariables( local!maxData: a!queryEntity( entity: cons!ISP_DSE_CAPACITY_CONFIG, query: a!query( aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "startDate", isGrouping: FALSE, aggregationFunction: "MAX" ), a!queryAggregationColumn(field: "distCenter", isGrouping: true), } ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "distCenter", operator: "=", value: ri!dc, applyWhen: a!isNotNullOrEmpty(ri!dc) ) }, ignoreFiltersWithEmptyValues: true ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 50) ), fetchTotalCount: false ).data, local!date: tostring(index(local!maxData, "startDate", null)), a!queryEntity( entity: cons!ISP_DSE_CAPACITY_CONFIG, query: a!query( filter: { a!queryFilter( field: "startDate", operator: "=", value: local!date, applyWhen: a!isNotNullOrEmpty(local!date) ), a!queryFilter( field: &q

Hello team, I have a requirement where in the from there is a section where user need to fill order details (item, price, quantity). I need to provide an option to user to fill these details manually (this part is done) or by using an excel template. The tool should be able to read the content of the excel and fill it in the form before submitting the form itself. I know there is an excel plugin to read content but if I understand it correctly it can be read only after submitting the form. Is there a way how i can enable for the user to lead data form excel without levaing the form (staying on the same screen)? Thanks for nay answer

Hi when the process hits the Post comment to feed entry smart service it was errored out saying like below: An error occurred while trying to post a command or hazard to feed(entry id(1.840,280) Details: The supply feed entry (1,840,280) is not accessible (APNX-1-4181-100)  Kindly just on this