-
Recently active
Hi Experts, I have create one stored Procedure in DB . Which have two IN Parameters (StartDate , EndDate). How to use procedure to receive data in the interface and how to pass these IN parameters? a!localVariables( local!orderCountData:( a!executeStoredProcedureOnSave( dataSource: "CDM2 Primary Database(Connected System)", procedureName:"SP_OrderTypeCount", inputs: { a!storedProcedureInput(name: "StartDate", value:""), a!storedProcedureInput(name: "EndDate", value: ""), }, timeout: 30, onSuccess: { }, )), local!orderCountData ) Thanks
Hi All,Yesterday i went throught the new feature of appian case management studio, that is an great functionality that appian providing right now including a case workspace, case, entity, task records, configurable workflows, conditional tasking, workflow visualization, auditing and reporting, and so much more.But i want to know more regarding this is anyone have any idea about this what is atually the use of this in atual senerios,
Hello, I am trying to view my appian test environment on a tablet like device so I can showcase some of our items but am receiving an error after the log in page that says "Error 401 - Unauthorized. Sorry, your request could not be processed" Logging in on my phone works so im not sure why it wouldn't work on this tablet like device. The device runs an android framework. Any help would be appreciated
Hi All, We have a new project coming up, it is expected to have almost around 600,000 records being created in a year. We have one existing application with let's say around 100,000 records using entity backed synced record. My concern here is that existing application performs very slow with 100,000 records and most of the times export to excel fails also with 20,000 records to be exported now if we talk about 600,000 cases I am not 100% sure to use Appian OOB records. I know we can create different records based on the personas and default source filters to make it work but what if customer wants to see all the records? What could be the alternative approaches to deal with this? Thanks!
Hi Team, I want to export local grid data to excel based on the selected filters. find the Grid Data in local variable.
When selecting one or more groups, I want to display the members of those selected groups in a grid column. Thank you!! .a!localVariables( local!selectedGroup: ri!initialGroup, local!distinctUsers: if( a!isNullOrEmpty(local!selectedGroup), "Please select a group", getdistinctusers({local!selectedGroup}), ), local!groupName:a!forEach( items: local!selectedGroup, expression: getgroupnames(fv!item) ), local!pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 10 ), { a!sectionLayout( label: "User & Group Management", contents: { a!pickerFieldGroups( label: "Pick Groups", labelPosition: "ABOVE", maxSelections: 5, value: ri!initialGroup, saveInto: ri!initialGroup, ) } ), a!sectionLayout( label: "Group members", contents: { a!gridField( label: "", labelPosition: "ABOVE", columns: {
After upgrading from version 20.2 to 22.4, we have observed an issue related to the task display name in the browser tab. Specifically, when tasks are linked in an activity chaining(sequential manner), the task display name does not update when transitioning from one task to the next upon completion. It is important to note that this functionality was working correctly in version 20.2.
Hi, I am new to Appian and working on a Prototype for a client. I have a use case to upload a set of files to a folder that is created for each new client and then view these uploaded documents in document viewer for review. Can someone provide some help to do this please?
An error occurred while evaluating expression: =repeat(count(pv!ordersId), pv!invoice.id) (Expression evaluation error at function 'repeat': Cannot repeat list type) (Data Inputs) so I having many to many relationship names as invoice to ordersId so while mapping data into CDT using repeat function I am getting this above error I want to store 2,1 orderIds within same invoice
Hi All, Recently, We have one requirment where in Appian, Is there is any plugin to video Communication between the Appian account.
Hello All, My requirement is that in a chat we need to show the conversation. This conversations is shown in a card layout with height as MEDIUM. When there are too many conversations, card layout is showing the scroll. Below conversation card layout, we have a text box and a send button. Once user clicks the send button then the user text is appended in the conversation card layout which makes the layout to re-evaluate itself and the first conversation is shown. To see the latest, we need to scroll below. Is there any way to fixed the position of scroll bar if the text is appended in the card layout? Regards Arka
Hi all, we have a record based on a view in an oracle database. Some day ago we delete some data from the tables from which the view get the data and now the view has 253 rows, but if I open the record list we found 11583 rows. How is it possibile? With this scenario the record should execute the query every time we open it
HI All, We need to read a formatted text file and then convert it to Excel sheet with headers and data. We need to create a single row for each supplier details in excel sheet along with the data per headers. Has anyone got such a requirement? Can you please suggest a way? Sample file is below see attachment/cfs-file/__key/communityserver-discussions-components-files/11/ExpenseReport.txt
Hi Everyone! Recently, we have one requirment, once the claim is submitted by the customer in the Appian portal. we need to generate and send a link to the respective customer via SMS/Whats app. In this, the link is an unauthorized link where customer click the link and acknowledge the form. In the form we need to display all the information in the readonly format and customer will go thorugh the form and acknowledge it. Once customer acknowledge the form, in appian we need to update the status. Is this possible in Appian? Thanks in advane
Hi everyone! I am facing the following issue: I have a toggle button that activates a startProcess!, which is a Process Model designed to update the dates of a list of tasks. This list can contain more than 100 tasks which should be analyzed one by one in an iterative loop in the process model. However, I have noticed that the onSuccess variable, which should be displayed in a grid is not correct . This problem might be due to exceeding the 50-node limit. I have checked the process, and everything appears to be correct including the onSucess variable. Can you advise me on any way to retrieve this variable with the correct values?
Hi I am trying to display file preview for attached documents. We have provided a dynamic link when clicked ,we are calling a PM to fetch the document from Documentum and store it in Appian folder. However the PDF type file does not preview for some users, whereas Dev team with admin access have no issue viewing the preview for the file. FYI it is happening only for PDF type files PNG files seems to be working fine.
hi, I am trying to use upload Files function. this is one of the step in my process. I have a final summary screen, which shows the files uploaded and they should appear as document upload link. I used a!submitUploaded files in the next button, which actually goes to fIle Upload Screen to the summary screen. It works fine , when I tested the interface. But shows an error in site. An error occurred while executing a save: Expression evaluation error: a!submitUploadedFiles() cannot be evaluated in this environment. Target folder is not Document or Folder but marked as Folder. Also, editor access permissions has been given to the Users for this folder.
I have a value of type Date, inside two arrays. First array has only one value, Second array has multiple values. When I try to evaluate their typeOf(), I get 54 (Date with Timezone) for first one, & I get 7 (Date) for second one.The question is, why does the data type change for todate(now()) in first and second array ?Code:a!localVariables( local!singleItem: { todate(now()) }, local!listOfVariant: { 2, todate(now()) }, { typeOfSingleItem: a!forEach( items: local!singleItem, expression: typeof(fv!item) ), typesOfListOfVariant: a!forEach( items: local!listOfVariant, expression: typeof(fv!item) ) } ) Screenshot:
Hello, I have a field for mobile numbers in my Appian application, but it is in text format instead of integer. Appian does not support 10 digits as an integer, so I cannot change it. I need to sort this mobile number field on a read-only grid, but it is sorting as a string due to the text format. I need it to be sorted as an integer field.
I am facing a strange issue, I have created a custom record field, which i'm able to fetch the value in the interface, but while checking the Site the value is not getting populated. I am using a one to one relationship to fetch the value from the record. I have tried fetching other fields from the same record, even those are getting populated in the interface but not on the site. Thanks in Advance!
Details: javax.persistence.PersistenceException: org.hibernate.id.IdentifierGenerationException: ids for this class must be manually assigned before calling save(): PFYoutubeDT11569: org.hibernate.id.IdentifierGenerationException: ids for this class must be manually assigned before calling save()Why is this error occuring?
this is the UI using this sequence column from record i have to rearrange the UI columns how can i achieve this
Hi, Is it possible to make the line chart smooth, meaning without the data point dots. Regards, Sowvik Roy
I have a map and a dictionary.. How can I merge them and save the output to a datasubset?
I am below error in user interface.Please help to resolve. Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function 'wherecontains' [line 52]: Invalid types, can only act on data of the same type (Text, Any Type) Below is the Code and the place where wherecontains is there is highligted in red.Please help to resolve as to what changes needs to be done. ri!selectedSkuId ), local!selectedSku: a!refreshVariable( refreshAfter: "RECORD_ACTION", refreshOnVarChange: local!selectedSkuId, value: rule!APN_first( index( local!skus, wherecontains( local!selectedSkuId, local!skus['recordType!{9de47fad-3776-4334-bca6-7870632f65f6}NGP_PC_Sku.fields.{821936eb-32c0-4523-ab28-06972108537f}pcSkuId'] ), {} ) ) ), { a!columnsLayout( columns: { a!columnLayout( contents: { rule!NGP_PC_CMPT_skuInfo( skus: local!skus, refCountries: local!refCountries, selectedSkuId: local!selectedSkuId, selectedSku: local!selectedSku, def
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.