Discussion Categories

I'm creating a new interface object to display several pie charts. The data for the charts is stored in a local variables in the parent interface object which references my children interfaces. In terms of performance, what is the most efficient method to access the data required for the pie charts? Create a rule input on the children interfaces and pass the local variables data from the parent interface or query the data separately in the child interface to avoid passing it from the parent interface?

Hi , I have one base record in that one i'm forming three relationship two one-to-many and one many-to-one. now i want to typecast data fields from base records and related records in one CDT. can anyone please explain how i can achieve this using for each as i want to cast data for each id of base record.

I'm developing a Help Desk application and need to create a column chart for priority. When a priority is clicked, its ID should be stored and passed to a drilldown grid but the current code is displaying the ID as the label instead. a!grouping( field: 'recordType!HD Request.fields.priorityId', alias: "priorityID ) If I use 'recordType!HD Request.relationships.priority.fields.value' directly in the field, it throws an error. Any suggestions on how to display the label name? Thank you!

Hi All,We faced one issue during deployment to production. We have an API which triggers a process model and we are saving into database using write to records. Yesterday we added a new column to that record and it was getting deployed. During that deployment window, we received some cases via API. Details were getting written to database but while trying to query data, no data was being retrieved. The record was being updated and sync was occuring during that time. This is the first time we are facing such issue. Has anyone faced similar issue? Any reason this might have occured??

Hi Team, I'm using the Document Classifier to distinguish between Medical Certificates and other document types (e.g., doctor prescriptions, blood reports, etc.). My goal is to extract data only from Medical Certificates after classification. I am using the AI Classifier Skill, which returns a list of classified documents in the following format:  The output of this is a list  say : [classifiedItem=325673, type=Medical Certificate, confidenceScore=94, errorMessage=],[classifiedItem=325672, type=Medical Certificate, confidenceScore=95, errorMessage=]  To process the classification result, I wrote the following expression to match each classified document with the corresponding uploaded document and then extract data only from Medical Certificates: However, I have noticed that even when the classification result contains multiple values, Appian is treating the entire list as one single value, instead of iterating over each item properly. (Screenshot below) a!loca

I have the local variable called "encargo" to get a single record from a RecordType filtering by an id key. I want to get all the fields of the record type. Is there any way to tell it to the "fields" parameter or have I to list all of them instead?: local!encargo: a!queryRecordType(  recordType: 'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian',  fields: {    'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian.fields.{85cdc5be-fc56-425c-9ec2-f9e617124992}id',    'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian.fields.{48d20aa7-6bfb-42ac-9ea0-0396fafa7ffd}fechasolicitud'  filters: a!queryFilter(    field: 'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian.fields.{85cdc5be-fc56-425c-9ec2-f9e617124992}id',    operator: "=",    value: ri!id  ),  pagingInfo: a!pagingInfo(startIndex: 1, ba

Hi, We are using a styled text editor for the email body. Once the "Send Email" button is clicked, the email is sent, and an EML file is created. The emails in both Spanish and Portuguese are being sent correctly, with proper spacing and special characters appearing as expected in the translations. However, when generating the EML file, we encounter an issue where special characters are replaced with question marks or empty boxes. Additionally, spacing and line breaks are not preserved; instead, the content appears as a single paragraph when the EML file is opened. We are using the "Create EML File from  OOTB Poller" Smart Service to create EML File. In English is working properly and we are facing issue in Spanish and Portuguese

Felw amount fields i have created as DECIMAL in Database, but it got mapped as INTEGER in Appian record. How to get decimal as a datatype in Appian as well? What should be the source field datatype to achieve this?

I have a excel sheet where the cell values are refered from different location as highlited below Here the value 4.00% we are getting from different document, if i try to extract this data using  function - excelreadcellsbynumber() I am getting below error. How can I extract such kind of data?

We have few process model to trigger with email, these process models are triggering even if we activate maintenance window in admin console.  What can we do to hold these mails to trigger the process model until maintenance window is deactivated. We can use gateway/is deployment flag constants to divert the flow, can we do anything other than this

Hi, I am checking whether any deprecated functions are used in our application objects using expression search. When I search for the deprecated function buttonWidgetSubmit, all process models with user input tasks are displayed. However, these process models and interfaces in user input tasks are not actually using this function. I also created a new process model from scratch and applied the same search criteria, which listed the newly created process model as well. Can you help me understand the issue behind this?

Hi Everyone, I'm facing an issue with importing my application to target envt. I'm using manual export and import option here. I have even tried to put the ai skill object alone in a separate package and tried to import and getting the following error :  An error occurred while creating aiSkill [uuid=00c07df7-3153-40dc-a697-e8a8afa54afe]: An error occurred while calling another system. Try again later. (APNX-1-4569-008) (APNX-1-4071-007) Note : The source and target environments are in same version(24.4) Thanks in advance!

Hi All, Is there any way to automate Appian Application (App Server, search Server, data Server and Engines) shutdown and start for Appian on premise? Thanks

The Appian product works with its own database in which it stores its internal process data or Record Type synchronization, right?So, if we want to have a database in which we store, for example, Master or audit data, is it advisable to use the Appian databaseor create another one for the project we are developing?Thanks.

I want to know how to implement "Convert base64 values to Appian documents" without using an integration object. I have implemented a process that retrieves attachment information from an external database via HTTP connection and converts it into an Appian document.The process is as follows: 1. On the interface, execute an API request (an integration object) without "Convert base64 values to Appian documents", obtain information on 10 attachments, and store it in "local!fileList." 2. Perform a check: "If any of attachments 1 to 10 is not null, then the result is true; if it is null, then the result is false" and store the result in "local!notNullFile". 3. Press the "Get File (ファイル取得)" button.　 If the 10 file information items are judged to be false in "2.", nothing will be done.　 Only if the result is true will an API request be made with "Convert base64 values to Appian documents" enabled. 4. When th

Getting this error on comparing one particular record while it works for comparing other records. Tried to delete the record and create new and deployed to QA but still on making change same issue comes. Checked the security same as other records. Part of all admin groups of record security. Not sure what is the problem with this record type alone. even deleted the table in QA and recreated again from DEV with DDL picked from DEV db. Everything is same. When change is made its showing as Changed on comparison but on clicking what changed the attached error is coming.

Hi Team, I’m using the Document Classifier to distinguish between Medical Certificates and a Statutory Document. I’ve trained the model with 21 Medical Certs and 12 Statutory Docs. The incoming documents are predominantly (80%) Medical Certs, followed by Statutory Docs and other unrelated documents. The goal is to classify incoming documents and extract data using AI only if the document is a Medical Certificate. However, I’ve observed that the model is classifying random, unrelated documents as Medical Certificates with high confidence.(note the one - "use arrays functions exercise :(an Appian training exercise) and "blood report" Has anyone encountered a similar issue? Any suggestions on improving classification accuracy and reducing false positives? The metrics are not helping too, I haven't seen them changing? Is IDP classification not meant for unstructured files?

Has anyone ever created a query for Security Groups?  I need to pull the security groups for an application.  If I were smarter or more experienced, I would have created a Group Type of System to enter the system abbreviation for the security group when I first created the application.  In that way, I could have used the a!groupsByType() function.  The only way to do that now, is to create all new security groups and go through all of the application objects to reassign the security groups for all applications!! :( I created an expression rule to pull all of the custom security groups.  It returns all of the custom security groups from all of the applications when I am looking for one application. The data is returned with type List of Variant.  It seems to me that there should be a way to filter the data returned to see if the name contains the application abbreviation I am looking for.  I'm stuck on how to do that. a!groupsByType(cons!PMSO_Custo

Hi Team, I have configured a webApi to download CSV document on click, it's working when I use it in web browser but the same is not working when I use it in mobile device (Appian Mobile application). Could you please suggest the alternative ways to achieve a document download on single click? Thank you in advance

Hi all. I'm starting a new app and I have big dilemma because I don't know if is better to use CDTs or Record Types. I won't connect directly to a database to get/post records but I'll connect to a webservice to do so. You have to keep in mind that the records can be added/modified/deleted from Appian calling webservices or from other non Appian applications. So, If I use Record Types, I'll get the refreshed records without sync every few minutes? Has anyone experience about this topic? Thanks in advance.

Hi all, I'm trying to set up an Integration that can send files from Appian to an Azure Blob Storage. I have the URL to the storage and the required SAS token, but I am not sure how to set it up properly in Appian. I created a HTTP Connected System and set the SAS token as a parameter. However, when I try to test the request via an Integration I'm receiving a 409 "Public access is not permitted on this storage account."  I was able to successfully connect and upload/delete/modify data via the Azure Storage Explorer with the same token, so I'm confused why this isn't working. An issue with a firewall? Mistake in configuration?  Appreciate any insights, maybe someone else had the same issue before and was able to solve it. :)  Best, Matthias

Hi Everyone, I have a model where data management is set a delete in 0 days but when i look at the process model metrics, its still showing as orange, want to know further how does AMU works here. Looking for more insights Thanks, Bhargavi

Hi All, Appian used to have the capability of exporting the report in single click on legacy portal. But now that default download capability is available in Record only but not on reports. Do we have any way to implement it as Appian OOB capabilities?

Hi Everyone,I have a table with one column type as JSON datatype and using to save the data through write to records. Now I have to export this table data into excel file and share it everyday so I have created a CDT for that table.In CDT it is defaulted to text even I have given longtext datatype. Now there is an issue with the data as the database table have more than 4000 characters the CDT is not allowing more the 4000 so my data into excel is not exceeding more than 4000 characters.Please suggest how to handle this or any alternate better approach.

Scripts work fine in headless mode when I run them locally. But in Jenkins, the login page doesn't load fully, and the 'Sign In' button is missing so it throws an error when i use Appian 24.3 jar methods but the scripts running fine with page xpaths.. Can someone please help me fix this?