Discussion Categories

Hi Team, During our performance testing, we are getting below error . when manual testing we are unable to reproduce it ,  Expression evaluation error [evaluation ID = c5310:d3811] in rule 'dsm_getslariskcasescount' (called by rules 'dsm_d_dashboardreport' > 'dsm_recordsyncbasedhomepagemain') at function a!queryRecordType: APNX-3-0000-002: The real-time store is not up to date to the requested tx 102138493; latest tx is 102138487 (APNX-1-4198-000)

hi, I want to Complete the empty space to save space, what are the best practices?

I have a read-only grid which should show all the rows with filter (isResigned) when I open the report. Along with that I have pie-chart in the same report based on last working date. So, now when I click on pie chart the read-only grid should be updated based on my selection.  I am able to get the full report with filter isResigned but when I select the column the read only grid is not getting updated.

On the process minning install documentation (https://docs.appian.com/suite/help/22.3/pm-5.6/admin/install.html) in the Production installation section step 6 says: Modify the following mandatory parameters in the .env file Shouldn't it be .env-prod? and if so step 6 should be merged with step 5. Because when you run ./pm.sh use-prod-config the file .env will be overwriten with the contents of .env-prod Thank you.

Hi, I have setup a timer to run "Daily" and "Every weekday" at 4 PM. This should trigger a email notification. But, I am receiving an email notification on every day at 5:30 AM EST.

After updating the plugin getting the following errors (Note: It was working fine in the earlier version) : Import CSV to Database v6  - Changed to Date Format must be one of the following 'yyyy-MM-dd', 'yyyy-MM-dd HH:mm:ss', 'yyyy-MM-ddTHH:mm:ssZ', 'HH:mm:ss'.Snippet of Datetime format - "2021-12-10 14:20:42.740"    Load CSV File To Database (Using Out-of-Box Appian Datasource) - java.lang.Exception: This method only work with MySQL databases.

a!localVariables( local!data:rule!VG_CRK_RT_get_all_srvc_nm(), local!exportDocId, local!errorMessage, local!flag:false(), a!formLayout( label: "", contents: { a!sectionLayout( label: "", contents: { a!radioButtonField( label: "Select Any Option", labelPosition: "ABOVE", instructions: "", helpTooltip: "Before Uploading, Download a file for service, to view latest data", choiceLabels: {"Download", "Upload"}, choiceValues: {false(),true()}, value: ri!isUpload, saveInto: {ri!isUpload}, required: true, choiceLayout: "STACKED", validations: {} ) } ), a!richTextDisplayField( labelPosition: "COLLAPSED", value: { "Before Uploading, Download a file for service, to view latest data" } ), a!dropdownField( label: "Service Name",

how to validate a text field which can be  A,B,C,D, Null, or groups of A,B,C,D (ex. ‘A,B,C’ with commas no space).

Hello, I'm looking for a best practice how-to enable a user management within an application. Basically there are two main roles within the target application: administrator role - I assume that one can be based on the appian built-in user management standard user role - thats a role where an "anonymous" user can apply for with a self choosen username and password based on an application built login interface such user will have some additional things to do What would be a good way to achieve this if any? Thank you in advanceThomas

How can we generate a series of random numbers like 23434 56767 89789 34355 56307 Please suggest me or an example without any table connection

Hi Team, I am looking for a plug-in or Public Appian API or function to list all Folders in an Application including rule, process model, KC, document folders. I tried with below function which returned only the folders inside KC of an application when given searchCriteria with APP_PREFIX&*. Please do the needful findcontentbyattribute( searchAllContent: false(), contentType: "folder", attributeName: "name", searchCriteria: "<APP_PREFIX>*") Thanks, Bharathwaj RK

Hi Everyone , i want to extract pdf file data into database. if any smart service or plug-in is available in appian  ?  like: ( we have importfromXL to XL files ) please suggest the best way to achieve this. Thank you

I have table by name abc which have columns id(pk),refId(FK),uniqueId,languageId,locationhere language Id is : id for languages ex: english =1 , french=2, hindi=3 etc unique id is: if say for refId(fk) there are 5 location then unique id is 1,2,3,4,5 for language id 1, unique id is 1,2,3,4,5 for language id 2, unique id is 1,2,3,4,5 for language id 3 etc so here my requirement is based on selection of ref Id I want to add location using grid but here challenge is user can allow to add location in all available languages and need to maintain uniqueid's same.one thing need to consider is unique Id should be the next number to existing unique id for that particular refId.Please do help, am struggling to implement it.                                                                        &

Hi I am trying to find inactive users using getuserlastlogin function. It returns date for some user and for some user it returns null. Am I missing anything?

In a gridField() fed by record data, when you try to use the disableRowSelectionWhen param, record references fail to be evaluated. As an example, we were trying to disable row selection based on a date time in the record data. Originally we had it wrapped in a todate() so we could compare it to a date, but the logic was failing to disable the desired rows. Just for fun we removed the todate() around the record field reference, only to be smacked with an error about not being able to compare Null to a date. That's right, the record reference evaluated to Null. For more fun, we tried using fields that were not dates, and the same thing happened on integer fields, i.e. the record reference evaluated to Null. Has anyone else run into this? 

HI All,  I have SAIL form with summary details and  a grid.  i have a add card layout button above the grid which will open different process to add data. when Calling Process model using a!StartPRocessLink service under add button(card layout) from Parent Sail form which mostly read-only info. when i click on Add button , i receiving a message saying you would like to leave from this page., looks like its browser message.  navigate to chained forms/process model and once added data its expected to come back to same form. Please suggest how can i avoid such message, Thanks in advance.

how to redirect to site record page by using record link. a!linkField( links: a!recordLink( label: fv!row['recordType!{3a9fe53d-c80b-44ca-9818-c29c6bd853a5}TRM Request Type.fields.{986b4d5b-200e-4665-a365-33808cab1533}name'], recordType: 'recordType!{3a9fe53d-c80b-44ca-9818-c29c6bd853a5}TRM Request Type', identifier: fv!identifier, dashboard: "summary", openLinkIn: "NEW_TAB" ) )

Hi, I have a requirement where I have to schedule a task i.e to activate RPA agent from the server on each day when server comes online, I have used task scheduler to trigger the agent but its not being stable as it is activating and deactivating the next minute, which is leading all the RPA processes to be in queued. Please update with any solution. 

only document id shown  is there any changes in Interface ?

redirect an link of tempo record to site 

Trying out record centric design for the first time and I have a multiple dropdown field on the interface. Using the recordType (no data yet, just structure) as a rule input does not allow for me to specify a field as an array (like can be done with a CDT). Is there a way around this or is it as simple as 'if a multiDropdown is involved a CDT must be ctreated?

How to following text into constant write it in a constant.. should i make separate constant for each double quote text>>  "sites/" & "workday-dashboard-config" &  "/record/"

Hi, I am currently using Appian 22.1.875 on Linux servers. Presently, my applications are using Oracle12, but now my DBA team is planning to migrate to 19c. Will there be any issues after the upgradation of DB to 19c? Has anyone tried this? Was there any impact on the existing applications in Production environment because of this migration? Please help. Regards, Chetana

We are trying to connect to a hive DB via a Rest API hosted in Openshift cluster, the .pem for the hosted environment have been imported to Appian environment via Client certificate and trusted certificate Still we are unable to establish the connectivity to the Hive DB due to SSL connectivity error. We have created certs for the Rest API hosted environment and imported the same to Appian , but still Appian is unable to establish the connectivity via Rest API call. Appian version used : 21.4 When trying to connect to the given host ip via openssl s_client -showcerts -connect <ipaddress> following was observed CONNECTED(00000003)write:errno=104---no peer certificate available---No client certificate CA names sent---SSL handshake has read 0 bytes and written 0 bytes--- Can we know why Appian is unable to connect to Rest api and what certs are needed for Appian to trust the cluster in which this Rest API is hosted?