Foundation

I am having issue running FitNesse with Edge browser. Google Chrome and Firefox does not have any issue. I would appreciate if someone could shed some light on this. Thanks.

Hello,  When a process is started from a timer and no user is assigned to it, what user will have started that process?For example, when viewing process instances, who will be the user in the Started By column? Thank you,  Nick

Hi Alla!localVariables( local!crFeesComments_cdt: rule!CR_FN_getModuleComments( crModuleComments: ri!crModuleComments_cdt, commentId_int: cons!CR_AS_COMMENT_IDS[1] ), local!crPricingApprovalComments_cdt: rule!CR_FN_getModuleComments( crModuleComments: ri!crModuleComments_cdt, commentId_int: cons!CR_AS_COMMENT_IDS[2] ), local!crFxRatesBuy_cdt: index( ri!crFxRatesFromDb_cdt, wherecontains( { 1, 2, 3 }, index( ri!crFxRatesFromDb_cdt, "seqNumber_int", {} ) ), {} ), local!crFxRatesSell_cdt: index( ri!crFxRatesFromDb_cdt, wherecontains( { 4, 5, 6 }, index( ri!crFxRatesFromDb_cdt, "seqNumber_int", {} ) ), {} ), { rule!CR_RT_displayInformativeNote( pageName_txt: cons!CR_TXT_SECTION_NAMES_TODISPLAY_AMOUNT[3] ), rule!CR_SC_AS_displayROCOverview( cif_int: ri!cif_int, systemRequestId_int: ri!systemRequestId_int, cr

Hi All, I want to understand matrix for role segregation and activities that one can do as basic user vs sys admin . Generally  I want to create a matrix for business presentation defining global user vs sys admin access matrix. Can anyone please help. Thanks Bihitak

Hello, is there any way to round the corners of a progress bar or a bar chart in Appian?

When you click the add button, the CardLayout component is duplicated along with its fields. Consequently, the dropdowns in each card layout are showing the same selected value as the dropdown in the first card layout. How should I handle saving the data to ensure that each dropdown maintains its own selected value?  a!localVariables( local!count: 1, local!destChildFields: a!map( status: { description: "Status", type: "integer", questionSet: "global", required: false, enum: { 12, 13, 14, 15, 16 }, enumLabels: { "To Do", "In Progress", "Escalated", "Withdrawn", "Resolved" }, typedesc: "Single-Select" }, subStatus: { description: "SubStatus", type: "integer", questionSet: "global", required: false, enum: { 17, 54, 21, 18, 19, 10019, 10021, 10018, 95, 10016, 10026,

Is there a good way to convert a list of items with no more than 1 item in it to a single item? There are 2 ways I know of, both have minor issues depending on the context.  1) use an index such as array[1] to get the first value of the array - This works, but requires some null checking in case the array is empty as it will bug out if that is the case. 2) use cast, but this requires knowing the type ahead of time, and if that's not possible, neither is this casting method.  Is there any other way I'm missing? Some hidden fromList() function I haven't found yet?

Dear experts, I have a PM with user input task, in task form, I define one submit button, which submit is true, validation is true, in this task form, it have a child interface, which have a paragraph field which required is true. However when I keep this paragraph field as empty and press the submit button, user input task completed, PM completed, no validation here. What maybe the possible reason here?

I am working on build an application: step 9 of the Acme Auto App. Currently working on the Process Model.  When I save and publish I get 2 errors: The first one says that "there was an error in an expression in at:" but gives me no further information. When I click on it it takes me to properties but I don't know where to look. I checked the troubleshooting suggested on the lesson but did not find anything. What can I do to fix it? The second it says the process model contains a variable that it does not reference. I'm assuming this is because I will reference this variable later but I am no 100% sure. Is that correct? Thanks in advance, Gabriel

Hi, Please suggest how can i fetch first 100 rows using export data store entity to excel. In filters input we can use only a!queryFilter and a!queryLogicalExpression. Thanks

hi,  I have an editable grid and save the selected rows in the a variable local!selectedrows, has fields {id:1, name:"test1, age:"60"                  {id:2,name:test1,age:"70"} have another variable  local!displayitems has a nested list .    {id:2,name:test1,age:"70"} is present inside the second index and 5 th item    please suggest how to write code for this.  my intent is i have to update the selected Row into the display items by indexing it upon button click.

Hi team, I have a use case where I need to delete old data. Imagine I have three tables: employee, address, and documents. To delete an employee, I need to store documents and address in history tables then i need to break the dependency (foreign key mappings) from documents and address . Then, I need to move the employee details to a history table before deleting the employees. So, I have a process model which executes these steps in individual query database nodes, like moving details to the history table using inserts, then breaking dependency using update, then moving employee details to history using inserts, and finally deleting employees using delete. These tables are just examples; I'm doing a similar process which I cannot fully explain here. The thing is, my production table has 110GB of data, so performing this operation for 3k employees took more than 3.5 hours. So, I planned to process in parallel using startprocess MNI. It is wo

For each request, we have an audit history that I'm displaying as tabular data with 2 rows per page. However, this creates an issue: if I show only 2 rows per page, the remaining space on the page looks empty. On the other hand, if I display 3 rows per page, it doesn’t fit well if any row contains a large amount of data.Below I have attached reference code for this:Note:We have to display header and general info after page breakany Alternatives for this,a!localVariables( local!requestAuditLog:rule!EPR_QE_V_getRequestAuditLog(requestId:ri!requestId,actionNotIn: cons!EPR_ACTION_LIST[1]), local!tableHeadings: { "Date", "User Name", "Action Taken", "Note" }, " "&if(a!isNullOrEmpty(local!requestAuditLog),"No Notes avaliable for this request", " AR Notes " & local!tableHeadings[1] & " " & local!tableHeadings[2] & " " & local!tableHeadings[3] & " " & local!tableHeadings[4] & " "&a!localVariables( local!rows: a!forEach( items: local!re

Hi  I want to achieve such a grid, wherein there will be 1 value in the left row and can have multiple values in the right row denoting that values Mango -> Cherry belong to fruit type  Can this be achieved using any of the grid components available ?

Hi, Is there any way to increase tooltip character limit. As of now I can see it is restricted to 200, is there any way to increase it? Thank you.

Hi All,I am calling 2 values from my record type in the DATE and TIME format and I want it to produce the amount of days in between the dates.Saw this suggestion in a previous post in regular date format: tointeger(tointervalds(today()) - tointervalds(today()) but did not work from the date due to not able to calculate different in seconds?

HI everyone,  Could you help explain me how below code works? The character "_" is new to me and I cannot find any documentation for it.  apply( contains( index( local!childTask, "id", null ), _ ), index( local!parent, "id", null ) )

Hi, Please suggest some ways through which I can avoid multiple users accessing same record at same time . Thanks

Hi everyone, do you know if is it possible to remove completely the header row into gridLayout component? I want to remove the entire header row, not the label only. If it is not possible, do you know other components that allow you to do this? Thank you

Hey , I have a scenario  like I have a interface where there is a grid and there will be a button named as export to excel and upon clicking the button  I will trigger a process model that will export the data which i will pass from interface to the process model by rule input . Can anyone please guide me the steps to achieve this scenario . and one thing we should not use export DSE to excel smart service . Thanks in advance !

Hello,  Does anyone know of a way to return a folder's description?  The folder() and getcontentdetailsbyuudi() functions don't pull back that piece of metadata, unfortunately.. I see some plug-ins that will allow me to edit the description; however, I am in need of returning the Appian Folder's description to display before I go through creating a table to store and pull all the folder data all this data simultaneously. 

Section might contain the fields like dropdown, flieupload ,.. those should also get repeated 

Hi All, During our upgrade from 21.4 to 22.1, we noticed below error when we were starting the services. Does anyone meet this error before? I checked the process model but can't see anything related to "Expression evaluation environment". Thank you. 2022-04-14 14:18:14,135 [localhost-startStop-1] INFO  com.appiancorp.cache.persist.ProcessDesignBroadcaster - Initializing ProcessDesignBroadcaster2022-04-14 14:18:19,625 [localhost-startStop-1] ERROR com.appiancorp.process.engine.ProcessEngineServiceImpl - Invalid expression: processNodes@9/Get All Fields@activityClass@outputExpressions@Expression evaluation environment has not been configured. Either configure MinimalEvaluationEnvironment or use ServerEvaluationEnvironmentSpringConfig2022-04-14 14:18:19,625 [localhost-startStop-1] ERROR com.appiancorp.process.engine.ProcessEngineServiceImpl - Invalid expression: processNodes@9/Get All Fields@activityClass@outputExpressions@Expression evaluation environment has not be

Hello Everyone, I have an "multipleMeetings" array process variable which of MAP type, its holding the meeting related data as shown in below image, I am running a subprocess(to store it in a database) for each meeting present in multipleMeeting PV by enabling MNI. In the subprocess by inserting the meeting data in database, storing meeting data in meetingDataPV which is single type of meetingInfo CDT, so every time the sub process completes it execution it returns the meetingDataPV to parent process now in parent process i want to append it to another variable which is also a meetingInfo CDT type, but the problem is its appending the last executed instance's meeting data only. Can anyone help me in this?

Hi, could someone explain me the answer of this question? Q: One of the process models in your application takes 6 days to complete. You are considering reducing the days until a process archives after completion from 4 to 2. What percent of memory reduction for this process model would you expect to see after this change? A: 20%