Foundation

Hi, I have a table having 15 columns(Primary key constraint Id Auto increment) and my process is inserting 11701 rows, write to data store is taking 6 minutes to insert these rows. Is it fine or what i can do to fix it. pls find attached process node details.

hi Community! I would like to test my skills and do the AW2022 Live Build Challenge. Should I create tables within db that is behind My Community Edition Site or there is a way to get access to environment where db is ready and I can just start my development?

Hi I want to add a uniqueness validation on a particular data for eg. as a user, if i enter "AbCde12" so it should check that existing data should not contain this value in case insensitive form. How to get the list of all permutation an combination of this value "AbCde12". Thanks & Regards Shweta

I am trying to use a!cardChoiceField but need capability to adjust the size of the cards, specifically make them wider. The documentations says to put the card choices component in a columns layout with a specified width to control the number of cards in each row. How do I do it?

Hi there. We have an issue we have been unable to resolve with Appian's default task notifications. We want the "View Task" button from the notification email to send the user to the task on one of our sites rather than through Tempo. We have been able to accomplish this in a couple of our environments by setting the default user start page to: "">our-environment-name.appiancloud.com/.../our-site-page" with a couple others sites set up for specific groups. We have tried the same thing for another one of our environments, but no matter what we've tried with specific groups and default sites, all the task notifications are sending users to the tasks in Tempo rather than the site. We've tried comparing settings across the environments to spot the differences to see why it is working in one place but not the other, but we haven't been successful yet. Is there some other setting that we've missed?

so lets say clothesType is declared as string in db. in a rule, i am iterating over this variable using for each loop. the problem is i can't declare the clothesType as an array as it would affect existing functionality. If i could, it would solve the problem. So, are there any built in appian functions that i can use to run a for each loop over a value that is accepting one value only?

I would like to include Navigation bar as it is described in Navigation Patterns. To make it flexible and to be able to assign particular navigation entry to different users I would like to store in table A all NAV Section (id, name, icon and rule name) and in Table B - userToNavigation mapping. In table B i will store userid, tableAId.  I don't want to list all Navigation sections and then all rules/section as it is in example. I would like based on userToNavigation mapping display proper interface. In other words i need Appian to understand rule saved in table as text to be recognized as proper interface (rule!interface) https://docs.appian.com/suite/help/21.4/navigation-patterns.html

Hi, The requirement is to compare document with its previous version of the same document ID in appian. Is that a possibility and if so any plugin or function that to be used?

Hi All I am working on the Appian portal and trying to upload more than 1 file at a single time, I used maxSelections in file upload field but its not working I am using record Type and local variable because we can't use rule inputs in the portal. Below is my interface code and CDT .

Hi everyone, I need to track my company distribution list (contact group) on outlook email. It should work this way: Sombody sends an email to my distribution list. Receiving the email to my inbox is an action that triggers appian process with parameters extracted from that email. The distribution list that I need to monitor has company domain and it is not on appian cloud. I checked the Receive Message Event documentation but I am still not sure how to approach this task. Thank you in advance,Marcin

Hi all, I am trying to build a selectable editable grid, but everytime I select a row it keeps selecting the entire grid. I saw previous comments that each row needed to have an identifier, and my data does have one, but its identifier status must be getting lost somewhere if a selection on my grid keeps selecting everything. Here is my test code: a!localVariables( local!data: rule!query_case_summary(show5YrAvg: false), local!header: {"age", "gender", "smoker", "amount", "fiveyravg1", "fiveyravg2", "fiveyravg3", "fiveyravg4", "sum5yrChange", "annual5YrChange", "currYrChange", "priorVal", "currVal", "recVal", "reviewStatus", "lastReviewedBy", "userRecVal", "comment"}, local!selectable, { a!gridLayout( headerCells:{ a!forEach(local!header, a!gridLayoutHeaderCell(label:fv!item)) }, rows: a!forEach( items: local!data.data, expression: { a!gridRowLayout( contents:{ /*

Hello i'm just trying to get the name of the past month, im using this code:  proper(text(today(), "MMMM")) But it only generates the name of the current month Thanks!

Hi All, I have the requirement to close the process task after clicking over the button in interface? Can anyone please help me out?

Hi all, I have use case where i need to separate the characters & integer value example- I/p: "ABCD1234"  output: ABCD, 1234   , i/p "A22B45" o/p: AB , 2245 Thanks in advance

i use integration to get country , state , District name with using pincode , i use read only grid to display result but i want only 1 row result how can i do that ?

Hello community, can anyone suggest me how to get second highest number from an array. Thanks in advance

I have used nested foreach and cardlayout inside that im getting the below output. Below is my code. a!columnsLayout(                    marginBelow: "NONE",                    spacing: "NONE",                    columns: {                      a!forEach(                        items: 1+enumerate(2),                             &nb

I want to show a message to user, and it should be disappeared after few second how can i do this

We have an bug where: WHEN a user is in a user input task and allows the timer (1 hr) to terminate the task THEN they are stuck in this screen and not able to close out of the task with the EXCEPTION of closing out of the tab.    My question is besides extending the timer is there any way to circumvent this error or allow users to exit out of the dialogue box without closing the tab?

HI, I have a requirement to display Week Calendar with Meeting conflicts., Used event time line with details pattern and managed to design below calendar  Calendar timeline divided into 30 min sections as meeting possibility 1 or 1.30hr etc.  the issue here is meeting one starts at 11 am and end at 11.30 , it should show meeting tag starts from 11 am and end at 11.30 but it showing two different tags for meeting1, one at 11 am and another at 11.30.  if there is another  meeting same time meeting2, it should show beside to that, and both should be in red. since i have divided timeline into 30 min blocks , i am not sure how to combine two meeting tags if meeting falls for more than 30 min?  Below is the code: a!columnLayout( contents: { a!forEach( items: local!CalenderTime, expression: a!columnsLayout( columns: { a!columnLayout( contents: { a!richTextDisplayField( labelPosition: "COLLAPSED", value: fv!item.updatedTime, align: "CEN

Hi, We have a use case whereby we are looking to do some integration to DevOps and deploy certain packages as needed.  Currently using an four on-prem, azure environments (Dev/Test/PreProd/Prod). What we are looking for is some sort of UI (which we can design and build) where we can select from a list of packages and send this to devops or network location which would then initiate a pipeline release in DevOops and any automated testing that is required. I've had a look and from what I can see, the information relating to packages i.e. names, objects within etc, is not something I can find.  Is this because the information is within the Appian system database or is there a plugin or functions available that I can use to gather this information? UI would consist of a drop down with all packages on that environment. Option to group 1 or more into a bigger package, perform 4-eye review on it and then send to devops.  I know this will need to be built etc but need to fig

In 22.3 the "global search bar" has been centralized somewhat and pinned to the top bar of /Design, with added functionality, which is neat. However the "floating" bar invoked by pressing CTRL-Space is no longer "floating", meaning the CTRL-Space hotkey no longer works at all in a very important (to me, at least) use case: during pop-up dialogs (eg the deployment pop-up, missing precedents, etc). The way it worked before: even if I have a missing precedent checker or deployment window open, but still want to search for and/or open some object, I could just hit CTRL-Space and search:(from 22.2) Meanwhile, after upgrading to 22.3, we can see the "search objects" bar hanging out in the background but being completely useless even if I spam the CTRL-Space hotkey: I can't speak for others here, but I estimate that I personally used this functionality very often to look up and/or open objects I need even when in the middle of a pop-up dialog I don&

Hi Array has 460 items which needs to be displayed in grid but only the first record was displaying among all 460 When calling this interface in the parent interface it is providing only the first records in the grid

Hi, I am working on the Mobile Pocket Library App and I am trying to modify the Book_Summary Interface. I get the following error when I add the ShowBookDetails rule with my record rule input as its book parameter. Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!cardLayout [line 12]: A card layout has an invalid value for "contents". The contents contain a component that is not supported in the card layout. Received: FormLayout I use the following expression just as the Appian tutorial specifies:  rule!ISBN_ShowBookDetails( book: ri!record ) Any assistance with fixing this issue would be extremely appreciated. Thanks so much!

Is there a way to configure the user filter in record for the field for which we are not storing the data in db