Discussion Categories

Is there default behavior for when a user refreshes a page in the middle of a process within an interface?

Hi All, I am getting the below error at write to multiple data story entities node ( Note ISRJMeetingAdhocReviewer --This is not a new table ) An error occurred while trying to write to the data store [ISR Data Store].  No values have been written. Details: org.hibernate.PropertyValueException: not-null property references a null or transient value : ISRJMeetingAdhocReviewerDT8605.studyRequestId (APNX-1-4208-004) Thanks in advance

Hi, Our requirement is to store the choice value selections from Multiple dropdown with choices from a record type into a separate join table rather than semi colon separated. We are using 23.3 version and the application is built on top of record types instead of CDT's and configured the records using many to many relationship between main & join tables.  Problem here is the choice value selection neither deleting nor updating in the join table, it's always keep inserting as a new values in the join table every time when we reselect the choice selection.  Is there a way to handle this issue to delete  or update the unselected choice selection?.

I am sending a POST request via an integration, and this endpoint requires that a JWS (signature of the body) is sent in a header. This is similar to a JWT, except that what is signed is the body of the POST rather than the claims included in the token. In our instance, I see the plugin functions for creating JWTs, but none of them seem to have the ability to create a JWS. Any ideas on this one or will I have to create my own function plugin?

Hi team,                         has anyone implemented the PKI integration with appian for SSO purpose. Or AADHAR integration. Appreciate your response here.

Hi Folks, I want to provide OOTB export functionality of record in my interface; but seems like there is limitation in grid, we can only use it if data is sourced from record.  I am getting my record data by using a!queryRecordType instead of a!recordData as a!recorddata doesn't have parameters for grouping.  Is there any easy way to achieve the same instead of again creating a view and using as DSE and doing export functionality separately as we were doing earlier. Regards, Ghanashyam

Hi Everyone, I want implement a validation on file upload field, whenever user uploads a CSV file system will validate and check whether the CSV file uploaded is in correct format or not ? if file is not in correct format system will give the error "File is not in correct format"

Weird thing happened, I have a if() function if(    my condition,     value when true,    remove(local!myList, wherecontains(cons!code, local!myList.code)) ) when I take the remove() out of if(), it's result is a list of 4 items, but in if(), it's result is a list of 1 item And I tried with wherecontains(), when it's a standalone out of if(), the result is List of Number (Integer) - 0 items, but in if() the result became  But why would this remove 3 items from myList?

Hi All, We are facing one issue while fetching data having few filters. For e.g., the filters like to_date, fund etc are working fine but the moment we select from Date, it throws error. And surprisingly when I am selecting from_date after selecting any other filter, it is working fine.

Is there any way or function  to display or get the total list or the count of application in the environment. I need it for the report page in UGMA. Also the recent activity of loggedInuser over time or something like that.

I have this array {100, 50, 20,50,10} and a variable x = 600, I need help to create a rule that creates an array with the results that must be calculated in this way: The first value of the array must be subtracted with the variable x, the result must be subtracted with the second value of the array, the previous result must be subtracted with the third position and so on. The results must be stored in an array. At the moment I have this code but it does not work correctly a!localVariables( local!regularizaciones: {100, 50, 20,50,10}, local!initialValue: 600, local!resultArray: {local!initialValue}, a!forEach( items: a!forEach( items: local!array, expression: fv!item ), expression: a!localVariables( local!currentValue: fv!item, local!lastResult: index(local!resultArray, length(local!resultArray)), local!newResult: local!lastResult - local!currentValue, local!resultArray: append(local!resultArray, local!newResult) ) ), local!resultArray ) I appreciate any help

Appian delivers process automation powered by enterprise AI. We help organizations connect their customers, partners, and employees in end-to-end processes on a single, secure, platform. This release, Appian 24.3, welcomes new updates to the Appian Platform for process automation, data fabric, enterprise AI, and more. Join our team of Appian experts as they dig into highlights from the release. Tune in to see Appian 24.3 in action and ask the experts your questions. Turn on notifications to make sure you don't miss it! 

i have a paragraph field and initailly i want to show only first 255 characters, i want to add a button like show more/ show less

Hi, I used fileUpload component in mobile to upload a photo. But when viewed using imageField, the picture gets rotated in wrong orientation. Is there a way forward to fix it?

Hi Folks, I am showing the data in a grid format in the dashboard page and the request id in that grid is a link which is navigating to the record summary page. I am providing record action in summary page for user to take some action which is being opened in a dialog box. Now when user submit the dialog box, the process running in the background and once completed, the user is coming in the summary dashboard. Now the client wants, when user submit that record action, instead of landing in the record summary page, then want to land into the dashboard page. Is it feasible? Regards, Ghanashyam

How to test expression rules with rule inputs having more than 4000 characters?

Hi Champ, I have a map variable and the same is used in the table. So I can see it was coded as todatasubset to the map variable with a local defined pagination variable. It's working fine if the map is having less no of rows then pagination ;but getting errorrdout when it's having more rows..message says like "batc size was 0 but te largest column data array had 12 items." So FYI: We are not using datasubset rather using todatasubset. Regards, Ghanashyam

Hi, I have a requirement where I am querying a process report to check if an active process exist. If there is an active process which means a task was created and based on that the UI is made read-only. I have to query the process report continuously to check if the task is created until the process is triggered. The UI is editable but as soon as the task is created the UI becomes read-only(by querying process report for active instance). Once its in read-only the query should not happen to check the process report. EX: local!editReportdata: a!refreshVariable( value: index( rule!getActiveInstances( pagingInfo: a!pagingInfo(1, 1), workflow: ri!workflow ), "data", {} ), refreshAlways: true() ), local!isInstanceActive:a!isNotNullOrEmpty(local!editReportdata) Here, once local!isInstanceActive is true it should remain true even though local!editReportData becomes null. if local!isInstanceActive is false it should keep on checking until it gets true(). Or the variable local!

Hi I would like to remove the selected record from the Custom Picker. But the below code throws error. In code labels and identifiers are same as i need only name. Code Snippet: a!localVariables( local!selIndex, local!selItem, local!selectedRecord:rule!ACRA_GetExistingInfo(), local!currentRecords:a!refreshVariable( value:if(a!isNullOrEmpty(ri!selectedProducts), null(), ri!selectedProducts), refreshOnReferencedVarChange: true ), local!recordLabels: a!refreshVariable( value:if(a!isNullOrEmpty(local!currentRecords), local!selectedRecord.proposedName, remove(local!selectedRecord, tointeger(wherecontains( touniformstring(local!currentRecords.proposedName), touniformstring(local!selectedRecord.proposedName) ))).proposedName ), refreshOnReferencedVarChange: true ), /*local!recordLabels:local!selectedRecord.proposedName,*/ local!newRow:'type!{urn:com:appian:types:ACRA}ACRA_ProposedNamesInfo'(), local!products:'type!{urn:com:appian:types:ACRA}ACRA_ProposedNamesInfo'(), a!

Hi There, When I use the cardLyout Component, add the link property to it. I use the showBorder property to hide the border, but when mouse hover it, there will be border line, I want to know how to hide the hover border Thanks

How to call word file(docx) into an image component? I tried to call it but for some reason it's not displaying it properly, Please help!!

hi,  my selection check boxes in editable grid not saving the values and upon page load it shows all boxes selected by default  requirement: I wanted to save both Index and the row upon selection. Please help.

hi,  I have an editable grid with 35 rows of data ( 5 columns editable), I have a requirement that given , if I edit something in any row , it should get saved in the database but shouldn't use any selection check box , there is only one button, that should save all the rows that are edited at one click  I wanted to save only the rows that are edited . Each row has a primary key.Any idea or code samples will help

Hi everyone,I need to control the font size in an email whose body is generated by an expression rule that generates the corresponding html. The problem is that the font size that I specify in the html does not correspond to what the email finally has. For exmaple, this HTML <p style='font-size: 14px;'> Hola, la solicitud se ha completado y puede generarse el acuerdo en Vistex (adjunto fichero de carga)<p> should be 14 px. However in the emali the font-size is 10.5px.

Hello All, We need to calculate number of hours between two date and time values. and this should not consider weekends. Thanks in advance