Discussion Categories

Hi  My requirement is to avoid mail alerts when process instance's fails with out changing existing process model designing. we thought of maintaining process instance information along with errors in database, Do we have any option in Appian  to get process instance information along with errors like any log files or any reports

Hi,Recently we deployed a new application to the Production environment. But facing DB connectivity issues.Please find the screenshot for reference: After creating the Data Source at Admin Console it shows Test Successful.Please find the screenshot for reference: and when I verified the Data Store, it was successfully connected to DB.Please find the screenshot for reference: Now the application starts working finePlease find the screenshot for reference: After some time I tried testing the UI and it is showing the same error.Please find the screenshot for reference: I'm repeating the same steps to avoid the error.Please help me in clearing the error.Thank you.

I am trying to create a process with a form that is voice activated using Dragon or SiriKit so the end user (a clinician) can use voice activation into the App we are developing. All recommendations on how to plan this inside of Appian as a developer would be appreciated.  Thank you in advance, Kirsten

Hi, I need to open a SAIL form directly from an old Portal form.  I don't want to launch the page that states - 'This form must be viewed in Tempo.'., for the user to then have to navigate to Tempo and then Tasks, but for the task page to open directly The task link is on the old  dashboard style portal  and in a task list for the user to click which uses    - /suite/process/getTaskDetails.simplepopup?taskId=268974442&appian_environment=apps*/ as opposed to   /suite/process/getTaskDetails.simplepopup?appian_environment=tempo&taskId="&ri!taskId&"&pmdg=true"  which would open it directly. Thx

hii all I need to upload a excel sheet as a bulk upload option in a interface and also preview the excel data to user in interface itself before giving submission, please let me know how to preview the excel data in interface , someone suggested staging table approach , please someone explain how to do this

hii all im new to appian, please tell me 1.how to create a staging table ,    2.and alos how to clear the staging tables 3. how to write staging table data to main data table using script task

Hi, Recently I have deployed a new application to Production environment. But facing DB connectivity issue.Please find the screenshot for reference: After creating the Data Source at Admin Console it shows Test Successful.Please find the screenshot for reference: and when I verified the Data Store, it is successfully connected to DB.Please find the screenshot for reference: Now the application starts working finePlease find the screenshot for reference: After some time I tried to login it is showing same error.Please find the screenshot for reference: I'm repeating the same steps to avoid the error. Please help me in clearing the error. Thank you.

Hi everyone, I wanted to do validation based comparing the data already existing in database, but problem is that I have around 40000 records, so while fetching data from database to appian it is throwing the error. How to handle this scenario.. Thank you all in advance! Regards, Kiran Sajjan

Hi , We have a requirement with the third party(old system) to have csv with comma delimiter delivered with data enclosed in double quotes. Below is sample data: Data in Database table: column1 column2 column3 testdata11 testdata12 testdata13 testdata21 testdata22 testdata23 Expected export of csv by third-party should look like below "column1","column2","column3" "testdata11" ,"testdata12" ,"testdata13" "testdata21" ,"testdata22" ,"testdata23" This was not possible 2 years back with smart service "Export Data Store Entity to csv" so we ended up 1. creating an expression rule that queries data from database and concatenates data of each column and each row with double quotes. 2. generate a text string 3. pass the text string to "Text doc from Template" smart service that creates a csv as expected by third party But the problem is as the data keeps growing ,

expression evaluation error at  "readexcelsheet" readexcelsheet( excelDocument:ri!Spreadsheet, sheetNumber: 1, startRow: 2, ) ruleinput is document

Hi, Recently I have deployed a new application to Production environment. But facing DB connectivity issue.Please find the screenshot for reference: After creating the Data Source at Admin Console it shows Test Successful.Please find the screenshot for reference: and when I verified the Data Store, it is successfully connected to DB.Please find the screenshot for reference: Now the application starts working finePlease find the screenshot for reference: After some time I tried to login it is showing same error.Please find the screenshot for reference: I'm repeating the same steps to avoid the error. Please help me in clearing the error. Thank you.

Hi all, I am struggling to send zip file over sftp. normal files are sending without any issue, but when i send zip file its give me error like  "The system cannot find the path specified. " can you please suggest how can i send zip file through sftp

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?