-
Recently active
HII ALL, I need to upload a excel file for bulk upload and after uploading it i need to preview the whole excel data to the user before he is going to clicking the submit button for further process . please help me to achieve this , i am new to appian please explain this .
i have to send the email once the task is approved can someone suggest me example which i can refer for email configuration for From,To, Subject, CC
Hi All,I wanted to write a query which takes input as form of array for each user ("email","firstname","lastname"), and want to map those values to parameters of createUser method, Any suggestions?I tried to write a code but it seems not working, As I have little knowldege in Appian.Below is the code I have written, I know it is wrong can anyone help me to get the correct logic/Code?
Hi All, We've a process which is started via webAPI and has a node which uses QueryProcessAnalytics to query the process report to get a few details. This node where it fetches the data from Process Report is not working/not returning results when running the node as the same user as process initiator(in this case , service account used by webAPI), however, it works fine when changing to execute as user (process designer). We checked the security of the process reports and the parent folder and it has the service account group with Viewer permission. The only difference we see is the service account is basic user and the process designer user is system administrator. Any pointers to why query process analytics is not working when called via webAPI with a service account?
Hi, In one of our applications, we are using an Integration object, but when we try to acces the object in Designer, we are getting the following error -- PFB the screenshot of the error. Also, when I check the logs, this is the error, I am seeing : 2022-10-17 04:48:25,899 [http-nio-8080-exec-10] ERROR com.appiancorp.rest.shared.AppianExceptionMapper - Internal Server Error on REST API invocation.com.appiancorp.exceptions.LocalizedAppianRuntimeException$LocalizedAppianException: Expression evaluation error [evaluation ID = 733a0:cd8cd] : Could not cast from Encrypted Text to Text. Details: CastInvalid (APNX-1-4198-000) at com.appiancorp.exceptions.LocalizedAppianRuntimeException.<init>(LocalizedAppianRuntimeException.java:16) at com.appiancorp.sail.server.ServerExceptionTransformer.createLocalizedObfuscatedException(ServerExceptionTransformer.java:46) at com.appiancorp.sail.AbstractUiService.localizeException(AbstractUiService.java:113) at com.appiancorp.sail.AbstractUiService.r
HI ,I am trying to update a process variable of type datasubset,I am using the following code to update a particular index value,a!update( data: pv!dataSubset, index: index( index( pv!dataSubset.data, wherecontains( 1, tointeger( index(pv!dataSubset.data, "verse_no", {}) ) ), {} ), "sentOn", {} ), value: now() ) As the data is an array and at each index again is a CDT.And I am trying to store it in the PV(type Datasubset) but I could not able to do it I am getting an error "(Expression evaluation error at function a!update: Invalid index: Cannot use multiple numeric indices into record for update) (Data Outputs)"
I created successfully a web api (image bellow) then i copy the URL in the browser and its works (check image bellow) But when I copy the URL in an incognito browse, shoe this error: {"resource":"\/suite\/webapi\/CWAOECClients","error":"APNX-1-4187-000","message":"Authentication failed. Please check your credentials and try again.","title":"An Error Has Occurred"}Help please ///////////////////////////////////////////////////
Hi, We are planning to use LDAP for users and groups and control Appian security. Do we still need to create the same set of users again in Appian. Can someone advice on this. Thanks
Hi all, We are doing some cleansing in our environments and we want to know what was the last time a process model has been used. I tried the process reports, when analysing the process models, I can't get other than the last modification, but not the last usage. In monitoring or process reports for Tasks, I can get what is currently active or recently active, but not any kind of historical view. In the health check, there is a tab named process sizing that looked promising but does not contain that information either. I wonder if we can get any other source, of in anyone knows in table in the Appian model that we can query. Thanks.
Hi, I want to execute a SQL query, is there any function like executestoredprocedure that is used to execute an sp? I am trying to run a SQL query through the process model and trying to see the result of that query, so is there a way how to get the result of that select statement? Can anyone please help?
Hello everyone, How to display the table format in appian using expression rules? If anyone has the idea how to generate the table using html please help me . Thanks in advance. The finally format in pdf should be like this and data is coming from database.
i have written the expression rule to show the data in table. but how to remove these semicolons from the table a!localVariables( local!contractData: rule!generatecontracttable( cif_int: ri!cif_int ), local!rowItemsdata: { " " & index( local!contractData.value_txt, wherecontains( 1, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & index( local!contractData.value_txt, wherecontains( 5, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & index( local!contractData.value_txt, wherecontains( 6, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & index( local!contractData.value_txt, wherecontains( 7, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & inde
User demonstrated an error that is continuously occurring for them. The functionality previously worked for the user. I do not receive the error following the same steps. The error also has no details and it is not shown in the tomcat logs. What can I look in to?
Hi Community,I am trying to query form Active Task assigned to users in my application from a Process report. I was not able to create a filter for the same to check assigned tasks for selected users.= a!queryProcessAnalytics( report: cons!I_MY_OPEN_TASKS, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "c0", operator: "includes", value: ri!taskName ), a!queryFilter( field: "c3", operator: "between", value: { ri!assignedOnFrom, a!defaultValue(ri!assignedOnTo, today()) } ), a!queryFilter( field: "c4", operator: "in", value: ri!assignedTo /*issue at this filter*/ ) }, ignorefilterswithemptyvalues: true() ), pagingInfo: a!defaultValue( ri!pagingInfo, a!pagingInfo( startIndex: 1, batchSize: -
Hi, I am trying to use readexcelsheetpaging(), it shows totalCount value but not retrieving any data *note: the excel is generated using export to excel smart service what may be the issue, is there any work around?
Hi All, I have a scenario where i need to filter the data from db based on the date. Filter values will be something like below. Today Yesterday Last 7 days FYI, In Db, date column is stored in date time format. Can an someone suggest me how to achieve the filtering thing from db based on the date when db value is date time? Thanks
I'm working on a integration project where data is coming out of appian, here I have a situation Where I need to specify if data is missing In a particular field let's say "name" under "personal details" section then "error type" should be "personal details" and "error details" should be "name". Likewise I have many fields under section "personal details" - for this i have created a record. Can anyone please help me to achieve this situation
Hello community, In our current project we are using "Move To Collab", lately we are facing a problem with moving Login Audit Files. Error details states: com.appiancorp.suiteapi.content.exceptions.InsufficientNameUniquenessException: Name is insufficiently unique Also, please find the error log attached at the end and suggest a method to over come this problem. Thanks and Regards, Vishnu Devalla [View:/cfs-file/__key/communityserver-discussions-components-files/62/ErrorLog.txt:150:120]
how to create end user to enter the insurance number and get a report.
Hello everyone, How to display the table format in appian using expression rules? If anyone has the idea how to generate the table using html please help me . Thanks in advance. The finally format in pdf should be like this
What is the difference between quick apps and application builders to create an application?
hi I was able to make the connection between google sheets and appian, using the google sheets connected system (vuram)... i want to store the data of my appian cloud database to a google sheets, is it possible? this is the integration that i have creates, connection successfully
I have created an integration s shown below: I am able to run this integration when values are null however, it is giving the below error when I give any values: sample request body with values: { "range": "Sheet1!A2:B2", "majorDimension": "ROWS", "values": { {"ABC"} }} Error: The external system did not understand the request error-result-guidance The request was missing required details or was improperly formatted HTTP/1.1 400 Bad Request
Hi, I have deployed a new process with the Deployer tool, and few minutes after, I've noticed that this process has been launched itself automatically without any user action. The only particular settings is that the process is configured with a Timer trigger set with a weekly value : saturday on 7:00 am The process has been deployed today (friday 2022-10-13 at 12:00 am) so the day and hour does not match with the timer. Would you have any explanation ? is this an Appian ou Deployer bug ? Regards
I have data stored in db as row wise. that data i have to show in column wise is that possible if so please let me know data stored in database like below Contact ID Contact Limit AED (000) Contact Outstanding (AED’000) Value of Extension Sought AED (000) Capital Amount AED (000) Interest Payment Due (AED’000) Current Due Date Days to be Extended New Maturity Date From CrP =Contract Limit = Value of Full Contract - Outstanding =Value of Extension Sought = capital amount = Interest Payment =Current Maturity Date of Payment being extended =Number of days extension sought (B) =New Extended Maturity Date Total 100,000 5,555 1,192&nb
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.