General

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

Hello everybody we have got this message in tomcat logs: "A high-memory expression evaluation was logged, but the evaluation was not identified. The expressions aborted log will not contain all evaluation info" and this message is repeated several times and between every occurrence there are the lines that I have put in the log in attachment. I would ask if someone has ever met this error, or in alternative if you can give to me some hints,  after the reading of the log, that in my opinion in quite hard to understand. Thank you in advance for any help or suggestion, best regards Paolo [View:/cfs-file/__key/communityserver-discussions-components-files/11/log.txt:87:58]

Hi All I am working on version 22.3. My requirement is to get data from DB and provide it to user in excel format. This I have achieved using OOTB node "Export Data Store Entity to Excel". The excel sheet obtained looks something like below: However, I want to transpose the excel data as below: Can anyone please suggest how is the above achievable. Thanks in advance!!

Can anyone provide me road-map to study for L2 Certification?

Do Appian has provided a course for Appian L2 Certification? I am unable to find it.

Hi, There is a CDT which is calling a Sequence in Oracle as a primary key. Below is the extract from CDT. <xsd:element name="recordId" nillable="true" type="xsd:int"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(name="RECORD_ID") @Id @GeneratedValue @SequenceGenerator(name="sequence", sequenceName="A_RECORD_ID", allocationSize=1)</xsd:appinfo> </xsd:annotation> </xsd:element> For some reason, when we are trying to insert data in the table some other sequence is being called and we are getting "Unique key Violation". We are able to identify that sequence but not able to figure how this is happening. We could not find any trigger in the table. Any pointers would be highly appreciated.

Hello world, I am currently representing Infosistema, a portuguese IT company and we are on a hunt for Appian Developers! We need someone with :  1 + years of experience in Appian Spanish/Portuguese and English language skills We offer both remote or relocation options. If you are interested or know anyone who might be, please contact me either through here or through my linkedin. Thank you very much.