Discussion Categories

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

I think is not possible to access directly to an Informix and dataverse databases directly from Appian Cloud but do you know if is there any work around? Thanks in advance.

Hi everyone, We recently encountered performance issues in our development environment and requested a restart. Before the full sequence could be executed, we have ran only: Code: appian_services_stop followed by starting it again without stopping the other components: appian_appserver_stop appian_searchserver_stopappian_services_stopappian_dataserver_stop We’d like to understand from the community: What are the potential risks or side effects of restarting only appian_services_stop? Could this lead to instability or partial recovery? Is there any known impact on data integrity, indexing, or service coordination? Appreciate any insights or experiences you can share. Thanks,

In docusign integration Generate the Recipient Signing url operation where should get the client User ID, what exactly it means ? Can you please guide me for this?

Team, We are on 17.4 version and trying to remove all process instances from one of our lower environment around 100k+. Do we have any function or plugin which we can use to delete them at once instead of manual deletion . Thank you.

Hi, looking for some guidance on how to send Teams messages from our App directly to a user. We tried using the Teams Plugin but found we were limited by only being able to send messages with authentication Authorisation Code Grant (Delegated Permissions), this was forcing each user to individually authenticate from the app, which isn't what we're looking for. We want to send chat messages directly from a System(Application) user. (I think this is a limitation of Teams rather than the plugin itself). We have found the below link on "Activity Notifications" in Teams rather than chat messages, has anyone had any experience with this? I'm just looking for confirmation that this method will achieve the results before I go down the rabbit hole. learn.microsoft.com/.../teams-send-activityfeednotifications Or if not, does anyone know any other way for us to achieve the desired behaviour? Thanks!

I have a complex database view that should be converted to an Appian Data Fabric (synced records) model for performance reasons.  I am able to recreate all functionality from the database view with the exception of the string_agg() function. It looks like the only way to access fields from one-to-many relationship record is in the list view/display layer. I need the data to be concatenated and available in the data model (i.e., custom record field) so that this column can be used upstream in a parent related record type.  Is there any way to achieve this functionality in data fabrics?