-
Recently active
Hi I need to display multiple input integer fields within one integer field based on multiple dropdown selection means i have a multiple dropdown which has 11 options if i select one option from dropdown the input integer field related to that need to display likewise if i select three options from dropdown three input integer input field has to display. I have defined 11 integer field individually like below but need to know the best approach to define in one integer field please suggest on this contents: { a!integerField( label: "Organization Hierarchy", value: ri!selectedHierarchies, saveInto: ri!selectedHierarchies, showWhen:contains(tointeger(ri!impactedHierarchyList),1) ), a!integerField( label: "Location Hierarchy", value: ri!selectedHierarchies, saveInto: ri!selectedHierarchies, showWhen:contains(tointeger(ri!impactedHierarchyList),2) ), a!integerField( label: "Account Hierarchy", value: ri!selectedHierarchies, saveInto: ri!selectedHierarchies, sho
How can I populate the database with a single form on multiple dates field?Let's say I am creating a Vacation form and when an employee wants to apply for leave from 1st Jan till 5th Jan, they open the form select FROM and TO date, fill other form fields such as reason of leave, informed manager etc. Now when the employee hit submit I should see 5 entries on Database with 5 dates but the rest form details should be same.
I am getting error as below on calling Oracle's stored procedure using a!executeStoredProcedureForQuery. Stored procedure and expression are attached below. Help is much appreciated.
Hi Everyone, I am returning a cursor from Oracle SP, When using new executeStoredProcedureForQuery, i am getting "Invalid Column Type:2012" error. can see in "Appian Community", Updating ojdbc8.jar solved error, Please advise whether we can follow this solution for our Project.
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
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.