Discussion Categories

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?

We have a requirement to filter the Dashboard grid based on child table data. For each Company, multiple forms exist, categorized into different types (1, 2, 3). However, only one form is considered active. To determine the active form, we refer to the Form Uploads table, where: Status ID = 2 Source ID = 17 (Only these records should be considered.) The following filter is not working, likely due to an issue with related records filtering: a!queryFilter( field: Company.form.FormUploads.statusId, operator: "=", value: 2 ), a!queryFilter( field: Company.form.FormUploads.referenceId, operator: "=", value: 17 ) The query record type is Company, and we need to display Company data in the grid.

Can I create Service-Backed_Record with POST API which returns data on input parameter, How differently it works from GET API. What could be the possible I may face if I use POST API for Service-Backed_Record.

Hi Team, I have a requirement where the default date and time field should display the nearest rounded time. For example: If the current time is 3:54 PM, the default time should be set to 4:00 PM. If the current time is 4:01 PM, the default time should be set to 4:30 PM. Is there any simple way to acheive this

Hey AC, Does anyone know if we can use TAB as a delimiter option in the 'Import CSV to Database' Excel tools plug-in? The comma (,) is already provided by default which works nicely but was wondering if there is an option for TAB.If so, what would the character look like?

Hi I need help to configure mni with startprocess node whithin a process where I have details for exmaple 5 employees in that 3 employees can have same manager other 2 have same manager. I have a process variable of type cdt  employee. Now I want to sent mail to manager of the employees i will get the mail id from employee cdt which is 2 unique mail ids.  Now  want to send one common mail to that manager with that 3 employee details and  one mail to other manager who have 2 employee all at same process.  

Muy buenos dias  estoy realizando el curos de APPIAN y el comunity no me esta dejando crear nuevos recorda Type ya no aparece esta opcion como antes en la imagen adjunta les muesto como apareceia antes y como esta apareciendo ahora  Alguien me podria ayudar por favor ?  quedo super atenta 

This are my interfaces and i want to fetch the animalsid after i send pen for maintenance and assign new pen to that animals

Scenario: I have a created a reusable fileUploadField component which I am planning to use in all existing fileUploadField field in all apps. I have created a rule inputs for all the parameters of the fileUpload field and passing values to the common component while calling it. In saveInTo of the common component I am calling a!startProcess which will run asynchronously(i.e. no activity chaining).  Issue:  When I drag and drop multiple documents to file upload, a!startProcess is being called multiple times. Is this behavior expected? i.e when I upload multiple docs at the same time, saveInTo will execute multiple times? Sometimes, when I upload multiple docs at the same time, getting the following error. (Especially when I upload 3 to 4 docs at the same time) Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = 50518:8f67a] in rule 'aco_fileuploadfield' : An error occurred while executing

As I am getting a list of text strings separated by semicolons in a single line, my focus is to split them into different values. After that, I need to convert them to users using the touser() function. However, it is currently showing [ID NOT FOUND] even though the email address is already present in Appian users.

HI. I attempted to do a rather large import of an application over our PP environments version. I looked over a record that had some Record Related Action name changes to it. Testing it afterwards, only half of the related action name updates took on import.  I confirmed the record was modified on import. Has anyone ever had this happen before?  I have no way to deploy proper changes due to this.

Hello, I have an interface which displays the data from the record type directly on a read-only grid, where users can select one or multiple rows and perform certain actions (not record actions). The issue users have reported is, that if they are on page 10 when they perform an action (let's say delete a row), it brings them back to page 1 each time and they have to navigate to the desired page all over again to continue. Additionally, if they also applied a sort of any kind to one of the rows, that also resets.Is there a way to make it so that users remain on the page they navigated to using the pagingSaveInto? I have tried multiple ways but nothing worked, the grid is always refreshed to page 1 after an action. Thank you! a!columnsLayout( columns: { a!columnLayout( contents: { a!gridField( label: "Failed File Emails", data: a!recordData( recordType: 'recordType!{a18957da-4220-4c94-ba

Is it possible to show the Word document using documentViewerField. current behavior- When we click on the tab to display document, its downloading directly Expected behavior- The document should be visible for like PDF and downloadable.

Good afternoon, I am having a problem when using the plugin, both for encrypttext and decrypttext. I am trying to access via SCS and I always get the error "Error encrypting value: This plug-in [com.unionbankph.plugins.aesencrypt] is not registered to access secured values ​​for the given external system key [Key]. Check the external systems plug -ins list in the Administration Console." even though the plugin is correctly in the credential's plugin list. I am currently using them in the following way local!base64Key: decodebase64string("pruebaencript"),local!eas: fn!encrypttext(valueToEncrypt: local!valor,scsKey: "pruebaencript",scsField:"Key",iv: local!base64Key), Thank you so much