Discussion Categories

I need some help to create an expression rule to check if my given time is within the range. For example, my process model will start running today at 6PM then should stop running at 5AM the next day. Now I need to create a validation where it returns true/false to check if the execution time is still within the range. Hope anyone could help me. Thank you.

I am trying to add JSON object inside a JSON object but the generated JSON is not in the correct format. The child json is in double quotes.  How can I get rid of these double quotes? Can someone help me with a correct substitute() function command?

Hello everyone, I wanted to share a little advice with you, and hopefully, maybe Appian will also take note and resolve what an abysmal design decision is.Problem Statement:Appian has created the teardown method as a step that runs in the feature file. This is a terrible design. The reason it's a bad design is that the teardown method is what closes the browser and also kills the background Chrome/Firefox driver process. Since it's being invoked as a feature step, this means that if your test fails, the teardown step/method will not be reached. In addition, if you end a test early, it will not be called. The implication of this is that you end up with lots of browsers you have to close manually, and even worse, every time it happens, you have a driver process running in your PC/Mac background, and the more times you do it, the more they add up, eating away at your memory until you have to reboot your PC/Mac. I will show a screenshot of the step I am referring to.  Sol

I need the ability to sort an array of a Record Type similar to how for an array of dictionaries or CDTs you can use a!dataSubset() with the correct paging info.  I tried that with an array of record type and with the correct paging info using the record syntax.  It did not error out when called like todatasubset().  It just returned exactly what I passed in. Requerying the the database using a!queryRecordType() is not an option.  Until a form is submitted, I have to continue manipulating what's in local variables.  Because of the sheer size of the input fields and the quantities of fields, I can not use either a!gridField() or a!gridLayout().  I am looping through using a!forEach() in a card layout.  Removing and re-inserting back into the array is what I am doing for certain user sort functionality.  But, it's more efficient to then resort for all the remainder sub and sub-sub elements in the array. I prefer not having to cast

I have a grid with dynamic column names and static columns. Ex :  Here EmpSub's will varies on each instance.Need the word document format to get the dynamic columns syntax in word document. Able to get the rows data from the CreateDictinoary function but need the exact format to write in the word document. Thanks in Advance.

Hey Everyone,Not a technical issue just a question about the folder sizes in Appian. When I'm looking at folder I can see it has a size of 48.2 GB. But when I open it to see what is inside of it there are only a few items, where the size doesn't reach anywhere close to the stated 48.2 GB.

Hi techie,  I'm getting following error while using writeToMultipleDataStoreEntities.  Input Parameters - Entity - cons!DSE,Data - Record Type_______________________________________________________________ While I'm using writeToDataStoreEntity with same parameters  then I'm not getting any error.

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 ?

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