Discussion Categories

I want batching for looping process suppose i have 1000 id's and i want to execute loop with 200 batchsize. a!forEach( items: local!id, expression:fvi!item )

Hi Members,I am trying to calculate the working hours between two different time using calworkhours function.It is giving perfect result for all the days except on Fridays. I have check my calendar setting as well . Friday's setting is same as other working days.I have pasted the Screenshot of Calendar and Expression along with it's result. EscalationCalendar Image :  I am expecting 6 hours but it's giving 2 hours and it is same for every Friday.Please help on this ASAP.

Hi. How to create different pipelines using appian and provide constraints and conditions on the same?

Hi everyone  i have an error that i dont understand , why it is throwing this error when i am debbuging the process ?  it s even not showing errors in the console . so how can i know what is the reason of this  problem ?  everything worked before , i dont know what happen ? anyone know what i need to do ?? 

Hi Team, I am in the learning phase of Appian RPS, I wanted to know how we revert the changes done to my Robotic tasks, Can we revert RPA robotic tasks to the previous version or date if so then how? Many thanks, Mohammed Khaiserulla

Hello All, I need your guidance and assistance regarding the creation of a cascading dropdown interface that supports an unlimited or variable number of levels. The purpose of the interface is to display data retrieved from a reference database table, where the values of the child level dropdowns are determined by the parentId field in the table. The cascading dropdown interface will be used to present hierarchical data from the reference database table. Each dropdown level represents a different level in the hierarchy, with the child level options being dynamically populated based on the selected value of the parent level. The goal is to enable users to navigate through the hierarchy seamlessly, regardless of the number of levels it comprises. The database table looks like this . ParentId is FK refer to Id field. Id, level parentId 1   l1v1      null 2   l1v2       null 3   l1v3       null 4

Hi Experts, I  want to insert Emojis and special characters  with text . Is there any  way to insert in Database? Thanks

When I write a code "month(fv!item.asDate) = local!month", why it's showing a result A null parameter has been passed. How to resolve that part? Also I put that part if( a!isnullOrEmpty(index(fv!item, "asDate", null)), false, contains( tointeger(local!month), month(index(fv!item, "asDate", null)) ) ), but same error as it is

I have a local variable which is receiving BacthPayloadInput Response from process model local!updatedPurchasers_at: index( ri!EF_GeneralUpdatePayload_cdt.RequestJson, wherecontains( tostring("PowerPurchasers"), cast(103, index(ri!EF_GeneralUpdatePayload_cdt,"RequestEndpoint",{})) ), null ), when i output the values it contains in expression rule it gives me output like this: I want to extract the only "KeyPowerPurchasers" out of it which i am not able to do so. I have been trying to get it in following these two methods but both are having problem: first one: local!purchaserKeys_int:reject( fn!isnull, { if( a!isNullOrEmpty(local!updatedPurchasers_at), null, cast(101, index(local!updatedPurchasers_at, "KeyPowerPurchasers", {})) ) } ), it gives empty array {} 2nd one:   local!purchaserKeys_int:reject( fn!isnull, { if( a!isNullOrEmpty(local!updatedPurchasers_at), null, cast(101,a!fromJson(local!updatedPurchasers_at).KeyPowerPurchasers) ) } ),

i,I have a grid inside a form with "Submit" and "Cancel" button, where I am loading one row with required entry fields.Also there is an delete icon basides to that row to delete. Now, when I try to submit the form in the browser url by clicking "Submit" button, system is not locaing validation message which is there at grid/form level.Whereas validation message is firing during interface level testing. Any inputs on this please.TIA

Hi Team, We are developing a component plugin to which a json file to be passed from Appian SAIL Interface to Javascript in plugin. Is there any way to pass the document from Appian to JavaScript in the component plugin? when we try to pass the document from document url to component plugin it asks authentication.

Hi Guys, Can we use Kafka Tool Plug-in without installing Task Manager Application? Will it work without it or we should use it?

In the component configuration - if you add a text field, or record picker or whatever - under Label Position if you use Justified or Adjacent, the length for the label appears to be static I want to expand it out as I have a pile of fields that are like 2 letters too long and I really don't want it to word wrap How can I make it so that it either a) doesn't word wrap the label or b) allows me to select how much space I want for the label I don't see any options where I have control over this

They have name, email, phone, etc but it seems weird that URL isn't an option

Hello Everyone, I have a situation where I need to export data from an expression rule to excel. Previously I was using Export Data Store Entity to Excel smart service, but now as per the requirement I need to manipulate the data I get from database in an expression rule and then export it. Kindly let me know your comments. Thanks, Sai Kiran Pannala.

Hello Team, In our self-managed environments, we are not receiving Process error alerts. Do we need to enable/specify any properties at custom.properties at APPIAN_HOME/conf directory? if so please let us what are the specific properties need to configure? Thanks in advance.

I am using expression to configure a user filter for my record. The expected result for the choices is more than 5000 but the record batch size has a max limit of 5000.  Is there a workaround?

I have a DB table with Data. I have transpose the details in front end. Please help me how to do that. Below are the screens shots for reference. In Database table is like below Desired in Appian Interface

In our system, we need to use an MLOps tool for monitor and manage lifecycle of AI Appian's Smart Services.  Can Appian provide Legacy or Third-party MLOps Tool Integration?

I'd like to understand how to access by Appian. I need a POST request that just give me the correct result when my PC is connected in VPN, when I try using Postman It works. But when I try in Appian It does not work, like if Appian have not access to the VPN. I'd like to know who to fix.

Hi All, We are using a queryentity to retrieve the data from DB View. While retrieving the data we are seeing below intermittent issue. Our query rule is too long, I have attached that. Any suggestions to optimize this rule.   at function a!queryenti[View:/cfs-file/__key/communityserver-discussions-components-files/16/Query_5F00_Code.txt:320:240]ty an error occured while retreiving the data. Details: unexpected error executing query  Thanks

Good morning, I want to develop "Connected System Plug-ins" and "Component Plug-ins" but I only have access to the "community edition" of appian, is there a way to "Test" and "Deploy" the integrations that I develop? Short version, is it posible to make this posible without spending money on it?. Thank you.

Hi,  I have this process model in which there is a complex node. This node I have configured to execute all the outward flows only when it receives exactly 2 inputs ( because at no time will it receive more then 2 inputs ) But then the problem here is that complex gate never ends, its always in green .. and because of this the parent process model does not complete. Is there a way to rectify this ?  The configuration :      

Hey all. I have a validation in which the name of the uploaded attachment can't have more than 100 characters. I need that Appian automatically cut the name to maximum 100 characters. I was trying to make an expression rule; I made an index to find the character number 101, I wanted to insert a "," to split the text and then remove it... but I can't because the insert function doesn't accept text for the index parameter. Ideas? Example value: nombredocumentosnombredocumentosnombredocumentosnombredocumentosnombredocumentosnombredocumentosnombredocumentos  

Hi, i have the following code a!localVariables( local!sensor: { a!map(data: { 125, 92, 22, 63, 73, 28, 19 }), a!map(data: { 35, 65, 92, 22, 63, 73, 28 }), a!map(data: { 2, 35, 65, 22, 63, 73, 18, 29 }), a!map(data: { 9, 35, 65, 63, 35, 28, 19 }) }, reduce(fn!sum, 0, local!sensor.data)) Using excel the sum of all numbers is 1361. Using reduce() in Appian, the sum is 1332 that is 1361-29.The value 29 is the eighth element of the third map.Every map has 7 elements. Why the reduce() function exlude the element 29?