General

Hi, I am generating PDF from DOCX  value is displaying correct in doc file , but it is overlapping in PDF How to reslove this ? DOC FILE: PDF :

Hello All, While updating CDT, got below error An error occurred while trying to write to the entity "SEC_IPOMarginMapping" [id=a6da64a0-8b67-4c95-9eee-0073b364a76c@705410, type=SEC_IPO_Margin_Mapping_List (id=9412)] (data store: SEC Securities DS). Details: javax.persistence.EntityExistsException: A different object with the same identifier value was already associated with the session : [SECIPOMarginMappingListDT22360#2] Data: TypedValue[it=9413, v={array of values}. The Unique identifier column is set to auto increment. Please advise. Regards.

Dear Team, When I am working on a case in workspace, I observed that unless I manually change the case status and assignee from the 3 dots button, these fields do not change automatically. Is this an expected behavior? For example, even if all the tasks of a case are completed, and I manually do not change the status, the status remains "open".

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.

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

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

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 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 all, I have an API to call from our application, in which we need to send message timestamp in ISO UTC format "2025-04-02T15:57:77Z" So now apart from formatting the date time with concatenating T and Z, do we have any other function which can directly convert time to this? 

I can see appian is allowing to give lead developer exam directly, is that possible without associate and senior certifications. Please tell your thoughts about it.

Hi all, I’m getting a 403 Access Denied error when trying to open a workspace. There’s no visible owner for this workspace on my end. Does anyone know if access must always be requested through Appian Support, or if there’s another way to resolve this? Thanks in advance!

Hi, Can you please help me how to give validation to the Textfield, where it should accept only Alphabets. If any special characters or numbers entered it should throw an validation error message. Is there any function is there?

Hi everyone, With Appian 25.3, a new version of a!queryRecordType() was introduced, and the previous version is still available as a!queryRecordType_25r2(). This evolution brings more control and clarity over which fields are retrieved. Key difference between the two versions 25.2 - a!queryRecordType_25r2() When no fields are specified, all base record fields are returned automatically. Even if only relationship fields were passed, the base record fields would still come back unless explicitly narrowed down. 25.3 - a!queryRecordType() When no fields are specified, only the primary key (id) is returned. To retrieve all fields, the new a!selectionFields() function should be used with its allFieldsFromRecordType parameter. Why this matters for wrapper rules In our applications, most queries are wrapped in a reusable rule that takes a single fields input. Callers of these wrappers don’t (and shouldn’t) need to worry about the function version or its internal

Hello,Consider the following test code: a!localVariables( local!Torerance_Name:"Mean", local!test_0: and( local!Torerance_Name = "Mean", "15.0" ), local!test_1: and( local!Torerance_Name = "Mean", "8.2" ) )Here test_1 has value : false and test_0 has value true.What is the cause of this? Please find the screenshot as follows:

Hello Everyone, Is there any approach to retrieve a user's last login details without accessing log files? For example, is there a function or method we could use to capture login information when a user accesses a specific link or application? Thanks & Regards, Srikanth.

Dear Support Team, I am trying to schedule my Appian Certified Associate Developer exam, but I encountered the following issue when accessing ProctorU: "This Institution does not permit creating a ProctorU account. Please navigate to your course Learning Management System for scheduling and rescheduling ProctorU reservations." I attempted to register directly on ProctorU, but I was not able to proceed. I understand that scheduling must be done through the Learning Management System, but I am unsure where exactly to do this inside Appian Academy. Could you kindly assist or guide me through the correct steps to schedule the exam? Thank you in advance for your support. Best regards,

Hi , when we are uploading the document in the folder directly is appearing in the recent objects with the uploaded time.but when the document is uploaded or generated by the flow is not appearing in the application recent objects.we have to go into the specific folder where we configured to store and there only we can find it specifically.those kind of documents are not appearing in the all objects.why is the difference.

Hi, need suggestion for the following requirement. We want to place a CSV file generated through Appian within a specific folder path in NFS(Network File System). Appian runs in an EC2 AWS instance and the NFS is a on-prem file location. We are not permitted to mount the NFS and hence looking for solutions.

This is my usecase. i have editable grid of data  and also providing user to do the (custom) filter and sorting. But now user want the export those data into excel.we have used EXPORT DSE to Excel smart service to do that. But here the challenges is user applied sort is not working when we export the data. I don't know how to configure that. Can anyone help me here.

I have a read only grid that is supposed to populate with all entries in a record with a certain flag and put that into a read only grid. The problem I run into is that despite the grid displaying only 3 entries at a time, the query keeps timing out because of how large the number of entries is. I need all entries to be available for my functionality and it is set to load as async. Is there a way to bypass the query timeout error?

Hi , I have a multiple dropdown inside a grid layout , so choice values for that dropdown  previously static one coming from database , but now we have changed it as cascading one based on condition the dropdown choice value will change. Now the existing request are all throwing error. I thought of based on the request created date to change the choice values to be selected but i am not sure where that condition can applied inside the dropdown choice or before , because for new request also for choice values i have applied some if condition . Its not working properly. Can anyone help me to identify the option which is efficient?a!localVariables( local!fundlookup: { a!map(lookupId: 1, value: "Comment A"), a!map(lookupId: 2, value: "Comment B"), a!map(lookupId: 3, value: "Comment C"), a!map(lookupId: 4, value: "Comment D"), a!map(lookupId: 5, value: "Comment E"), a!map(lookupId: 6, value: "Comment F"), a!map(lookupId: 7, value: "Comment G"), a!

I have below grid of data but i want to sort the below data by Month. User have dropdown option to select sort field as month and sort by like ascending or descending. The challenges am facing here is , since we kept month as text field its sorting in an Alphabetical order. can anyone help how do i do the sorting to get the month in a calendar order (Jan to Dec). Month        Vehical Brand    Repair  NewApril           BMW                 Yes      yesJanuary     Tata                    No       yesDecember Toyato                yes      No March        Audi                   Yes      yesMay           Kia  &

I'm facing an issue related to timestamp precision in an Oracle table that’s used with Appian. The table has two timestamp columns: one with zero precision (Datatype - TIMESTAMP(0)) one with six precision (Datatype - TIMESTAMP(6)) When I insert data into these columns without any triggers enabled, everything works as expected: the zero precision column doesn’t include milliseconds, and the six precision column includes milliseconds. However, when I add a trigger to the zero-precision column, I get an error saying the actual timestamp precision is 7, but received 11 even though the column is defined with zero precision and the trigger only defaults it to SYSTIMESTAMP if null. Why would the trigger suddenly cause exception , wanted to understand the logic better 

if( rule!APN_isBlank(singlePV: ri!date), "", /*left(text(ri!date, "mmm",3), ri!format))*/ left(text(ri!date,"mmm",3), ri!format)) Following is the error  Expression evaluation error at function 'text' [line 7]: Signature length (2) does not match parameter length (3)

Hi i have a process variable called request_data which is cdt type and in that there was one column called casettnotes which is a cdt casenotes cdt has currently 4 rows of data in that there was a column casenote which i need to update which is 4th row case note column data for this i dont have primary value it was null so i tried using other column which is issuetype like if issuetype is failed then update casenot for that issue type like that, all i want the casenote column which is 4th row column in casettnotes cdt need to be updated how to acheive this tried using many alforeach with update function but nothing working kindly suggest on this