Discussion Categories

Hi, I need to find out if a given date is in the last week of the month.  For example 27th of March 2023 is in the last week of the March month.  How can I achieve this?  Please give me the suggestions. Thanks and Regards, Brinda Sateesh

Hi All, I am facing issue in integration (soap request) while uploading large file size document. Error: Unable to process request body - The request body was greater than 5 MB and could not be processed. I tried with content type - text/xml, application/xml ,custom: application/soap+xml;  Third party system accepts only content type - text/xml and application/soap+xml I have also referred article - Integration Object - Appian 22.4   Can someone please help me on this? Thanks!

Hello everyone,We are trying to make sure SAML users, if idle, logout after 60 minutes. But for some reason the timeout is set to 20  minutes. After going through the documentation I have seen Admin console> Appian >session time out is suppose to fix it but it doesn't seem to work in my case. Any idea where to start?

I am trying to access Appian data from an external system. If I send a 'GET' request on the URL of the webapi with the appropriate endpoint, I run into Cross Origin Resource Sharing problems and the headers provided do not pass my pre-flight request. I wanted to know if there are any configuration changes in Appian's webAPI needed to do so that it responds to requests sent from the other system's URL ?

Does anyone know how to read the first line of a CSV? I have tried the readcsvlogpaging() function but it only works for files that are in the logs directory, and the readexcelsheetpaging() function does not work for CSV documents. Any ideas? Thanks!

How to add social media icons and when we click on it , it should direct to a particular page?

Hi, I have a process model where I am using writeToDataStoreEntity smart service to save the data into a database. I am using an interface in the start node.  If I hit a submit button, system is flashing "Action Completed" message automatically. Whereas when I implement same functionality in the SaveInto and a!writeToDataStoreEntity , system is not returning any such message after hitting a "Submit" button even though data getting saved. Can someone advise me how to show such a message "Action Completed" after submit button clicked.

I have a scenerio.The below mentioned example rule should repat based on the local variable local!a each input. localvariablesa( local!a: {"A","B","C"}, local!b : {"X","Y","Z"}, a!forEach(items: local!b, expression : rule!getTestData(input1 : ri!employee, input2 : local!a[1])[fvIndex], rule!getTestData(input1 : ri!employee, input2 : local!a[2])[fvIndex], . . . . rule!getTestData(input1 : ri!employee, input2 : local!a[n])[fvIndex], ) )

Hello: I am looking to convert an array of number to a single string with comma as the separator.  In 23.1, they have a function called a!joinarray which seems to be the function I want to use but I am on 22.4 CE.  So, the question is there a similar function that will enable me to accomplish this?   Thank you. Final desired result: 360392, 361150, 361177, 377913, 378165 

In the main interface we have a toggle icon, We the default value for this is null. When user clicked on that we are setting a local variable value as true. Below this toggle icon we have a link, When user clicked on that link it will initiate a process model using a!startprocesslink smart service. That process model has interface rule in the startform, when user perform some action on that screen and submit the form he will again land on the main interface rule. Now again this toggle value going back to the default value null. But, the requirement is to have that toggle value as true after user submit the form. Please suggest your thoughts on how to achieve this. Any help is greatly appreciated. I have attached screenshots, please refer them for more information. [View:/cfs-file/__key/communityserver-discussions-components-files/13/Issue_5F00_details.docx:320:240]

Is there upper limit on the number of related records fetched with dot operator on the parent record using record relationship? We see only10 records regardless of the total number of children records with one-to-many relationship.

I have a Class record type and a Student Record type with a relationship between them one-to-many.when I try to get a Class with all the students (every student contains classId) I get only 10 of them but I have much more.how can I fix it? a!queryRecordType( recordType: 'Class', fields: { 'Class.relationships.Student' }, filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'Class.Id', operator: "=", value: ri!id ) }, ignoreFiltersWithEmptyValues: true ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100 ) ).data[1]

Hello folks, in my current solution i use an expression rule which queries a View in DB and returns the data based on filter. The Contract Number is an array of Text type, so far as operator i used "in" which worked perfectly even with multiple values. Now there is a new requirement from the business that instead of using exact values they want to have something like contains ("includes" or "start with"). It works if i change the type from array to single value, but not working with array. Is there any way how to make this work even for array? I am getting the following error message while using array: a!queryEntity_22r2( fetchTotalCount: TRUE, entity: cons!ICH_ENTITY_ICH_V_ContractReferenceData, query: a!query( selection: if( rule!GBL_isBlankOrEmpty(ri!fields), null, a!querySelection( columns: a!forEach( items: ri!fields, expression: a!queryColumn(field: fv!item) ) ) ), logi

Hi All,  I am working on the Appian IDP application. I have trained it on some single-page documents, and it is perfectly working for single-page documents. Now, I have a document that consists of some text fields and a table. The table is starting from page 1 and going up to page 2, but for this document only the single page is getting extraction for the table. I am not able to select the table details from the next page. Can someone else also face this problem, and do we have any solutions for it? Thanks in advance.

Hi, I have a scheduled process that executes multiple SQL scripts.The final of these scripts recreates triggers dropped in the first script. Since triggers can't be created in a Stored Procedure; I am unable to use the Execute Stored Procedure smart service and, due to the scripts complexity, use the Query Database smart service. Is there another way this can be executed from the process model? Thanks

Hi All,  I am working on Appian IDP application.  I have trained some single paged documents and it is perfectly working for single paged documents.  Now, I have a document which consists of some text fields and a table, table is starting from page 1 and going up to 2 page, for this document only single page is getting selection for the table. I am not able to select the table details from the next page.  Can someone also face this problem and do we have any solution for this.  Thanks in Advance. 

HI, I have a scenario where am getting list of questions from the decision rule. i have to use that rule in expression rule to show all the question. could anyone help me with this

I have created a Record Type which is bound to a Connected System and an integration which fetches data from a REST endpoint (web service) with data sync enabled. I was able to create a record list to view the fetched records in a table. I am trying to add a custom record list action which adds an item to this record type and eventually update and delete actions as well. As per my understanding we have to create sync expressions in order for these actions to work. I am new to the platform and I am not finding enough resources to help me understand how to perform CRUD operations on a service backed record type. Need help in pointing me to the right tutorials/links which can shed some light on this. Thanks.

I'm trying to  extract  a  big amount of question from a  PDF file that has around 1000 pages  and the section  where we find all those questions. The program is doing it  we can run  the process an everiything is fine but suddenly  the appian server  shows the 503  error   even though we are not running the process i split the pdf  in  batches of 30 pages  every time a 30 page batch   is evalueated and the  questions are extracted we save the   questions found in this  variables and this sub process die and  go  to the main process  and do the same  thing till  we get to  have all the questions and sections   the  time for this process is about 10 minutes in doing all of this operations. how can we minimize the high load of the site ?  the Appian team told us that the aplication server was killed by their automation. After

In a pipeline : as an input I have a parquet file I'd like to do row by row of the parquet file (foreach ?): make a call to a soap xml api according to result call : = if ok store the result (xml file) in a blob container. = if not ok store the result in an azure storage table. I've already done such a thing with an azure webjob would it be makable (rather simply) with azure synapse analytics ?

Hi All, One of our old application was storing date time as TEXT format. Some of the values in DB for column called 'datetime TEXT" column are  5/15/2018 2:57 PM GMT-04:00 5/15/2018 2:57 PM GMT-05:00  3/12/2018 5:25 PM EDT 2/6/2018 1:48 PM EST Recently we are trying to add new column to store this value. Just say "dateTime" column with datetime type. On doing so we will be storing in datetime format for all new request after this update. But for older request the value will be in TEXT format as mentioned above. Can anyone suggest best way to convert and populate datetime for older request into the new column which i have created. dateTime(TEXT) dateTime 5/15/2018 2:57 PM GMT-04:00 ? old 5/15/2018 2:57 PM GMT-04:00 ? old 5/15/2018 2:57 PM GMT-04:00 ? old 10/18/2017 14:02 new 10/18/2017 14:02 new 10/18/2017 14:02 new

Hello, I'm using function a!recordData to return data from one of my records and I need to apply multiple filtering on the dataset: data: a!recordData( recordType: 'recordType!{a24eedc6-9d03-4ecc-affc-9d0a19c7cc0d}QUA Incident', filters: { a!queryFilter( field: 'recordType!{a24eedc6-9d03-4ecc-affc-9d0a19c7cc0d}QUA Incident.fields.{a1a9fdf7-1d9b-48eb-a147-2a233271d74b}adGroup', operator: "=", value: local!adGroup ), a!queryFilter( field: 'recordType!{a24eedc6-9d03-4ecc-affc-9d0a19c7cc0d}QUA Incident.fields.{3729b606-5b1b-4fb8-b16b-c9e929833ece}assignedTo', operator: "", value: loggedInUser() ) } ) When I use both filters, data is not appearing at all, If I remove the second condition I can see some results that are aligned with the first filter definition. However, If I use a!queryEntity function to retrieve the same data for the same entity I get 2 results ( the expected result). a!queryLogicalExpression( operator: "AND",

Hi Team, We are using SQLBackupAndFTP tool for taking backup of database in MariaDB (Appian). We have installed the tool while setting up, getting an error stating that Database is not detected. Please find the attached snippet for reference. Please help us here to fix the issue. Thanks in advance. Best Regards, Raj

Hi, Is there a way to limit the number of concurrent sessions for users authenticating against SAML IdP, specifically Azure? We've tried configuring the limit as described in https://docs.appian.com/suite/help/20.4/Appian_Administration_Console.html#account-locking but it seems it's only applicable for Appian-based authentication. Thanks

I have an expense CDT . It has fields like base charges, fuel charges, taxes. I have a pie chart and on each slice of a pie i need to display the sum of base charges, fuel charges and taxes for a vehicle . I am unable to use secondary grouping. Kindly please help.