General

Dear All, I have created a stored proc which is returning an output parameter 'caseid' and I would like to access the case id in stored proc smart service. But I am getting error incorrect number of argument passed. Please correct me if I am doing something wrong. I have attached the screenshots below:

Is there an option / way to modify the a!documentBrowserFieldColumns to display the list of documents by "Last Modified Date" instead of Alphabetically?

If a Smart Service has a onError argument, can I capture the error message of what went wrong?  For example, the createUser SmartService has an onSuccess and onError arguments.  In the onSuccess, I can capture the created user with fv!user.  Which is great.  But in the onError, I don't see anything that will tell me what went wrong. I know the system knows what went wrong because if I happen to wrap the call to the createUser call in a WebAPI, I can see in the "Details" section of the "Smart Service Executed" response it says, "The username requested is not available".  But I want to capture that text so that I can log/report it and I don't see a way to do that.  I want to know more than "It failed".  I want to be able to report what actually went wrong. Thanks in advance,Steve

Here I set a timer for a re escalation  if the  user  is not active but it seems like it is not working. This  is the group that i'm   scalating this task to

I created this update records-related action from the "Generate a Record Action" button. following is the auto-generated process model. Its having following wrror  And following is an error on site : An error occurred while retrieving the data for "DDE Invoice Data". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator.

Context: To customise an appian-plugin, I use Java as the primary language. I have added codes into a class that belongs to the plugin working space, and anytime I run maven clean install, my codes will be removed throughout the clean process. According to my colleagues, it might be due to a.wsdl file that produces files automatically when it is redeployed. Please advise. Thank you very much. This is the code fragment I'm attempting to put. public static Comparator sortWageIncrementFinancialYr = new Comparator () { public int compare(DummyFormData u1, DummyFormData u2) { int compare1 = u1.financialYr.get(0); int compare2 = u2.financialYr.get(0); Boolean result = compare1 > compare2; return result ? 1 : -1; } }; .wsdl codes associated with this

I'm creating an Appian web API to retrieve documents from our Appian system and link them with our other systems. To that end, I'm utilising Appian's folder() function to gather information about the contents of a folder. folder( theCaseFolder, "documentChildren" ) The issue I'm facing is that, while this code works most of the time, we have some instances with over 1000 documents recorded against the case. I notice in the Appian documentation that: The documentChildren and folderChildren properties provide the top 1000 documents or folders that are direct offspring of the specified folder, accordingly. My issue is that we have a few cases where there are over 3000 papers attached. Is it possible to obtain a list of those kid documents, or am I completely out of luck?

Hi: I was trying to learn about web-integration using the credit card integration example (https://docs.appian.com/suite/help/23.1/Integration_Tutorial.html) and the currency function in the interface doesn't seem to be working - Error:Expression evaluation error at function a!currency: The function a!currency is unavailable. I tried the basic example from the a!currency documentation page (https://docs.appian.com/suite/help/23.1/fnc_text_currency.html) and it gives the same error.  a!currency( isoCode: "USD", value: 1234.56) Looked to determine if this function is old - but it seems to be part of 23.1 release.  Any ideas of what is going on?  When it might be available?  Or is this not available in the community edition? Thank you! Ma

Good Day Experts, Can anyone please help me how to configure/use the password encryption for Fitnesse for Appian ? We can configure the user name and password in the user.property file and we can use as a RULE in fitnesse script but I'm not looking for that. We wanted to use the encrypted username and password (at least password ). I've gone through below documentation but still I'm not  able to figure out. http://fitnesse.org/FitNesse.UserGuide.AdministeringFitNesse.PasswordCipher Please let me know if you need more details. Thanks in advance. Cheers, Kalai.

Hi Team, Getting below error while trying to open downloaded document from Appian after merging with smart service DOCX Merge: Error: Word found unreadable content in "test 1.docx". Do you want to recover the contents of this document? If you trust the source of this document, click Yes. Regards,Sandeep

I want to run a Dynamic "Select" Statement in Oracle DB.  So used a SYS_REFCURSOR output variable and used "OPEN FOR" Statement to execute it. While executing this stored procedure I got this following error  Any suggestions or ideas would be greatly appreciated.Thank you ahead of time.

Hello, everyone. First of all: I'm new to Appian. I have several very complex views in a PostgreSQL database that I want to replace in some way with intermediary appian objects that allow me to build the views logic step by step. Is there a way to build some kind of record type that has in-built logic from other record types or data store entities? Is there a way to call the result of some query from within another query and to call any of those from an interface?

Is there any fast way to check if i have any of this functions in my app? Currency functions The following functions related to currency localization are deprecated and will be removed in a future release: dollar() euro() pound() yen() Calendar add functions The following functions related to date and time addition are deprecated and will be removed in a future release: caladddays() caladdhours() And also how can I check if this affects me? thank you!

Trying to create a group using smart service through a process model. However the group is getting created but the following groups are not showing not in the application. Also inherited to the administrator access parent process, security is correctly mapped as expected. If anyone through some light.

Hi everyone, I'm having this issue where I'm trying to index a date and time array using the index of caseID from another array with same order. Below are the process variables and the code that I wrote: allCases Number (Integer) 3,061,158; 3,061,157; 3,061,156; 3,061,155; 30,611,111; 306,115,555 updatedDateTime Date and Time 20 May 2023 12:00; 21 May 2023 12:00; 20 Jun 2023 12:00; 6 Dec 2023 12:00; 20 May 2023 12:00; 20 May 2023 12:00 However there was no updatedDateTime value passed into my sub-process, so I'm wondering what did I do wrong with the indexing. Any idea? Thanks a lot in advance :)

In Appian RPA , there it is not showing Resource Tab. How to locate it ?

I am trying to save data using Rich Text Editor having longtext Data Type. But when I check the record type for the saved data, the full data is not showing up, only 40% data is showing up in record. What can be the possible reasons for it?

in the expression the time value shows in EDT, but the zone display as GMT+00:00. how can I change this ?

as i have written the following code .. but how to increase the index.. iif user clicks on add new .. new field of mobile number should get added..a!localVariables( local!add , local!npi, a!sideBySideLayout( items: { a!forEach(items: local!npi,expression: a!sideBySideItem( item: a!textField( label: "Mobile Number", labelPosition: "ABOVE", value: fv!item, saveInto: fv!item, validations: if( a!isNullOrEmpty(fv!item), {}, if( not( regexmatch("^([0-9]{" & 10 & "})$", fv!item) ), "Maximum " & 10 & " digits are allowed", "" ) ) )) ), a!sideBySideItem( item: a!linkField( label: "", links: { a!dynamicLink( label: "Add New", value: { local!npi + 1

Need to add multiple phone numbers.. on screen  and want to store in DB .. what could be the best approach

how should i approach from appian side ... to add mobile number dynamically .. For now i am having  blank text field where user can enter mobile number.. next to it i want to provide add button .. so whenever it gets clicked a new text field should appear to add new mobile number with validation ... a!localVariables( local!add , local!npi, a!sideBySideLayout( items: { a!sideBySideItem( item: a!textField( label: "Mobile Number", labelPosition: "ABOVE", value: local!npi, saveInto: local!npi, validations: if( a!isNullOrEmpty(local!npi), {}, if( not( regexmatch("^([0-9]{" & 10 & "})$", local!npi) ), "Maximum " & 10 & " digits are allowed", "" ) ) ) ), a!sideBySideItem( item: a!linkField( label: "", links: { a!dyna

Hello Community, U want to use a array of CDT's as input to the text from template smartservice. It works fine for 1 Line. How to configure the next CDT's Will append to the document on the next Line? Tried joinarray char 13 and char 10, this only works for one mergefield. Kind regards, Erik

I have a dropdown component and I want certain values to be available for choice based on the security groups of the user. For example someone who is only in group A might be able to choose 1, 2 or 3 from a dropdown, someone in group B might be able to choose 4, 5 and 6 from the dropdown and someone who is in both groups would be able to choose all 6 options. Changing the dropdown labels/values based on group is not a big deal to do, however, since the dropdown only allows values to exist that are within the currently available list of labels/values, if group A chooses 1 and someone in group B looks at the form, the 1 will be invalid and break the interface. What would be a good way to get around this issue? 

Hello everybody, I am a bartender and YES I am changing careers. Currently I'm taking college classes in development to catch up on tech and I will be attending APPIAN WORLD 2023 in San Diego on may 1st. My concentration is development to start applying jobs in about 6 months. I wanted to go ahead and connect with people who recently did a career change, OR already done it (NICE WORK BTW) - and potentially become Appian buddies and learn from each other OR learn from YOU! If you are going to attend Appian world, we seriously should connect. I am looking to build Appian relationships, share and consume projects in the community too. Hit me up on LinkedIn, its sorta lonely over there but don't we gotta start somewhere? Thanks for this community and take care colleagues! LinkedIN

Ok so, inside a forEach statement I define a local variable like so: a!localVariables( local!routingChoices: a!refreshVariable( value: if( a!isNotNullOrEmpty(ri!inputData[local!currentIndex].routingAction[fv!index]), a!match( value: ri!inputData[local!currentIndex].routingAction[fv!index], equals: 6, then: {1,2}, equals: 7, then: {1,3}, equals: 8, then: {2,4}, equals: 9, then: {2,3}, equals: 10, then: {3,4}, equals: 11, then: {1,2,3}, equals: 12, then: {2,3,4}, default: fv!value ), null() ), refreshOnReferencedVarChange: false(), refreshOnVarChange: local!sealCount ), local!sealCount stores an integer and the forEach is set up to run "enumerate(local!sealCount)" times (so if local!sealCount = 2 the forEach runs twice). Then, farther down in the interface, I have a dynamic link that acts as a "delete&q