Discussion Categories

Hi Guys, I am facing dead lock issue while executing Stored procedure Parallelly through Multiple Instances. Error Message : Transaction(Process Id : 1234) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the Transaction. Please post if you have anything related to this issue.

Hi, Can You please suggest, How to install appian common object application for appian cloud users. 

In related action , after submitting a form ,the form must gets closed and it must enter details in db  but after submitting the form it is not updating the details in db and the form is not getting closed can someone please with this

I want to access sql result data in Custom Output of Query Database Smart Service, but I get an error. I would like to access the ResultSets, like in the Execute Stored Procedure Smart Service if possible, can I achieve the same operation in the Query Database?

Hi actually there is a process in our project in which one process completes in the SQL server after that the status code changes and then the Appian process model starts at the click of a button once the status is changed. So is there a way to trigger that process model without clicking on that button on the change of the status? We tried triggering the process model through webApi from SQL server but failed. Is there any other way out?

I have a string something like "***-***" I just want to check if the string contains "-"?What is the best way to achieve that?

Hi Team, Can we provide an export option for the read-only grid that we have generated using a rule? If not, what would be the workaround for this?

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