Discussion Categories

Hi all, I have to deal with metadata on my processes. Most of them upper 20 parameters. My engine rule Will need to Fetch the specific parameter and its value coming from interfaces, data bases or integrations. So I wonder what It is best way to deal with them for performance: 1) create a CDT with upper 20 fields (and It could be defined more than 50 fields) 2) create a CDT with 2 fields: key and value and work as a list. 3) Define a Map as any type objects. Thank you.

Which operations are not supported on the CDT editor interface? (select multiple from bellow options) a. Add a field  b. delete a field from cdt. c. change field of cdt d. define a field as the primary key of cdt.

Hi, everyone. I'm learning from "Online Course - Advanced Expressions: Part 2".I have a question about "Exercise: Looping Functions (Online Course | Learning at Appian)". Exercise: Looping Functions(Online Course | Learning at Appian) The answer of "Scenario 4" is 1333 (1332 + initial value 1), but adding all the values of "local!sensor" gives 1361.The last value of 29 in the third map seems to be ignored. 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, 1, local!sensor.data) ) Is the answer 1333 correct?Is this behavior by design? Regards!

Hi Folks, Is there a way to show the value in a dropdown in italics? Regards, Ghanashyam

How to get the Rule Id of the Expression I want to update, since I want this dynamically based on the rule name I am extracting elsewhere and passing as a process parameter? Here when I select the rule by typing and prompt, and save it into a pv created using (+), it is showing the value for that particular rule, I but I want it to be dynamically populated.

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

HelloI have a section that is collapsible but the label has to change based on the state of the section - any suggestions on how I can implement it using Appian's built-in features. I can do it using richTextField but then I can't seem to emulate the slow animation that Appian's default code does. So, two questions: Is there a way to change labels based on the state or Is there a way to emulate the slow animation of the arrow if I create the section label using richTextField.a!sectionLayout( if (sectionIsCollapsed, label:"Show Details", label: "Hide Details") is it possible to code the slow animation of the arrow as Appian does here?label:"Show Details", logic to change text to display based on the state of the section  Thank you for your assistance M a!localVariables( local!isExpanded: false(), a!sectionLayout( label: "Outer Section", isCollapsible: true, contents: { a!richTextDisplayField( value: {

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!!

Hi All,Can we check and enable/disable track changes to word documents using Appian. Thanks in advance,Surya 

Hi Appian Community, I want to implement a simple Try... Catch within my Web API sail expression to test the request body being a valid JSON message. I still notice that the Try() function is not publicized in the documentation but it has been an easier implementation. And in posts that mention Try() function it heavily cautions that it is not recommended and could become unavailable. I looked into using some regular expressions off Google that match for JSON as an alternative but found they aren't compliant with the regex plugin. Example Regex /(?{((?\"([^\0-\x1F\"\\]|\\[\"\\\/bfnrt]|\\u[0-9a-fA-F]{4})*\"):(?\g|(?-?(0|[1-9]\d*)(.\d+)?([eE][+-]?\d+)?)|\g|\g|true|false|null))?\s*((?,\s*)\g(?:\s*)\g)*})|(?\[\g?(\g\g)*\])/ What are some recommended HTTP Request Body validation expressions that can validate whether the message is JSON or XML? It would be great if WebAPI object can handle the content-type validation automatically for us. Below code is using try() function to test f

Hi, I have a very basic process model where I'm setting a new value for a users first name and last name, then setting a new value for the username and finally deactivating the user. The process has been working as expected for approx. 1 month but is now showing this error on the Rename Users Smart Service: The amount of time allocated for the completion of an unattended activity was insufficient to allow the activity to complete. It also sporadically shows the following error, again on the same Rename Users Smart Service node: An error occurred in executing an Activity Class. Error in the tomcat.stdOut log: 2022-03-23 09:46:44,983 [ajp-nio-0.0.0.0-8009-exec-836] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=536877698, classname=com.appiancorp.process.runtime.activities.StartProcessSmartService2 com.appiancorp.suiteapi.process.exceptions.SmartServiceException: userMsg[error.initiateProcess.userMsg=Failed to st

For the word "technology", Eg t-1 e-1 c-1 I need character count of unique elements of this string

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

I am trying to create an excel sheet with the data present in my PV variable, this data is not directly from the SQL database as i have to modify it before writing it to the excel. Can you please tell me which smart service i can use. Export Data Store Entity to Excel/CSV isn't giving me the desired result as the requirement is to use the data in PV variable not from the DB. Please help me here. Thanks, Preji

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

I have three CDTs that contain some fields with the same value. I want to create an expression rule that matches them and extracts only the fields that don't overlap. What function can I use to make it?

how to import old data for task report? We are migrating old data to db and  we have some process/task report which is not updating tha db data to UI grids.

How to ensure a process have a well-defined life cycle? (select multiple from bellow options) a. configure process data management settings b. use a terminate end node to complete workflow c. configure all processes as sub-process that are quick task d. configure exceptions on every node in process. 

how can we import the process instance from one env to another??

I have a date field that autopopulates a read-only field and also saves to the data. Right now in the read-only field the dates are displayed as 2/28/2023 and I would like to have it displayed as February 27 2023. any suggestions for the code? this is what I have atm text(local!birthDate, "mmmm") & " " & text(local!birthDate, "dd") & ", " & text(local!birthDate, "yyyy")

Hi Guys, Just wanted to know since a lot of work is done in expression mode which is in light theme so is there any way we can switch to dark theme as most of the editor of other languages have dark theme. And it's sometimes difficult to look in light theme for a long time. Thanks in advance