Discussion Categories

I have an interface with a grid, in which first columns is an ID, and you can click on one of the ids to go to another interface with specific details for that ID. Right now that link works with a process, but I need to change it so it does not trigger any process, I want it to open the interface with the details for the selected ID without going through a PM.How can I do that? Thanks you!

Hi, I am trying to implement a Box integration using JWT Authentication. I have set up the entire integration however while trying to generate the access token it is giving an error. Can anyone help how to fix the issue? Thanks in advance!

HI I am fetching data from appian report. I have applied filter also so it won't fetch all the data everytime. but for the very first time it has to fetch everything  from the reocrd and then store in database. Now just to be on safer side I want to fetch the data in batches and then want to consume it.I am doing it with the following way a!localVariables( local!latestDate: cast( typeof(now()), index( rule!MO_GetLatestAuditDetails().data , "endTime" , now()-60) ), local!processModelUuids: rule!MO_GetAllProcessModels().processModelUuid, local!totalCount: index( rule!NEW_MO_ExtractProcessMetricsFromPortalReport( batchSize: 1, startIndex: 1, date: local!latestDate, processModelUuids: local!processModelUuids ), "totalCount", 0 ), local!numberOfIterations: = fn!ceiling(local!totalCount / ri!batchSize), local!listOfIntegers: = enumerate(local!numberOfIterations), a!forEach( items: local!listOfIntegers, expression: rule!NEW_MO_ExtractProcessMetricsFromPortal

HII would like to understand if there is any way to export data to excel in appian if we have more than 50 columns? Any suggestions appreciated.  Thanks in Advance.

My local variable is showing 1 item, but it should show 6 items. That is referring to only one value from the referenced table.The dropdown using this local variable shows only 1 item in it. I need to make it show 6 items. I have used the referenced table({}) this function also.

Can we have a Audit History of Groups, just to check who added the user and when? and which user have been removed and also for the date of removal.

Hi All, I am using template to word doc smart service to create ms word doc from the input template. We have to replace few fields from the template. Now the problem I am facing is if the value is there then it's getting populated properly with underline(as there is a underline in the input template) but if there is no value it's getting replaced by blank and because of that there is no underlines available for those fields. So i want to know is there a way to replace the items only based upon some condition ? like if the value is null just do not touch that ? something like that can be configured ?

I  was working with the editable grid . i want the all the updated values from the editable grid from the cdt ?

Hi, Question for the community. I have a process id and which is the efficient way to find the process status. I don't need any other info from the status only whether it is completed or now.

Right-click on the video component or document component placed in the interface to display the context menu.Please let me know if there is a way to restrict the display of this context menu.

Hi, I am trying to trigger a process Model when we have received an email to a particular email. Is it required to include Process Model UUID in both subject and body of the email.

Hi Champs, I have a use case where I need to execute an action/process Model to update a column in a database table on user entry to a record view. It should be automatic. There is no user interaction required for this. Is it feasible? The functional use case is ,I am showing the alerts to the user in summary page if there is any message in history log table. Once User click the History log tab, I have to make all the unseen messages to seen automatically. To Better explain, I have two views in my record which is Summary View where I will show the alerts to the user if there are any new messages and the other is History/log message View. Regards, Ghanashyam

getting below error  2023-08-01 15:46:38,708 [main] ERROR com.appiancorp.ps.automatedtest.exception.ExceptionBuilder - Loginorg.jruby.exceptions.ArgumentError: (ArgumentError) expected #<Java::OrgOpenqaSelenium::By::ByXPath:0x35216a2e>:Java::OrgOpenqaSelenium::By::ByXPath to respond to #shift at RUBY.extract_args(C:/jruby-9.4.3.0/lib/ruby/gems/shared/gems/selenium-webdriver-4.10.0/lib/selenium/webdriver/common/search_context.rb:91) ~[?:?] at RUBY.findElement(C:/jruby-9.4.3.0/lib/ruby/gems/shared/gems/selenium-webdriver-4.10.0/lib/selenium/webdriver/common/search_context.rb:58) ~[?:?] at RUBY.login_with_role(C:/workFolder/RemoteTest/selenium_tests/ruby_methods/tempo_fixture.rb:510) ~[?:?] at RUBY.create_pr_with_role(C:/workFolder/RemoteTest/selenium_tests/ruby_methods/easi/pr_creation.rb:3) ~[?:?] at RUBY.<main>(C:/workFolder/RemoteTest/selenium_tests/features/step_definitions/easi/pr_creation_steps.rb:24) ~[?:?] at org.jruby.RubyBasicObject.instance_exec(org/jruby/Rub

Hi everyone, Quick reminder that our first Appian Community Quick Build to create a reusable calendar component is in progress and submissions are due by midnight ET on Friday, August 4! By just submitting a component, you'll be entered into a raffle to win 1 of 5 certification exam vouchers or three days of advanced training! Finalists will be featured during our Friday, August 11th livestream, where 1st and 2nd place will be decided to win $250 and $100 gift cards, respectively.

This part of the course wants you to create a new record type and from the database table select "AS_Vehicle" however, when I get to the "Configure Date Source" menu the only options that show up are "PF_ACCOUNT, PF_ACCOUNT_TYPE, PF_GOAL, PF_TRANSACTION".  Does anyone happen to know what is going wrong here? Or how I can access the "AS_Vehicle" database table? 

I have a dropdown in an interface where the selected label disappears once it is selected.  However, the value is stored. I have a Reference table, User Role with 4 fields. Role ID Role IsValid Sort I have a data table, User with several fields, but it has a field Role ID that is related to the Role ID in the reference table.  I have relationships built both ways between the User data table and the User Role reference table. I have an expression rule that produces a sorted lists all the Active Reference; QR_getActiveUserRoles.  This tests good. In the interface I have a local variable Roles which calls the Expression Rule QR_getActiveUserRoles. "local!Roles: rule!QR_getActiveUserRoles()". In the interface I have a dropdownField picker a!dropdownField( label: "User Role", labelPosition: "ABOVE", placeholder: "--- Select a User Role ---", choiceLabels: local!Roles['recordType![REF Role.fields.RoleName'], choiceValues: local!Rol

Dear Community, We encountered an issue recently regarding disk space, where it reached its full capacity two days ago. Upon further investigation, we identified a timer that was causing file duplication, leading to the storage becoming full with over 1.6 million files. To address the situation efficiently, we attempted to remove the entire folder (Knowledge Center > Artifacts > folder xyz) instead of deleting individual files. However, we are now facing a challenge as the "artifacts" folder is displaying 40GB of consumed memory, while there are only five files totaling 200KB in size. Despite our efforts, we have been unable to locate any hidden files or identify the reason for the excessive storage consumption. We are seeking guidance on how to identify the root cause behind this issue and optimize the storage usage effectively. Thank you for your support in resolving this matter promptly

Hello, I have recently created a grid with data pulling from a CDT. I created a separate account filters interface for multiple dropdowns to be used to filter the data within the grid. Below I will share code snippets of the multiple dropdown filters interface, the query expression rule, the save rule, and the grid/filter put together in that order. FILTER INTERFACE:a!localVariables( local!aggregateCptyAccounts: rule!TS_QE_aggregateCptyAccountCodes(), local!aggregateCptyAccountNames: rule!TS_QE_aggregateCptyAccountNames(), local!aggregateCptyAccountTypes: rule!TS_QE_aggregateCptyAccountTypes(), a!cardLayout( contents: { a!sectionLayout( label: "Account Filters", contents: { { a!multipleDropdownField( label: "Cpty Account Codes", labelPosition: "ABOVE", placeholder: "account codes", choiceLabels: {local!aggregateCptyAccounts}, choiceValues: {local!aggregateCptyAccounts}, value: ri!cptyAccountCode, saveInto: {ri!cptyAccou

Hi Champs, I am getting a strange behavior when calling a record view from a site, it's not showing the breadcrumb as highlighted below when called from in site. Instead it is showing like this without the breadcrumb. Am I missing something while configuring in site.

Hi All, We are facing an issue with execute store procedure.  The stored procedure involves an OPENQUERY statement that connects to another server's database table and inserts data into it. Previously, we were using the deprecated Execute Stored Procedure method without any issues. As part of our version upgrade, we have updated with Execute Stored Procedure (Native) method, which is not functioning as expected. Please find the sample query in the stored procedure - INSERT OPENQUERY (<linkedServerName>, 'Select <columns from linked server DB Table>') SELECT <columns from current DB Table>; Error Message:  The operation could not be performed due to the OLE DB provider "MSOLEDBSQL" for linked server "dxbkdb01_edms" being unable to begin a distributed transaction. Thanks for your guidance in advance!!

Hii All, My requirement is like we have one interface in that we are having two link e.g XYZ,ABC and after clicking on both the link we are opening one interface bt we are using same interface for both the links  we have different data for different link  so in same interface how can we show different data like if im ,clicking on XYZ it should show XYZ data and on clicking on ABC it should show ABC data..

Hi Experts, I have a requirement to show alerts with some numbers so that users will be notified with a count of new messages when they will login to their site.  For example, we are putting some message logs in a custom database table and that table can be populated from external itself. So, to see those logs users need to navigate to log message tab and can see those data; but Users need to check that all time to check if a new message came or not. Instead of that if we can have some alerts in that tab so that user will be notified of that and check that. One the best example is like showing alerts in our Appian community when there is a new message came or someone reply to our thread. Regards, Ghanashyam

how to get the different values form the array ?  eg. local!a:{"a,"b") local!b:{"a","b","c") i want the output as c how can i get that ? 

a!localVariables( local!pressedButton: "cancel", local!getdata: rule!test_getRequestByID(ri!id), { a!columnsLayout( columns: a!columnLayout( contents: a!sectionLayout( contents: { a!richTextDisplayField( value: a!richTextItem( text: if( a!isNullOrEmpty(local!getdata.lastUpdatedBy), "Already a user is working on this request", rule!GBL_displayUserFirstLast(loggedInUser()) & " is working on this request" ), color: "SECONDARY", size: "LARGE", style: "STRONG" ), showWhen: not(ri!editable) ) } ) ) ), a!sectionLayout( contents: { a!boxLayout( label: "Audit Approval Form", labelSize: "MEDIUM_PLUS", contents: { a!columnsLayout( columns: {

Hi Appian Community members Any one have the idea why the below error is occuring and solution to that error. ERROR com.appiancorp.common.config.RegisterConfigurationFiles - Error Invoking importExternalConfigs for service extended-channels-servicecom.appian.komodo.api.exceptions.TimeoutException: Could not route request to channels at com.appian.komodo.client.Dispatcher$DispatchRunnable.run(Dispatcher.java:246) at io.netty.util.concurrent.PromiseTask.runTask(PromiseTask.java:98) at io.netty.util.concurrent.ScheduledFutureTask.run(ScheduledFutureTask.java:153) at io.netty.util.concurrent.AbstractEventExecutor.runTask(AbstractEventExecutor.java:174) at io.netty.channel.DefaultEventLoop.run(DefaultEventLoop.java:54) at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997) at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) at java.lang.Thread.run(Thread.java:750) Thank you in advance.