Discussion Categories

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

Hi Team I want to show case the percentage of data in the Y axis of the column chart field. Eg: If the X axis is have 4 values: A,B,C,D and Y axis is having values for each 1 for A, 2 for B, 3 for C, 4 for D. But other than showing these values is it also possible to showcase the percentage of these values as well? Thanks Harikrishnan

Hi all,As i have intalled RPA bot in my host machine.. I cant find the appain icon in my task barSo that my bot shows offline. I have tried executing the agent manually but it didn't workedPls suggest how to configure

I have installed RPA agent in my host machine. But I cant find icon in my taskbarI have tried to launch the agent manually but didn't worked

Can anyone help me to find default mariadb connection details in system logs?  I am not able to find in data server logs. Please let me know the exact path of that.

Our team is interested in developing applications using the appian platform and exploring options to publish them on the Appian App Market. Could anyone provide with more information on the partner plan available that align with our requirements? Specifically, we are looking for option that allows us to: 1) Build applications on the Appian platform using its low-code/no-code capabilities.2) To publish applications on the Appian App Market. Any information or guidance will be great help. Thank you in advance!

Hi All, Through Integration I am fetching the data from external system and storing it into my system. But it also stores duplicate records which already exists into my system. How should I prevent this, if I compare each row with existing data it would be time consuming. Please suggest.