Discussion Categories

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

Is there a way I can set visibility of a site page based on "DESKTOP" or "MOBILE".Both a!isNativeMobile and a!isPageWidth do not work on site object.

How to download multiple documents based on a caseId just with a single click... by using a!documentDownloadLink able download single document

Hi I need to implement a use case, where I implemented links to view document and download document links. So that, I can capture the user response and use it for audit purpose. Like how many times document is viewed and how many times document is downloaded.  When user clicks on view, I have used documentViewerField and users can able to view. For pdf documents, users can download the document from the pre-defined options on the component. Like (download, print) etc.  Is there any way to hide those options? Like disable download or disable print option.  Kind Regards Rahul Gundu

Hi my query is working fine for the last 9 months and now it is showing errors as below: Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [DetailViewDT3872], query: [queryentity expression], order by: [[Sort[AccNumber asc]]], filters:[null])  I built a new constant and it still did not work. Could you please assist why it is starting to show this error and how to fix it? this is my query: a!queryEntity( entity: cons!Detail_View, query: a!query( selection: a!querySelection( columns: {a!queryColumn(field: "AccNumber")} ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ) ), fetchTotalCount: true ).totalCount

Hi,  After the script ran, i found Error in execuation log and report does not gets generated. Thanks in advance.

Hi Team, I am Looking forward to learn Advanced topics like data analysis and prediction Algorithms in appian by implementing the below Explained Proof of Concept (POC). 1.Data Analysis and Prediction of sales: The progressive stock control, quote to buy, and conveyance system designed for Organization XYZ utilizes data Analysis and predictive algorithms to upgrade stock levels in light of past sales and future forecasts. 2.Quote to procure: When goods become scarce, the system first investigates internally for spare parts, producing items if parts are available. If not, it autonomously puts in orders for spare parts with providers, assessing cost and delivery offers from numerous vendors to make an informed judgement. 3.Logistics: Once procurement is finalized, the system meticulously plans shipping, streamlining paths and techniques of transportation to guarantee on-time delivery of components. I need you inputs and suggestions to learn and implement this POC. Regards J

Hi I'm trying to implement an Appian Web API (POST method) that is exposed to an external system.This API capture data like passing a document inside a json structure to an appian.My question is how to impletement passing a document inside a JSON structure to an appian web API?Is it possible to implement it in appian web API?If not is there any other way I can implement it? Please share any relevant documentation or sample code reference. Thank you

Hi,  Im engaged with a client who has adopted in their enterprise standards that all exposed microservices within their organization be consumed using gRPC (https://grpc.io/).   Some  of those services will need to be consumed by the Appian solutions we are planning.    My current understanding of gRPC & supported authentication mechanism is the out of the box  Appian connected system, HTTP & Open API authentication types will not work.   As such we are considering if building custom connected systems and support for integration objects might work.  Has anyone in the community run across a requirement like this and done any successful custom connected system development to support the gRPC framework or solved the integration needs  in some other fashion?Also with Appian Integration SDK when developing custom Connected systems is it a requirement to use one of the Authentication Types supported by Appian (https://docs.appian

Hi  What path should I use for web api document download? image is uploaded to appian's image folder and How should I specify that image folder?  

Hi, I have an Excel template and I want to add information in a column to the right of the document (custom values etc). The problem is that I put a statement that doesn't return anything because I don't want it to do it automatically (if it puts the values on the right it removes all the values on the left) and then I only add the values using the custom values. what do I want. Is there a way to not put the message (I have it below) "No data available due to empty data source, applied filter/selection criteria, or fields visibility."? Thanks

Hi  I'm using document extraction and document Reconcile document extraction smart service to process the invoices.  The document extraction is successfully getting completed but in the Reconcile smart service document is shown as broken. The document contains invoice information and invoice item details.  Another thing, invoice items is a table and it failed to get extracted? Can't find the reason?  Please let me know if anyone came across similar kind of problem. Kind Regards Rahul Gundu