Discussion Categories

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.

I have a Process Model in which last node is as same as start node's interface , this last node is just showing some grid on the same interface after getting few details, But the problem is this , the last node is working if I monitor it but it won't show it's result on site instead it refreshes the page and start a new form to get submit.

I am testing the new version of appian and the AI ​​elements, specifically when I create an extraction model for an invoice, the document appears like this and I cannot map the data correctly. Does anyone know why?

Hi All, Below is my Array. { { Id:"A", Value: 123 }, { Id:"B", Value: 345 }, { Id:"C", Value: 678 } } 1.I want to check if list contains items with Id apart from "A" and "B". 2.Also I want to filter the items whose Id is not equal to "A" and "B".

Hello, When I import either a csv or excel file. the records do not appear on the data store.  I do not have access to view the database but the files make it to the target folder. Thank you for the help

Hi All, for document download with using a!documentdownloadlink function is there any restriction for any user like only member who is in administrator group can download that document ?

I have read the documentation and I think I have followed what is suggested but I still cannot start the process- from the interface. this is the section of the interface where I am calling the process model: a!sideBySideItem( item: a!imageField( images: a!userImage( user: local!currentuser, link: a!dynamicLink( value: local!imageuser, saveInto: a!startProcess( processModel: cons!GLP_UPDATEPROFILEPICTURE, processParameters: { userToUpdate: local!currentuser }, onSuccess: a!save( target: local!imageuser, value: fv!processInfo ) ) ) ), isThumbnail: true(), style: "AVATAR" ), width: "MINIMIZE" ),

We have recently upgraded Appian to 22.4. I have noticed since the upgrade, when importing packages with nested CDTs that it takes quite some time (anywhere from 10 min - 2 hours) to import the data types. If there are other data types in the package, it will import all of those and get hung up on the nested data type. Then, if there are other packages to import to the application, they get held up because the first package has not completed. Has anyone else had these issues or know of a way to fix this? The nested CDTs are just to store information from API calls, and not used to write to a database. Example of an import with two data types in it, took 21 min to import:

When I deleted the Record .It gives error Error:-- After deleting the rows , row has deleted correctly  but this message come again and again.. not able to redirect summary page from where I am deleting the records

Hello All, Is there a way to know which IDP version installed on my environment? I can see that the application was imported on the  7/8/2020. But other than that, I don't have anything else. Thanks for all the help! Akshar

I want to pass a record type local variable to a process model, I get an error on either ways I'm trying, I just want to make sure I'm on the right track, which of this two was is the correct one, if any? local!myVariable or local!myVariable[recordtype!myRecord] thank you

I have created a process model that produces an Excel file and places it in a knowledge center. Is there a way to automatically download the excel file from the process model without using a user form with a download link? It seems like such a basic functionality that I am a bit confused as to why it is so complicated.

Hi!I'm trying to filter out record where field 'value' is null, but it only gives the record of the first item, here's the code local!validValues:ri!properties[where(a!isNotNullOrEmpty(ri!properties['recordType!{5ebb976a-556f-4033-b1d7-9e5976ab963d}MM Property.fields.{041a7f43-dfd1-4b07-aaed-48e305712f4e}value']))], Any inputs? Thank you

I am new to Appian and I need to write a rule that takes an array of CDT objects; updates all of their "id" and "loanId" values to null; and returns them. I have been trying to use a foreach loop as follows but the data won't change. what am I doing wrong? a!localVariables( local!assestsLiabilitiesDetails: ri!assestsLiabilitiesDetails, expression: a!forEach( items: local!assestsLiabilitiesDetails, expression: { fv!item: a!update(fv!item, "id", null('type!{http://www.appian.com/ae/types/2009}Integer')), fv!item: a!update(fv!item, "loanId", null('type!{http://www.appian.com/ae/types/2009}Integer')), } ), a!save(target: ri!assestsLiabilitiesDetails, local!assestsLiabilitiesDetails) ) Thank you in advance for the help!

Hello team, in my application for reporting i use a!exportDataStoreEntityToExcel smart service to download Excel report based on the filters selected. This part is working great. As a new requirement i need to limit the access, the users will be able to download report only for contracts which they created / they approved from sender side / they approved from receiver side. The way i tried to achieve this is to create an expression rule to query the entity, make queries with 3 different filters (when user is created, approver on sender side, approver on receiver side), save the results into 3 separate local variables, combine them into the final local variable which will be then used as the entity parameter in the excel smart service. But i am not able to cast it to proper format, all the time i receive an error message: Could not cast from ICH_V_ContractLineItemsReportCSV to Data Store Entity. Details: CastInvalid. Example: local!variable1: cast( 'type!{urn:com:appian:typ

Im trying to move a row of data through the table, I got the down movement right but the up movement doesn't seem to work, it moves two row up instead of just one and doesn't update the previous position value to the new one, here's the code (relevant from line 39 downwards):a!localVariables( local!properties:rule!MM_getPropertiesByType(type: ri!propertyType), { a!gridLayout( label: ri!propertiesLiteral, labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: ""), a!gridLayoutHeaderCell(label: "Value"), a!gridLayoutHeaderCell(label: ""), a!gridLayoutHeaderCell(label: "") }, columnConfigs: { a!gridLayoutColumnConfig( width: "ICON" ), a!gridLayoutColumnConfig( weight: 10 ), a!gridLayoutColumnConfig( width: "ICON" ), a!gridLayoutColumnConfig( width: "ICON" ) }, rows: { a!forEach( items: local!properties, ex

Hi Team, I have an interface which contains the below code: a!localVariables(  local!category: rule!AA_QR_REF_getVehicleCategory,  local!condition: rule!AA_QR_REF_getVehicleCategory,  a!formLayout(    label: "Add Vehicle",    contents: {      a!columnsLayout(        columns: {          a!columnLayout(            contents: {              a!sideBySideLayout(                items: {                  a!sideBySideItem(                    item: a!integerField(&nbsp

Hi! I'm new to Appian records, been working with a really outdated version until now. I'm trying to do a sort of properties interface where a user can add new values into properties but I can't seem to make a new row of records, here's the code a!localVariables( local!properties:rule!MM_getPropertiesByType(type: ri!propertyType), local!addAux, { a!gridLayout( label: ri!propertiesLiteral, labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: ""), a!gridLayoutHeaderCell(label: "Value"), a!gridLayoutHeaderCell(label: "") }, columnConfigs: { a!gridLayoutColumnConfig( width: "ICON" ), a!gridLayoutColumnConfig( weight: 10 ), a!gridLayoutColumnConfig( width: "ICON" ) }, rows: { a!gridRowLayout( contents: { a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!richTextIcon(