Discussion Categories

Hi team, I'm exploring options to fetch user login audit logs for extended periods such as the last 3 months, 6 months, or 1 year. Currently, I only see daily login audit data available. Is there a more efficient or consolidated approach to retrieve historical login activity over longer durations? Any guidance or best practices from the community would be appreciated.

I am trying to invoke an Appian web-Api using Insomnia, which is a GET method, it queries db and fetches results.I am passing the Api key as header in insomnia.I have mapped the service accounts and security every thing correctly, but still i am nit able to invoke the API.I am getting this error : Error: Couldn't resolve host name

I passed the ACD101 certification exam, where can I see the breakdown of how many answers I got right by category? The screen closed immediately after I finished the exam.

Hi everyone, I'm running into an unexpected issue when trying to delete a document immediately after uploading it through an integration in the same process model. I have an interface where the user uploads an Excel file, which gets stored temporarily in Document Management. From that interface, I start a Process Model that looks like this (see attached image): Start Node Gateway → checks if a document exists HTTP Integration (CEDT_INT_postUpload) → sends the file to an external endpoint Delete Document → deletes the temporary file after upload End Node When the process reaches the Delete Document node, it seems that Appian hasn’t finished handling or streaming the document yet. As a result, the integration fails or the file never actually reaches the destination folder. If I remove the Delete Document node (or move it to a later step, e.g., after a short delay or in a separate subprocess), everything works fine — the upload completes successf

Hello,I am trying to create a custom UI component that will take input the image reference, height, width and unit (px, pt, %). It will display the image in the UI with provided height width. I need this as it is on of my requirement. I need to set custom height width of image.Now, How to achieve this. I had created a project like below:custom-image-plugin/ ├── webpack.config.js ├── package.json├── appian-component-plugin.xml└── src/        └── customImage/                ├── ImageComponent.jsx                └── index.jsBuild this component and added to the zip file the build js and appian-component-plugin.xml and trying to deploy as plugin, but it failed. Can't find any logs why it is failed.Help needed1. How to achieve this? 2. Where to find the logs for the failure.

Hi all,     I want to extract all the data of table (multiple table) and export to excel and generate report and then email. we don't have CDT we use record type. please help me how to extract data from record type or database and export to excel, generate report & email. What i have tried:  I used Export SQL to Excel plug in with sql query and Jndi name which is my data source but it is throwing me error as "The following error was raised by the Export to Excel function:  null". Please help me to resolve this issue or if there is any other way let me know. Thanks

Hi All, I basically created a custom between date for my users. The purpose of it is basically to mimic the start date of a month to the end date of the month for my data. Shown below is basically what it does: My question here is this. From my understanding, Appian's database stores any datetimes column as UTC, before converting it back to whatever timezone the user is from during the interface display. However, what exactly should I set as my between date during the process of filtering? I'm unsure of how exactly the query filter will communicate with my cloud database (my record type) to retrieve data. My worry is that the values are inaccurate and data is wrongly displayed and calculated due to the some edge cases, e.g. on the last day of the month. Here is my code for the between: As you can see from the "Chosen From Date" and "Chosen To Date", I initially attempted to custom fit it to my timezone. During this process, I returned the value create

Hi All, I am getting the below error at the bottom of interface canvas when configuring the GridPlus component. I am on Appian version 25.2. Error: SyntaxError: Unexpected token '<', "<!DOCTYPE "... is not valid JSON Use case: An user input grid where user can copy and paste large data set from excel  I have followed the documentation and all the expression rules(queryRuleName, columnConfigs) are working individually. Any guidance will be appreciated. 

Hi Everyone,I am trying to export a view from DB using "Export DSE to Excel" smart service but often it's failing throwing the error.The view is a simple view with 13 columns and with hardly 5k data, we are using filters also when we are trying to export using that smart service but still it's failing.Any leads would be appreciated.Here i am attaching the error i am getting.Thanks in advance.ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=28413, classname=com.appiancorp.process.runtime.activities.DataExportEntityExcelSmartService2 com.appiancorp.suiteapi.process.exceptions.SmartServiceException: Error accessing data store entity: Entity_Name. Please contact a system administrator for additional details. at com.appiancorp.dataexport.strategy.QueryExceptionStrategyDse.getOriginSpecificException(QueryExceptionStrategyDse.java:20) at com.appiancorp.dataexport.strategy.QueryExceptionStrategyBase.makeQuery

How to remove duplicate letters from the string without changing case of letters input "Deleted" output "Delt"

I’ve set up a date search in my Appian interface backed by a Cloud DB table. When users select a date, it updates a rule input, which is then used to filter records. The filtering works well and shows only the data for that selected date.query: a!query( filter: if( isnull(ri!onInputChange), null, a!queryFilter( field: "createdOnDate", operator: "=", value: ri!onInputChange ) ) But, when I am adding the interface as a page to the Site, I am getting the error below:Error Evaluating UI Expression Expression evaluation error [evaluation ID = 296a3:3b232] in rule <table_Name> : Cannot apply operator [EQUALS] to field [createdOnDate] when comparing to value [TypedValue[it=49,v=<null>]].

I have created a web api for uploading documents into appian applicationa!localVariables( local!body:http!request.body, local!key: http!request.pathSegments, local!keyNumber:regexfirstmatch(pattern: "\d+", searchString: local!key), local!requestStructure: rule!PRE_FormatRcoDocumentRequestFromMyWorldRequest(jsonRequest: todocument(local!body), key: local!key), if( or( a!isNullOrEmpty(local!requestStructure), a!isNullOrEmpty(local!key) ), a!httpResponse( statusCode: 400, headers: { a!httpHeader( name: "Content-Type", value: "application/json" ) }, body: a!toJson(a!map(error: local!requestStructure)) ), a!startProcess( processModel: cons!PRE_PM_UPLOAD_DOCUMENTS, processParameters: { uploadDocuments:local!requestStructure, intakeMain:'recordType!{9228ede4-797f-443e-ba77-59aeed242b7a}PRELUDE Intake Main'( 'recordType!{9228ede4-797f-443e-ba77-59aeed24

I have 2 synced records. The first one is notice and the second is notice history I have a grid that displays info from the notice history record, and I am trying to sync it when the related record of notice is updated, but it is not syncing.. My record type is: recordType!BTTNoticeHistory My identifier is: pv!notice[recordType!BTTNotice.fields.noticeID] Any help would be much appreciated!

I have a textField that I do not want users to be able to enter in a space unless it is a part of the case number. For example, users should not be able to enter this:  But if there are spaces in the case number, then it should be allowed I've tried regexmatch, I've tried a if / isnullorempty statement  example:  if( a!isNullOrEmpty(ri!notice), "Case Number is invalid.", null() )

Hi How do you use Sync Records Smart Service to fully sync a record type that was just modified by a back end stored procedure My case is new data comes in daily in CSV files - which gets uploaded into a set of temporary tables After this a stored procedure inserts them into the main tables that are connected with the record types. As of now we are syncing these record type manually from the web page I though this smart service would have an option to do a full sync, but it needs the IDs of the record types to sync - well these are unknown since they were just inserted by the stored procedure in DB so not available yet. Do I need to come up with another data base query to retrieve the new ID - form the database?

Hi, could you please suggest me better approach like how can get inactive user list in the environment and last login inactive user ? I have seen, we can get to know in admin console but if we want check without admin console like any functions to check? thanks

Hi everyone. The client has asked to use a particular Typeface. I have the Woff2 URL's on the admin console. However, when entering and inspecting the site, the typeface/font gives a 404 error. Investigating further, I notice how on the initial HTML script, the URL for the typeface/font starts with a "/suite" instead of the actual "https://" Has anyone dealt or experience a similar problem before?Thanks!

If multiple applications are hosted on the same Appian platform, and I want to create a separate schema in the Appian Cloud database for each application's tables, how should I reference a specific table within a specific schema when creating a Data Store in Appian? I initially tried querying using schema_name.table_name, but it didn’t work as expected. However, when I ran SHOW TABLES FROM <schema_name>, I was able to see the tables listed under that schema, which confirms that the schema and its tables are accessible.

Hi All,We had a process model in Appian that was scheduled to send a report every Sunday at 11:59 PM. Later, we discovered an issue with the report it was generating. Due to business requirements, we exported the process model, saved it locally, and then deleted it from Appian. I had assumed that the scheduled activities were tied directly to the process model, so deleting it would stop the scheduled execution. However, this Sunday, we received an error stating: Problem:  An error occurred in executing an Activity Class. Details:  Process Model has been deleted. Process designer could not be retrieved Recommended Action:  Examine the activity class to correct the error and then resume. Can anyone please help me to understand this scenario?

We currently have a system that allows users to upload documents. We are currently filtering out password protected documents using the ispasswordprotected() smart function. Recently we encountered a document that was "Restricted" (Please see attached image). Is there any function currently within Appian that allows the system to check if a document has any "Protections" on it at all. the above smart function does not account for the additional types of protections outside of passwords. 

I have a requirement where I have to trigger reminders to user a day prior 9 am their local time. For example, if user is from Asia/Kolkata time zone then he/she should receive the mail a day prior 9 am IST similarly if user is from Australia/Melbourne time zone he/she should receive the mail 9 am AEDT.Can someone please help with the approach?

I have a requirement where I need to send reminder emails to clients one day before at 9:00 AM as per their respective timezones. My environment timezone is Australia/Melbourne, but clients can belong to different timezones (e.g., Asia/Kolkata, Europe/London, America/New_York, etc.).

Hi, I'm attempting to upload a CSV file to SQL server database on Appian V23.2 The database table has been an existing one for the upload process which was originally an Excel document which got converted to CSV within the process model.  We're in the middle of changing this to do straight upload of CSV file. Issue we are having is that the CSV column names are produced from a third party site (Salesforce) and cannot easily rename the column names to match the database table names. sample CSV Column names: Opportunity ID# Account Name: Account Name Stage Opportunity Owner: Full Name sample database table names OPPORTUNITY_ID | ACCOUNT_NAME | STAGE | OPPORTUNITY_OWNER  Using the "import CSV to Database" smart service, it seems that both have to match if the file is headered.  No ability to have different csv column names to that on the database, even if the number of columns match.   Changed to java.lang.

Hello, we have implemented a send email and receive email process to process. When the send email process is activated, the receive process doesn't receive the email. The destination process ID is configured correctly. ¿Is there a log to identify what might be failing? Thank you very much.

Hi Appian Community, I'm currently developing a multi-regional application in Appian that will be used by Spanish-speaking users across different countries, including Spain, Mexico, and Colombia. While they all share the same language, I've noticed that number formatting conventions vary significantly between regions, especially in how thousands and decimal separators are used. For example: In Spain: 123.456,78 (dot for thousands, comma for decimals) In Mexico: 123,456.78 (comma for thousands, dot for decimals)  My question is: Does Appian automatically distinguish between regional variants of the Spanish language (like es_ES vs es_MX) when applying number and date formats? Or do we need to explicitly configure the full locale (e.g., es_MX instead of just es) for each user to ensure the correct regional formatting? Additionally, has anyone implemented custom logic to handle formatting based on the user's country? What best practices would you recommend to maintain co