General

Hi All, I have grid displaying certain records for a specific user, lets say I want to calculate how many days did it take the user to create the next record so for example in the image attached the user created a few on the same day, so if I wanted to add another column next to this one to display number of days, how can I achieve this? the calculation part? because I need to grab the first date of the previous record with the date of the next created record and so on . Is this even possible, or what are your suggestions on finding this kind of information? Thanks in advance

Hello everyone, I'm new to Appian and I want to know if the user record type exists by default in any Appian application. I need to configure a 'create user' node in my process model, so do I need to create a user record manually?

Its mentioned that a site can contain upto 5 pages which doesnt seems to be a valid statement. Can someone guide

DELIMITER $$ CREATE OR REPLACE DEFINER=`dbadmin`@`%` PROCEDURE `FAR_STAGE_BP_IMPACT`() BEGIN UPDATE FAR_BREAKS_STAGE cod INNER JOIN FAR_IBOR_BP_IMPACT_DATA tna ON (cod.FUND_SYMBOL = tna.ACCT_CD_FMRID) SET cod.IBOR_TOTAL_NET_ASSETS_USD = tna.MKT_VAL_USD, cod.BREAK_BP_IMPACT = CASE WHEN IFNULL(cod.IBOR_TOTAL_NET_ASSETS_USD,0) = 0 THEN 0 WHEN cod.DEBIT_CREDIT = 'Debit' THEN CAST(IFNULL(((cod.USD_EQ_Amount / cod.IBOR_TOTAL_NET_ASSETS_USD) * -10000), 0) AS DOUBLE(10, 4)) ELSE CAST(IFNULL(((cod.USD_EQ_Amount / cod.IBOR_TOTAL_NET_ASSETS_USD) * 10000), 0) AS DOUBLE(10, 4)) END WHERE tna.ACCT_CD_FMRID IS NOT NULL and cod.REC_TYPE = 'IBOR'; UPDATE FAR_BREAKS_STAGE cod INNER JOIN FAR_ABOR_BP_IMPACT_DATA tna ON (cod.FUND_NUMBER = tna.ACCOUNT_NUMBER_IO) SET cod.ABOR_TOTAL_NET_ASSETS_USD = tna.TOTAL_NET_ASSETS_USD, cod.BREAK_BP_IMPACT = CASE WHEN IFNULL(cod.ABOR_TOTAL_NET_ASSETS_USD,0) = 0 THEN 0

Hello I have created a stored procedureDELIMITER $$ CREATE OR REPLACE DEFINER=`dbadmin`@`%` PROCEDURE `FAR_STAGE_BP_IMPACT`() BEGIN UPDATE FAR_BREAKS_STAGE cod INNER JOIN FAR_IBOR_BP_IMPACT_DATA tna ON (cod.FUND_SYMBOL = tna.ACCT_CD_FMRID) SET cod.IBOR_TOTAL_NET_ASSETS_USD = tna.MKT_VAL_USD, cod.BREAK_BP_IMPACT = CASE WHEN IFNULL(cod.IBOR_TOTAL_NET_ASSETS_USD,0) = 0 THEN 0 WHEN cod.DEBIT_CREDIT = 'Debit' THEN CAST(IFNULL(((cod.USD_EQ_Amount / cod.IBOR_TOTAL_NET_ASSETS_USD) * -10000), 0) AS DOUBLE(10, 4)) ELSE CAST(IFNULL(((cod.USD_EQ_Amount / cod.IBOR_TOTAL_NET_ASSETS_USD) * 10000), 0) AS DOUBLE(10, 4)) END WHERE tna.ACCT_CD_FMRID IS NOT NULL and cod.REC_TYPE = 'IBOR'; UPDATE FAR_BREAKS_STAGE cod INNER JOIN FAR_ABOR_BP_IMPACT_DATA tna ON (cod.FUND_NUMBER = tna.ACCOUNT_NUMBER_IO) SET cod.ABOR_TOTAL_NET_ASSETS_USD = tna.TOTAL_NET_ASSETS_USD, cod.BREAK_BP_IMPACT = CASE WHEN IFNULL(cod.ABOR_TOTAL

Hi everyone, I'm encountering an issue when performing searches on a RecordType through an interface. The searches work perfectly for all columns except for one that is of type date. I’ve tried changing the format to match the database format (yyyy-MM-dd), but even then, the search returns no results when I query by that date column. Does anyone know why this might be happening or how I can resolve this issue? Thanks in advance! a!gridColumn( label: "Fecha", sortField: 'recordType!{...}.....fields.{....}fecha', value: text(fv!row['recordType!{....}....fields.{....}fecha'], "yyyy-dd-MM"), align: "START", width: "AUTO" ),

Getting below error when opening "Summary Page" in Studio site of Case Management Studio. We have not changed any object in Case Management Studio applications manually. Can anyone help with this? Expression evaluation error [evaluation ID = 265c9:30306] in rule 'cmgt_cb_studio_displaybuilder' (called by rules 'cmgt_cb_sitepage_casetypes_caseview' > 'cmgt_wfl_sitepage_casetypes') : Invalid index: Cannot index property 'targetRecordTypeUuid' of type Text into type List of Variant

Is there an option in Appian that may allow me to mass delete rule inputs placed in my interface in Appian? There seems to be no option but having to resort to deleting each rule input one by one which is a little time consuming. 

Hello Appian enthusiasts, I am trying to improve an internal deployment process, and one thing that pop up is the need to update "Group Attributes" in every environment, because we are using SAML Sync. I know Stefan already published an awesome article proposing a solution (SAML Group Sync – Appian Rocks). However, it is for applications starting from scratch. In my case the pieces are already setup. Then, I couldn't find in the documentation a way to use the Customization File for that (Managing Import Customization Files - Appian 24.2). Is there a way to update the group attribute during the deploy or am I asking too much from the Customization File capabilities? Thanks in advance for all!

It's common practice to store the Appian username to the database for the createdBy, updatedBy, assigned, and similar fields. It's easy to handle in Appian to support search and filter capabilities when referencing those fields in a record type. But occasionally an associate has a name change, which subsequently causes their Appian username to change, since it's often their email address or something similar. That change disrupts the different features that depend on the username to match in Appian. At my current client, we're trying to mitigate that disruption by storing the UUID for each user instead. It's easy to use the People Functions plug-in to derive all of the user's information from that UUID. But, search, filters, and sorting will use the UUID. I tried remedying that by creating a custom record field, but it doesn't allow the user() function (or any plug-in function) to be called from the expression. How can I do this without resorting to a CDT an

Hi Champs, Can I able to change the color of icon for an Appian record action. Regards, Ghanashyam

Hi, I have requirement like below. I have one main Record Type( MFU TestData), in that I will store some columns, And I have Second Record Type(MFU TestFiles), In that I will save files. and It is referencing above table.  Can someone please help me to upload multiple files and save them to folder and save the values to database. Please help me to write expression which stores data to main table and list of files to second table. I am getting the following error if select the column from reference table ri!record['recordType!MFU TestData.relationships.mfuTestfiles.fields.fileName']

Can anyone let me know if there is a way to update the group security using the Create Group smart service or any other method? Currently, my functionality requires me to create multiple groups with a single click. While this process successfully creates the groups, it automatically adds me as an admin to each group. I need to remove the creator’s name from the security settings. If you have any solutions or suggestions for this issue, please let me know.

Hi Champs, I have a map value having multiple key and value pair. Now I want to check for a value which exists in one or more key. So I guess the only way to do that is to iterate over the keys in the map.  How can I achieve the same. As of my knowledge, for each works for no of map not for no of key/value pair in a map. Regards, Ghanashyam

I want to learn the most efficient way to create groups for markets,so that I don’t have to spend a lot of time recreating the same groups for 8 markets, want to implement group permissions for multiple markets at once.I know we have smart service to create groups and also we have plugin called Peoples functions plug-in. Do we have any other way ?

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.

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?

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

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