Discussion Categories

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 

Hi all, I am a new to Appian, and I am required to create a workflow in Appian. According to an article, I need to install case management studio to make it easily. My understanding is correct? Without case management studio, I guess it takes a long time to create workflow... I am trying to install a sql file..., but errors occur at step3. Appian Case Management Studio Overview - Appian 23.4 Step 3: Creating database objects Copy link to clipboard To create the structure for the database tables, views, and other objects that are a part of the Appian Case Management base application, you need to run a DDL script in your database. To create the database objects: In your MariaDB business database, import and run the 01.CaseManagementStudioBasev1.2.0.sql file downloaded in Step 1. May I know how to resolve the error? Hope your advice! Best regards,

Hi All,Is there an OOTB way to clear a text box in Appian, like the X within the text field?

I have the requirement of adding Event history comments for a record. As the comments needs to be encrypted, we can encrypt the data once it's written in DB. While getting the data in record I am decrypting the comments in the Record List Configuration. I am getting the decrypted comment in the record List but in the interface of Event History I am getting the encrypted text (same as DB) even after syncing the record. As in image, I want to apply the same decryption rule as "details" parameter over "comment" parameter. Let me know if we can leverage any function or is there any work around for this.

Hi team, I have requirement such that user can edit single rows and multiple rows as well and while using pm I'm able to edit single and multiple rows as well but there is another requirement such that while editing user  can only edit 2 columns name as: "Electrical Tilt" and "Comment" but while editing electrical tilt on single or multiple row user has to make sure if combination of these 3 columns: "Shared Antenna", "Transmitter", "Antenna PAFX"  are exactly same on any row then electrical tilt of those rows will automatically gets updated  I have mentioned the code of edit UI, please let me know what could be the best approach to follow a!localVariables( local!isShowtoSite, local!siteDetails: rule!SLS_QRY_getSiteSummaryDetails(siteName: ri!siteId), local!data: ri!transmitterDetails, local!updatedData: difference(local!data, ri!transmitterDetails), { a!columnsLayout( columns: { a!c

/resized-image/__size/640x480/__key/communityserver-components-multipleuploadfilemanager/99091518_2D00_115d_2D00_416d_2D00_a0fb_2D00_2f8360c6673f-289184-complete/pastedimage1732717760969v8.png Here i queried some detail ,it is in Ac in input tab but not give Save into , in the output tab(img 2) im updating the Ac value and storing in the Target in this case it is working fine but in the input tab if i give the Save Into the value is not updating in the output tabboth Save into and Target given only the Save into come out of that Script task or what

am trying to parse txt file of 7MB using readTextFromFile() but am getting Memory Circuit Breaker error did anyone else faced this issue and can anyone please suggest the alternative to parse the txt file which has large data Thanks in advance  

Hi, I am facing issue record type syncing system failure, after updating record in process. The primary key i am using is BIGINT type.

I have gone through several times, however I'm unable to understand why this error is getting.

I found an error in recordtype sync in tomcat log, but what is this error indicating? I'm not sure this is related to my recordtype sync error, in recordtype it only said 'Unable to sync due to a system failure' 2024-11-28 03:00:07,537 [RecordSyncScheduler_Worker-1] ERROR com.appiancorp.record.data.recordloaders.ads.RecordTypeAdsLoadService - Error creating join index for relationship with uuid: com.appian.data.client.AdsUserInputException: APNX-3-1000-06D: Invalid parameter specified to the createJoinIndex function. Attrs must reference valid attributes. Invalid attr ref(s): [e88c8e26-426e-400f-b196-58dad303f85c::318d243c-ab51-430b-8048-872019cb75f9] at jdk.internal.reflect.GeneratedConstructorAccessor521.newInstance(Unknown Source) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500) at java.base/java.lang.reflect.Con

I'm building a rule which will take 'Plugin Name' as an input (example:Excel Tools) and expected to return all the dependent object names where this plugin is referred in. Is there a way to achieve this? Manually, we can go to Appian Designer -> Objects -> Plugins -> select a plugin and choose dependents to get the list, I'm trying to automate the same behaviour. Any leads will be appreciated.

I have an integration services which gets data from an endpoint. I am using this integration to create a record type using record source expression. Then I have another 2 integrations which can add or edit the data. can we sync the data every time after using the edit or add integrations

how many related actions and record actions can be added in record, is there any limit?

Hi Team, I want to remove Process HQ site option on navigation menu, to my application users. But I see that this Process HQ group is used by all the applications in an env. So what if i want to remove access to users specific to an application? In the membership rule i couldn't restrict the users based on the group they belong. Do we have any alternative to make this work?

Hi Guys, Is there a way we can navigate between fields using arrow keys in Appian ? 

Hello, I have a use case where i have to provide all record Id's and record name in Picker Field. Users can select from it. I have been fetching only id and name column from DB table . Now the records count is less ,so it is fine. But in future if I have more Records what would be the Best Approach I can take on this.  Thanks in Advance!

Is it possible to have as first day Monday and not Sunday in date field?

Error in Appian while creating a robot - Expression evaluation error [evaluation ID = X7SEV] : An error occurred while executing a save: java.lang.RuntimeException: java.lang.NullPointerException

Hi Team, We have integrated dynamo Dv with Appian and accessing dynamo DB table. In appian front trying to create a Web service backed record but receiving an error : Can anyone guide me is der a way we can pass pagination and batch size to AWS from appian integration

a!localVariables( local!holidayslist: todate(text("12/25/2024", "mm/dd/yyyy")), local!select: {}, local!monthnames: { "JANUARY", "FEBRUARY", "MARCH", "APRIL", "MAY", "JUNE", "JULY", "AUGUST", "SEPTEMBER", "OCTOBER", "NOVEMBER", "DECEMBER" }, local!month: month(today()), local!year: year(today()), local!week: { "SUN", "MON", "TUE", "WED", "THU", "FRI", "SAT" }, local!blank: a!forEach( items: enumerate( weekday(date(local!year, local!month, 1)) - 1 ), expression: " " ), local!dates: append( local!blank, enumerate(daysinmonth(local!month, local!year)) + 1 ), local!selectedDate: {}, local!holidays: { if( a!isNullOrEmpty(local!holidayslist), {}, text(local!holidayslist, "DD") ) }, local!currentMonth: { a!forEach( items: local!selectedDate, expression: if( tointeger(text(fv!item, "MM")) = local!month, t