Foundation

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 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 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

Hi  Please be informed that i am trying to provide validation for a one user input field in a pattern like P (upper case).7 digits.2 digits.2 digits (if applicable) i have tried like below but for two conditions it was not working if first letter P is lower case also it was returning true and for last 2 digits if applicable then only it will be having those digits but it was expecting those two as mandatory.  Could you please suggest on this a!localVariables( local!input:"P.8790889.87", local!pattern:"[P].[0-9]{7}[.][0-9]{2}[.][0-9]{2}", local!output: regexmatch( local!pattern,local!input ), local!output )

Hi, we have a process with 2 tasks. When the first task has been completed, there is a subprocess that elaborate different script and, simultaneously, second task has been opened in chaining. Second task is used to preverse chaining in the process, meanwhile the activities of subprocess are on working. Until the subprocess has not been completed, if user click on submit button, task has been generated, This is simple example: Sometimes, after completed the second task (without subprocess completed), system regenerate the task with SUBMITTED Status and user cannot retrieve it in the task list. Do you encounter this problem? Is there a way to solve it? Thanks in advance. Regards, Juri Monti

Hello, I have a problem on my form interface that I can't figure out, I have a dynamic input that can add more paragraph fields if needed but when the form is submitted, two records are created with the same data saved, and only the last text from the different paragraph fields created by the dynamic input is saved in the duplicated records but with 2 differents ID. I'm new to development and to Appian and I'm not english so I have difficulties to understand what can be the source of the problem, I tried many things using documentation but it's unsuccessfull. All my form's data is saved in my record type "HELLO Evaluation", except for the text from the different paragraph fields who are saved in my record type "HELLO Objectif" by a one Evaluation to many Objectifs relationship. Here's my code, I suppose the problem comes from the paragraph field code (259 to 288) or the submit button (348 to 376) but I'll give you all of it in

i have a use case, where i need to display two arrays - a before and after if you will. local!array1:{"Dog","Cat","Mouse"},local!array1:{"Dog","Cat","Mouse","Elk","Rat"} ideally i'd like to display them in a grid, so that the user see's a nicely formatted list - which I can then add some functionality too. Something like :----BEFORE---- AFTER-------------------------------------------Dog     ----- Dog -------------Cat     ------Cat ---------- ----Mouse ---- Mouse ----- ----NULL ------- Elk ------------Null ------- Rat ----------However / whatever i do, i keep tripping over that the gird only really wants to parse one data array. if i try using the two different arrays in the row then I soon trip over having different array lengths.Any ideas ? 

hi every one i have some valus whih is representing in the precentage formate example  1)908743.2% and some other like 2)23% it was data population in grid field my query was if the value contain length of 2 then need to print asit is but if it was more that length of 2 like i shown in example 1  it should show only 2 digit value  if value was 33% i want show same 33 %  if the value was like 98567.23% i want like 98% note : there is no fixed length for the number which display on grid

Hi I am working on task where i am  supposed to generate a pdf , using "XML" method ,  I created template and build this process model , but i don't know what to do next,  can some one direct me through the steps or share an example maybe?  Like how should i pass the data in the scrip in xml form ? 

I want to generate the pdf using XML expression , you can explain  the steps to do that , i want the first using this process model to build the dynamic pdf , in the script task i passed the parameter from the inteface then i must do the xml expression , you can help ? i want to pass three parameter , the first parameter is the requestDetails , requestDocument , Generate (this rule input for the button when click on it to generate the pdf)

this error am getting, unable to figure it out

How to generate a dynamic docx template from images with description appended adjacent to it

I would like to convert the following XML to a CDT. I have no problem capturing the values in Key, LastModified, and Size using torecord(). However, I do not know how to create a field in my CDT to capture DisplayName using torecord() since it is nested in Owner. Please let me the best way to get the data in this XML. <Result><Key>Mock_Doc.pdf</Key><LastModified>2023-10-06T02:19:06.000Z</LastModified><Size>38864</Size><Owner> <DisplayName>Tracy</DisplayName></Owner></Result>

I have a requirement to run a process once scanning a QR code. How Can I achieve this?  Please suggest some solutions.

What is Environmental Constant ?

I'm facing an error while triggering a process from an email. Once it is triggered I have tried below two things basically  1. Extracting Data from Document 2. Move document to particular folder And user is guest since i am triggering from an email. Any insights or guidance on resolving this would be much appreciated

Hi All, How can we avoid tabbing for Help Tool Tip. Like in a section layout implemented tabbing but this tabbing is also getting applied to the help tool tip of the text fields and drop-down fields, how to avoid this tabbing to those help tool tips. Any suggestions?  Thanks In Advance, Gousii

Hi all, I have these site pages, (these pages have rule inputs, but they start as null from sitepages): On another page, there's a state and location in which the user can click on a button to redirect to those options, in this case I'm able to pass values to RI: I'm using for these buttons the starprocesslink to display the same site pages, but I notice the tab doesn't have highlighted, it remains highlighted the page from which it was invoked. Wrong selection: Desired: Is there any suggestion in how I can programmatically open the site page (in the 2nd scenario, passing rule inputs) and have it highlighted ? Thanks in advance

I have a case where i need to delete 1million documents from appian. so what I did is querying the appian doc ids from the DB and checking whether the appian has this document and proceeding with deletion. for this i planned 2 approaches: 1. using a rule querying the doc ids from db. then, I will make an intersection with doc folder (getting list of doc ids in this folder) and doc id list to confirm those ids are in Appian and proceed with deletion. 2.adding a script task before deletion to whether doc is present in appian or not using isObjectexists then proceed with deletion(currently my environment has only delete single doc at one time) which will be best solution and pros and cons of it or is there any other ways . I'm new to Appian can anyone help me this ?Thanks in advance

Hii, is there any way to collapse in cardlayout section. I have a requirement like inside cardlayout section we have four selected tab again in cardlayout one by one that tab enable after approve after enable last one how can we collapse by default.

Can anyone brief about attended and unattended node?I'm bit confused of both

Hi Team, When Appian is down for maintenance do what will happen to the processes? Will they be queued or fail?

Hello Everyone, I have to show the UI like this(read-only), first two columns' data comes from different table (like collateral_cdt) and 3rd and 4th columns data comes from (cust_doc_cdt).How can I display this Ui?    Please suggest on priority

What is the right way to index a specific field?  im getting index error (Customer can only be indexed into using square brackets or the index function)   

 Hi team, Iam building a logic where i have two lists as listed below, now i want to check data[1] i.e, wifi Router Demand value 500 with all (5 items)count values in Items[1] . and same data[2] with items[2] with all 5 count values in items[2] and return the sparepart Names that are less than demand value. 1. data: [product=Wi-Fi Router, Demand=500, productid=]; [product=Wi-Fi Extender, Demand=7, productid=] 2.items:{ {{Sparepart: "Wi-Fi Module", count: 100, productid: 1}, {Sparepart: "Antenna", count: 100, productid: 1}, {Sparepart: "Power Supply Unit", count: 100, productid: 1}, {Sparepart: "Ethernet Port", count: 100, productid: 1}, {Sparepart: "CPU Chip", count: 100, productid: 1} }, { {Sparepart: "Wi-Fi Extender Module", count: 20, productid: 2}, {Sparepart: "Extension Antenna", count: 30, productid: 2}, {Sparepart: "Power Adapter", count: 15, productid: 2}, {Sparepart: "Ethernet