Discussion Categories

does anyone have tried to develop a dapp using Atra Blockchain services? If yes, is it possible to export and deploy the codes that Atra produces on IDE Remix or do they need some modifications? Thanks in advance

Hi Team, How to make current assignee to empty in the user input task. PFA

I want to get the current screen type in which my interface opened.Here screen type I mean : "PHONE" , "DESKTOP", "DESKTOP_WIDE" etc I tried using a!isPageWidth() but that is not working for my requirement.Please help me with this.Thank you in advance!! 

In this rule i had merged two query rule to one new rule, now i want set query filters on this new rule to filter data. Thank You

Hi, When we use " Run as whoever designed this process model", will the system considers the latest one who  published it or the user who created it (i.e., version 1) ? Thanks in advance,SSP

While entering a leave request in a read-only grid I am entering the same date two times with different leave type (which is allowed).  I need to get the leave hours entered for the same date as I need to give a validation message if the sum of leave hours exceed 8 hrs for the same day.  How can I achieve this?   In the sample data given below, I want to extract the requested hours where the leave dates are same: [LAST_UPD_USR:ehelen,LAST_UPD_TS:10/14/2022 5:55 AM GMT,CREATE_USR:ehelen,CREATE_TS:10/14/2022 5:53 AM GMT,IS_ACTIVE:true,APPROVED_HRS:,REQUESTED_HRS:5,LEAVE_TYPE:Sick Leave,LEAVE_DATE:10/26/2022,FK_STAFF_ID:113,FK_EMPLOYEE_LEAVE_REQUEST_ID:19,EMPLOYEE_LEAVE_REQUEST_DETAILS_ID:1]; [LAST_UPD_USR:ehelen,LAST_UPD_TS:10/14/2022 5:55 AM GMT,CREATE_USR:ehelen,CREATE_TS:10/14/2022 5:53 AM GMT,IS_ACTIVE:true,APPROVED_HRS:,REQUESTED_HRS:8,LEAVE_TYPE:Vacation Leave,LEAVE_DATE:10/20/2022,FK_STAFF_ID:113,FK_EMPLOYEE_LEAVE_REQUEST_ID:19,EMPLOYEE_LEAVE_REQUEST_DETAILS_I

Expression evaluation error : Invalid index: Cannot index property 'fields' of type Text into type RecordType (APNX-1-4291-001) How to resolve this?

Hi all. I'm creating a mobile application for employees to record their working hours, is there anyway to create a sign in feature? because each user should have an account to login and insert his record hours. but I'm wondering how can I stored their passwords, and emails?  

Hi @all, We are facing one challenge in using Record type: We have 3 fields in our DB that may contains value or remains empty. So we want to apply user filter on the grid for showing only those values which contains some data based on the section by the user from the list of 3 values i.e., the name of these fields. We are attaching the code that we are implementing for this but it is not ignoring empty strings. We want the black cross fields containing null to go away on applying the filter. Only values which contain data should be displayed. Kindly, help us in resolving the issue. a!recordFilterList( name: "Target Type", options: { a!recordFilterListOption( id: 1, name: "Voice", filter: a!queryFilter( field:'recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{voiceRecords}voiceRecords', operator: "not null", ) ), a!recordFilterListOption( id: 2, name: "MMS Record

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