Discussion Categories

Hello Everyone , I have one issue in process model it saying  "Document Does Not Exist or has been Deleted) (Data Inputs)" we have added a condition like documents exist or not if exit we are taking document name by using Document() function . when we validate the document by using  getcontentobjectdetailsbyid() we are getting below result. "Content Object [Name: Bill.jpg, UUID: _a-0000eae4-0751-8000-9d71-011c48011c48_24018957, Parent: Temporary Documents Knowledge Center, Parent Id: 7, Type: Document, Latest version: 1, State: Invactive Published, Internal file name: N/A]" but I'm not able to find any document in MY KC. and it is saying "State: Invactive Published," what it mean and how we can fix this issue ? Thanks  Saikumar

Hi All, I have a scenario where I want to use the filter logic configured in a record type by calling the filter on the interface.The filter is functional in the record type object, and I do not want to query record type and add filters indectly by creating a dropdown and linking the filter to that.But, I want a logic through which I can directly call the record type filter on the user interface.Is it possible?

Getting this error while adding cdt Constant in expression rule 

Hello Everyone, Does Appian allows the user to upload any password protected document into its cloud instance?  We have a requirement to upload the password protected file but when we try to do it through File Upload field or simply add it as a document within the application objects, it throws the following error: "File could not be uploaded. Please try uploading it again" Note: We do not have any restrictions applied in our Admin console in the "File Upload" section. Thanks in Advance, Nandini

Im getting Cannot index type Number (Integer) into type (DOCUMENT_DETAILS) - which is a cdt.  local!indexNum is  just a local a!radioButtonField( label: "Radio Buttons", labelPosition: "ABOVE", choiceLabels:rule!SKJ_GetForm( {} )['recordType!{228c141f-e2f8-4a93-bf0d-0dfed8c9c6b4}SKJ Form.fields.{af4b3fdd-a9a3-4ea7-82d9-8f16e323e35f}descEn'], choiceValues:rule!SKJ_GetForm( {} )['recordType!{228c141f-e2f8-4a93-bf0d-0dfed8c9c6b4}SKJ Form.fields.{d69bf265-893b-4707-965c-3512e6e1c9bd}itemCode'], value: ri!DocDetails[local!indexNum].docForm, saveInto: { ri!DocDetails[local!indexNum].docForm }, required: true, choiceLayout: "COMPAC

Hi, in my interface I have two buttons, "save" and "send as signature", the "save" button saves the filled and unfilled fields but the "send as signature" button must ensure that all the input fields are completed before making a recording. what solution can I use? THANKS !

Hi All, I am facing issue with record sync while writing dataset to the database table using write records.This works fine if we sync record manually , data is inserted , we get the primary key back to the process. The record is a simple record with no relationship defined. Going through the community posts , this issue comes when we have BIGINT type of datatypes defined in the table. So need to verify how to solve this issue without changing primary key column from int8/BIGINT to INT, as we need to store the values greater than int4 range in the database. Is there any way to make this sync work?Kindly guide.Attaching the screenshot. Thanks

i want to cover the black space below the comment with column. And when we expend the comment then column size get auto reduce. 

Hi, We are currently runnning on Appian 23.1 with Linux OnPrem servers. We are using Apache Webservers. Can we replace Apache web server with Citrix NetScaler Load Balancer. Is any one using this setup. We have two sets of environments (one with high availability for certain applications) and the other is Distributed( for other applications). Kindly advise on the use of load balancer and provide any documentation on the same. Regards, Chetana

Hi My requirement is convert base64 data to appian value received from external system.I tried making it by referring to the URL below.docs.appian.com/.../Integration_Object.html The problem is that many pdf files were created.Has anyone had the same problem? How to solve it .Need advice and help!!! below is my source code image When i click refresh button the PDF file increases.↓

I have a grid column which should be displayed based on a condition. When the condition is true it will show a grid as below. and when the condition is false it should not show anything but instead it is displaying as below. I haven't configured anything to display something like this in the interface.  Can someone please help.

HI everyone,  I'm building a process model to write a record to record type table. I have two nodes for my process for now, one is script task and one is write to record. At script task node, I use a!map function and hard code data like below. When I start process for debugging, I get the error (key can not be null). However, my key has value. I wonder do you have idea how to fix it ?

Hi there, I have a map type process variable (maybe name it as "vv") in a process model, with data like this: {returned=[mat=111, pt=5555, sc=44, bn=EEE],[mat=222, pt=3333, sc=44, bn=III],PopUpText=No records found, LoginStatus=true, connection=xxx} A CDT "returned" is defined with the 4 fields (mat, pt, sc, bn). And I define a CDT process variable "r1" which can store multiple values. can I use the following to get the "returned" data in MAP variable "vv" to CDT variable "r1"?  save pv!vv.returned  into: pv!ri could anyone know? thanks! Lin

Hi everyone, I have a column storing Date Time values but is now Varchar type in DB, eg. 2022-09-12 03:53:33 (varchar(19)). I want to format it to 9/12/2022 03:53 AM Any recommendation? Thanks a lot for your help :)

Deploying application first time from dev to test environment giving error in record type. Below is the screenshot. I have checked this record type is present in the deployment package but still showing missing precedents. Also, connected system is also part of the deployment. Do we need to deploy connected system individually first and then need to deploy rest of the package?

I am new to use this Range slider  , noUiRangeSliderField() I am trying to install the new plug in and use this range slider   My basic query is how do we save the slider value back to any rule input or local variable   , i do not see value or save into parameter  onClick: a!save( ri!value , What parameter we can pass as Value  ? )  onClick: null,onChange: null,onSlide: null noUiRangeSliderField( label: "Temperature", labelPosition: "ABOVE", validations: {}, height: "AUTO", minRange: 0, maxRange: 200, startHandle: 0, endHandle: 200, pips: null, tooltips: null, sliderOptions: null, sliderOrientation: null, verticalHeight: null, step: null, behavior: null, additionalRange: null, shape: null, sliderColor: null, backgroundColor: null, disableSliderTooltip: null, disableSlider: null, readOnly: null, onClick: null, onChange: null, onSlide: null )

Hello, I'm trying to open an Excel file on my local using Appian RPA. The execution log shows the action is successful (refer to the screenshot below) but the file did not open. I tried moving the file to different folders but it didn't work. Can someone let me know if I'm doing something wrong? Thanks!

Hi, I am tying to run the Mysql to Excel plug-in: with basic SELECT Queries it works: but if I sent something similar to this:   SET @pivot_sql = 'SELECT * FROM report'; PREPARE stmt FROM @pivot_sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;   it shows MariaDB syntaxis error.   any idea how workaround for this ?

Facing an Issue with basic user, While I was trying to get inactivated user from custom Picker, It is throwing an error like insufficient privileges for basic User Login.But for Administrator user type it is working fine and I have Updated that plugin to its recent version as well.

I want to parse CSV file and load into CDT without DB. Please suggest a plugin which is not deprecated.

Can I ignore case sensitive in Query Record Type as I do automatically in Query Entity? The record type I'm using has data sync enabled and I need to put a validation on a text field to give evidence to the user that there is already a line with the string he is typing. I built the validation into an expression rule that invokes the Query Record Type and I noticed that the filter is case sensitive. Thanks

Hi Experts, Is it possible to have this Horizontal Scrollbar at the Top of the Grid rather being in the bottom. Thanks, Gaurav Singh

So, I have a form for " Document Details", the user can enter as many documents as they want.  and when they add a document, it should appear in the grid.  I declared   " local!indexNum" as index , so the user can enter many documents.  And here is an example code of how i entred data:  a!dropdownField( label: "Main Type", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels:local!type['recordType!{ba0dd34e-52a6-4f09-ba3a-dd6885feda5b}SKJ Main Type.fields.{e5eb76e0-4885-44d7-b9c3-263533a5f721}descEn'], choiceValues: local!type['recordType!{ba0dd34e-52a6-4f09-ba3a-dd6885feda5b}SKJ Main Type.fields.{4a008dc7-3ea8-466e-a515-75c5cb965a49}itemCode'], value: if( a!isNotNullOrEmpty(local!filled), ri!DocDetails[local!filled].main

Hello All, i am trying to filter the record which has been created in the 1st half of that particular month. So basically,  I have a record with a column "Created on" (Data type). on this column, i have to apply the filter to get the records which have been created in the 1st half of the month. For eg. if record created on "11/10/2023, it is created in the 1st half (Before 16th October and so on.

Hi, My use case is this: - We have set automatic deletion for process 4 days fater its termination - If users report some issue, we archived process involved using Process Management Utilities plugin, just to be sure that we dont lose all the data about what user did, services responses, and so on. We are assuming that archives process remains there until we manually remove them when issue get solved. - To see all the info about process execution on a better view, our idea is unarchive the process using the aforementioned plugin My question is, ¿once we get a process unarchived will Appian remove it if its retention period is expired? In my case, ¿will Appian remove the unarchived process when the 4 days period is over? ¿What happen if we unarchived a process after the 4 days period? Regards