Discussion Categories

Hi I have a table in my appian/Jdbc database and I am using write to Dse smart service to persist data into that table. Is there any log file in the system logs which tells me what data is written to what table and the timestamps ? Thanks

Lets say I have an Interface with 2 Dropdowns. Lets call them Dropdown1 and Dropdown2. Both have Values Yes and No. If User selects Dropdown1 with Value Yes, then Dropdown2 should automatically be set to No and it should be greyed out or disabled so that User cannot change it to Yes. Please advise how we can accomplish this. Regards, Mahesh

Hi all, We have a connected system with OAuth 2.0 Client Credential Grant. From the connected system we can Authorize with no error. Now, the token we get is valid for 24 hours. The problem is, after 24 hours, the integration calls fail with Authorization error. And when I go to Connected System and click on Authorize and run the integration again, it works perfectly. Does anyone know why this may be happening? I checked and the security of the integration and connected system is set properly. Thanks!

HI All, Example -- I am forty-five years old. from above text i need to get 45 in integer form. How to achieve this? Thanks, Ganesh. 

I am currently reviewing the Appian pricing structure and plans, and I’m a bit confused about the difference between "Platform User" and "Application User". Could someone please clarify the difference between these two types of users in terms of access and entitlements?

I have a Parent Summary interface that I want to add a record action button to that creates an entry in a child table. Adding the button is easy enough, however adding that button alone doesn't connect the Parent to the child when using the button. So what steps am I missing to make that connection?

Hi Team, I have to show KPIs information in Dashboard based on a specific user logged in and for a specific status. For example, For user1 when he/she logged in, he wants to see how many active/completed cases showing as KPIs Dashboard. I don't want to handle that in the interface, because that will take a considerable amount of time and hit the performance. Instead, I want to store that info somewhere for example in custom record field; but again, I am not sure that also feasible. FYI: assignee info and status are part of the case table not in any related record. Any other suggestions? Regards, Ghanashyam

Hi. I was trying to upload a file to Box from Appian, but the following error occurred, so I am posting this. I'm getting a Media Type error, but I'm not sure if the Request Body is written incorrectly or if I'm not connecting to Box's upload API. If anyone knows please let me know. Details below.・Integration Object ・Box account Free version for individuals   I'm guessing that the upload API cannot be executed with the free version of Box, so if you know anything about that, please let me know.   We apologize for the inconvenience, but please.

There is a requirement to trigger a scheduler at 2 PM , 10 PM and 6 AM. When scheduler will trigger, it will invoke an API by passing the last execution time to fetch set of data between last execution time to current time. Say for an example, if scheduler runs at 2 PM, then it will pass 6AM as parameter to the API so API can return data between  6AM to current time (i.e. 2PM )interval. any suggestion how to implement this following the OOB configuration? TIA

I want to implement a user-defined feature that allows specific fields to be displayed and the order to be adjusted. For example, I currently have 5 columns(column 1-5) in readonly grid, and the user can present 3 of them as needed and can adjust the order, e.g. display [column 1, column 5, column 3]. Is there any way to implement this feature? Can you give me some advice?

Has anyone gotten the following error (or similar) for the systemlogsrecordtypesource function? It's for the the Log Reader plugin. Expression evaluation error at function 'systemlogsrecordtypesource' [line 7]: The passed parameter(s) are of the wrong type. Received the type com.appiancorp.common.xml.JaxbConversionException: JAXB failure trying to convert typed value TypedValue[it=1474,v={TypedValue[it=1478,v=<null>],TypedValue[it=1154,v=<null>],{1,20,<null>}}] to java class com.appiancorp.common.query.Query. It's a simple few lines of code: systemlogsrecordtypesource( a!query( pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 20) ) ) Strangely, I cannot replicate this across environments. I've confirmed the environments are on the same version of Appian, so I am unsure what to check for next.

Hi Team,  The api call is working fine in post man but it is failing in appian with below error, there is no issue at the source side as well any suggestion why appian is throwing the below error [title=Connection timed out, message=The integration execution time exceeded the configured timeout, detail=No details available] Thanks,

Hello, I am running into a "Requesting File" error on all robotic tasks. The following is the trace log for one of them (with altered client information) but the same error is occurring for all robotic tasks: [INFO] 2024-11-14 22:57:38 - - Robotic task 'updateClient' (62ced40be4b01228753f64b2), execution #3674, technology JAVA, start method API, log level TRACE, testing mode is OFF, external workflow is OFF [INFO] 2024-11-14 22:57:38 - - Robotic task will run with following parameters: [INFO] 2024-11-14 22:57:38 - - Parameter 'client', value '{"#t":5266,"#v":{"Id":4,"firstName":"C","middleName":"","lastName":"H","ssn":"4","medicaidId":"K","dateOfBirth":"1900-01-01","specialInstructions":"This client was created in APP. Please go there for full client details.","primaryLanguage":"English","ethnicity":"Unknown","gender":"female","addressLine1":"","addressLine2":"","city":"","state":"","zipcode":null,"county":"","caseManager":"","phone":"7208299615"}}' (default value 'null') [IN

We work with several clients. Some want their environments in spanish or portuguese, so most of our envs are in english for our dev team and the client's requested language.A LOT of time is spent with naming our process nodes twice: once in english when we develop, and the other in whatever other lenguage the client wants. The only reason we do this is because Appian won't let us deploy packages if even one node in a process does not have the other language node name.This really hinders the devexp for something no one will see. Is there any configuration to allow for English to be a fallback language for the process? Lets say the process has no "Spanish (MX)" names attached to the nodes. In that case, appian would automatically fall back to whatever other name the developer added to the node (in my case "English") 

Hi Community,   I am working on a POC where a third-party system interacts with my Appian Web API. The setup involves the following: 1. The third-party system is configured to call my API endpoint: https ://appianCloud.com/suite/webapi/endpoint1 for a GET operation to retrieve data using query parameters. 2. In subsequent calls, the system appends /action or /response to the same endpoint URL and performs a POST operation to modify the data for the same record.   Given this requirement, I would like to know: • Is it possible to handle this type of scenario within a single Appian Web API object? • If not, are there any known workarounds or best practices to manage such dynamic operation variations?   Looking forward to your insights. Thank you in advance!

We got the above error from production. We are not able to replicate the error in lower environment. Can anyone tell what is the root cause of this issue?

Hello! We are in need of a Slovenian locale/translation for appian and I'm wondering if any of you have any suggestions as to how would we be able to get that specific locale? Is there any way to do a custom translation and import it into appian?  Thanks, Jan

Even i gone through the documentation i cant get the exact difference plz can anyone explain in easy and simple words 

Hi, I have data in record type.  I need to implement search field to get result from record type. By using a!queryRecordType it's matching exact content. For example: If we search " How to create record type ". we will get related data like below It is possible to implement similar functionality in Appian 

Hi Team, I have two CDTs with a one-to-one relationship, which I have already designed and stored. Now, I plan to create records from the database tables. However, I encountered an issue when trying to define the relationship in the records due to the existing CDT data model design. In my current setup, the child table's primary key is used as a foreign key in the parent table. My requirement is to fetch the parent table data along with the corresponding child table data. However, with this setup, I am unable to establish the one-to-one relationship in the records as intended, and I prefer not to make any changes to the existing CDTs. Could you suggest a solution or provide guidance on how to achieve the desired relationship in Appian records without altering the CDT design? Parent :TP_EmployeeDetails TP_EmployeeAddress

Hello, all I have been requested to use the record picker component and use the selected records in the picker  to filter out the records (by identifier) in a read only grid.  The record picker returns a list of variant and I need a list of integer in order to use the filter in the grid, otherwise it will return an incompatible type error. Is there any way this can be done ? the local!selectedApprovalID does return the values I am looking for, but I am getting an error :  " Cannot apply operator [IN] to field [approvalId] when comparing to value [TypedValue[it=197,v={TypedValue[it=1,v=12],TypedValue[it=1,v=23]}]]." There was an answered question in this forum to use the index() function, but that also returns the same error. Please help,   been stuck with this issue for some hours now. Thanks.

In a template i need to give a link for Docusign to display as a link what should that be configured as in Appian side?We're getting radio button from radioGroupTabs, but we need to send link as text tab, say as tooltip parameter. But I'm not sure which parameter to use for the link  

Hello, In Admin Console, we have configured "Idle Session Timeout" as 20 minutes . The users authenticate using SAML via SSO login. However, we observed that the session is not timed out in 20 mins always. If we open multiple tabs, certain tabs are timed out whereas few are still logged in after 20 mins. Is there any reason or configuration change which needs to be done? Thanks in advance..

Hello Appian Community, I am currently using AI Skills in Appian to extract data from a document. The extracted data is being saved as text at the process model level. However, I need to convert this text into JSON format for further processing. I attempted to use the a!fromJson() function to convert the text into JSON, but I am encountering an error during the conversion. Here is what I have tried: The extracted data is stored in a process variable of type Text (e.g., pv!extractedData). I tried using a script task to convert the text to JSON using: appian Copy code a!fromJson(pv!extractedData) However, this results in an error. Error Details: My Questions: How can I ensure the text data is valid JSON and successfully convert it? Are there specific considerations or configurations required when working with AI Skills and JSON data in process models? What are the best practices for handling such scenarios? Any guidance or examples would be greatly appreciated!

I got a requirement that i have a data from db record 12800 i am using filter to filter the environment type that grid contains id, data, task,count,environment in that grid date is initall scatteered like 24-02-2024 00:00 and in another row 24-02-2024 10:00 like that i want all similar date should be in in single date and need a link near to that date filed on clicking that it should show time along with particular date and tasks enviromnets and other related data to that date field can anyone help me on that