Discussion Categories

Hi Experts, Is there any restriction in Appian on a service account with read-only access on Oracle database, to not be able to create the CDTs using those table. In my current application I have been provided with credentials for the account which has only view access for the tables. I have configured the connected system with provided credentials. But when I'm trying to create CDT's I can only find the Schema Name but not the underlying Tables. Please suggest.

Hi Experts, Kindly help me to impletment the Audit Log Functionality, Requrirement is as if any fields get updated to a new value, I have to show the Field name shich got updated along with its Previous Value and New VALUE along with Who has done the update and WHEN i.e if Original value is a!map( id:1, fName:"ABC", lName:"XYZ", DOB:11-05-1995, phone:"1234567890", ) and updated value is a!map( id:1, fName:"CDF", lName:"XXX", DOB:11-05-1995, phone:"1234567890", ) Serial number Field previous value New Value Updated By Updated On 1 fNamelName ABCXYZ CDFXXX (Username) (12-10-2022) 2 Thanks

hi, my query is if i want to read xsl document  details in expression rule is any function for this

Hi, We have a database table where data gets dumped in a regular interval by a ETL job. We are using database Backed record with synced functionalities. Now, we need to sync/import newly inserted data to record in a regular interval, but FULL SYNC cannot be done automatically (more than once a day). Is there any way to get those new data in Record?

Hello i'm just trying to get the name of the past month, im using this code:  proper(text(today(), "MMMM")) But it only generates the name of the current month Thanks!

Hi, I'm using an Integration component to call a REST API that allows to return a PDF file (the input is a document ID). In the Integration Response Body Parsing selection, I've chosen the "Convert binary to Appian object" option to store automatically the document in Appian. All works fine, the document PDF is retrieved then stored in Appian KC. The issue I meet is to deal with the error case:When the API is called with an incorrect Document ID, the Integration error output result is stored in Appian as a Json file. But I don't want this Json file to be store in the Appian KC. If I want to choose the "Return raw response body" to manually deal with the raw body response, could you tell me how may I manually convert and upload the binary content to a PDF file in Appian please ? Regards

An error occurred while evaluating expression: expiredContracts:rule!TCT_ContractDashboard_Status_Expired( waitingOnCustomerAndApprovar: pv!waitingOnApprovaAndWaitingOnCustomer) (Expression evaluation error in rule 'tct_contractdashboard_status_expired' at function a!forEach [line 3]: Error in a!forEach() expression during iteration 10: Expression evaluation error in rule 'tct_docusign_getenvelopedefinition': com.appiancorp.connectedsystems.templateframework.functions.pipeline.proxyDecoratorPipeline.TemplateInvocationException: Contact the developer of this template to resolve the following issue. java.util.concurrent.TimeoutException: null)

Hi All, I have the requirement to close the process task after clicking over the button in interface? Can anyone please help me out?

Getting Below error while retrieving Data. Expression evaluation error at function a!queryEntity_18r3 [line 4]: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [VIEWDT6164], query: [queryentity expression], order by: [[Sort[eventType asc]]], filters:[null])

Hi all,   Wanted to ask the community to see if anyone has some best practice recommendations to handle the edge cases caused by Appian limitations in how it detects null/empty values and how it converts null singleton types into array rule inputs; and especially recommendations on setting up re-usable query entity rules.   We've discovered that Appian handles nulls in unintuitive ways depending on the data-type. If a rule input is an array, and you pass in a singleton of the same type that is null, Appian will automatically convert that input to {null} (a one element array where that element is null), rather than null or {} (empty). According to Appian support, this is the expected behavior of the product.   However, this causes two issues for us:     The out-of-the-box isnull() and a!isNullOrEmpty() functions return false, despite a reasonable assumption that the value is null/empty. (It is not. It is a one element array with that element being null, due

I am on the Exercise where I have to change the image to a document image I was initially getting an error as it was like the documents was missing there but managed to add the images to my app. I have keyed the code under the expression editor. a!imageField( images: a!documentImage( document: fv!row['recordType!{c20ff609-5f40-4fea-8800-074abc464c7c}AX Vehicle.fields.{f1cb1cdc-1134-40e8-b30b-0b90d32da455}vehicleimage'], caption: fv!row['recordType!{c20ff609-5f40-4fea-8800-074abc464c7c}AX Vehicle.fields.{f1cb1cdc-1134-40e8-b30b-0b90d32da455}vehicleimage'] ), size: "SMALL") I now get this error below.

Hi, when I am creating the record type using an entity that contains transient value it's throwing an error. ERROR: "Preview currently unavailable due to an error on the source" I have checked the data source multiple times by doing save and publish and the data source not showing any error, it is successfully publishing. can anyone please help me with this error ...

Where can I find the Appian Foundations Learning Path or Course? When I go to Appian Academy, I see courses for Seller, Planner, Administrator, Builder, but none of them contain a course or Learning Path entitled Appian Foundations, which is mentioned on Appian Customer Case Studies page Lesson 6 of 6?  Thank you!

Hello, Please could someone help me on what I need to write in the Related Action configuration of the Delete button for it to work and delete the record from site as well as DB.

Hello, I want to Edit the EXAM Table  The edit button is working but instead of updating the record it's creating new record. What exactly am I doing wrong? Also, I want a delete button which will delete the record from the SITE as well as DB. What do I need to do for that button to work? Could anyone please help me.

Hi all, I have use case where i need to separate the characters & integer value example- I/p: "ABCD1234"  output: ABCD, 1234   , i/p "A22B45" o/p: AB , 2245 Thanks in advance

I'm facing the following error when attempting to create a datatype. This pops up whenever I select the data source, regardless of the selection. I did not show the expression fully because it is incredibly large.  The application has just been created, with only one empty data store and some interfaces.  What could've caused this? Is it a system error? Does it have any solution?

i use integration to get country , state , District name with using pincode , i use read only grid to display result but i want only 1 row result how can i do that ?

Hello community, can anyone suggest me how to get second highest number from an array. Thanks in advance

Hello, I stumbled upon a little problem with IDP. When I extract data from Appians built in IDP, the document is processed nicely, I can see the document clearly. But when I created a process from tutorial:  https://docs.appian.com/suite/help/22.4/create-doc-extraction-process.html  I can see something like this in Reconcile form: It looks like Appian does not recognize language, except 2 words, and whats stranger for me, extracted data is fine, both from auto mapping and from manual extract. What may be causing this situation and whats more important, what can be the solution?  I'm trying to skip reconcile part, but I would like to show to my supervisor some results and I want to get rid off the view like in screenshot above. Also one more question about IDP and its "learning".  Does IDP learn only when it writes data to database? In the built in IDP, when i uploaded few files, there is a progress with how well he captures d

Hi, Is there any way I can get the size (number of rows) of a view by running a code in Expression Rule? In addition, Is there any way I can write SQL queries directly in Expression Rule? Thanks in advance

I have been using the 'Send Email' node recently, and after a while (and some trial and error) I realized the node was sending the emails to my spam folder. Is there a way to specifically tell the node to send it to a specific folder/inbox (such as my main inbox)?

I have used nested foreach and cardlayout inside that im getting the below output. Below is my code. a!columnsLayout(                    marginBelow: "NONE",                    spacing: "NONE",                    columns: {                      a!forEach(                        items: 1+enumerate(2),                             &nb

I want to show a message to user, and it should be disappeared after few second how can i do this

We have an bug where: WHEN a user is in a user input task and allows the timer (1 hr) to terminate the task THEN they are stuck in this screen and not able to close out of the task with the EXCEPTION of closing out of the tab.    My question is besides extending the timer is there any way to circumvent this error or allow users to exit out of the dialogue box without closing the tab?