General

hi,  I am looking to get the start date and end date for all weeks given a month and year. I am learning Appian, I could see some functions in documentation that needs a date. The other way i could think around is write a procedure in the backed and call it , which will add overhead. Any ideas or suggestion will help. 

I am using Locust with Appian to do performance testing. When I am trying to find a link using the options provided in Locust documentation, I am getting the message as "No components with label field_name not found" or "No components with type "record link" found on page. visit_record_type(record_type="Add Start Date")click_button(label="Add Start Date") click_grid_plaintext_record_link(column_name = "Add Start Date") visit_and_get_form("WAR Audit")click_button(label="Add Start Date")click_record_link(label="Add Start Date")click_record_list_action(label ="Add Start Date")click_link(label="Add Start Date") click_record_link(label="Add Start Date") click_record_view_link(label="Add Start Date") click_record_link_by_index(index=1,locust_request_label="Add Start Date")click_grid_rich_text_link(column_name="Add Start Date",row_index=0, grid_labe

When a new task email is generated for a group, it is sending 2 different emails for the users in different time zones. For example people in PST are not copied in the email sent out for EST and vice-versa. Is this an expected behavior? 

We have an application that on a flow assign a series of task to a series of users or group. In this case we have a user that shared to another user  (for internal policy the second one dont have to see, and dont see, the specific set of data related to the task, but this isn't the problem)  The problem is that even the specific task was assigned to a group where there isn't the second user (that have received the task link) if that user use the link, it can see the task. Why? Are there some restriction that i can apply? Obviously we talk about task in report and not in tempo.

can someone answer this question. what are the data management techniques in appian As I am new to appian and this is the question that i have faced in an interview

I am not able to publish portals in appian comunity environment and also not able to create service accounts , can this things be enabled in future.

Hello everyone, In our Appian setup, we are utilizing SAML within Azure to embed Appian interfaces into an Azure application. We've encountered some issues when attempting to call the Microsoft Graph API, so we decided to create a Bridge API in our Azure application and make calls to it directly using the existing browser token connection. When I log into the application using SAML and then open a new browser window to call our Bridge API, I receive the expected data. However, when using a!httpWrite for a POST request to retrieve the API information, the response only returns an HTTP 200 confirmation code without any actual data. I assumed that no additional authentication methods would be necessary since I'm already connected to the application. Has anyone faced a similar issue or can you suggest anything I might have overlooked? Thanks for your help!

I was wondering if obtaining Appian certifications (Analyst and Developer) is a prerequisite for establishing a partnership with Appian. My company has a vast history in developing systems and applications for a wide variety of clients and organizations. Additionally, we possess substantial experience in low-code environments such as Oracle APEX. Is the certification a compulsory requirement for the partnership. can anyone please clarify the specific requirements and certifications needed to pursue an Appian partnership?

Hi there, I am trying to create an expression rule that returns true if a document is not null, and has an ID attached to it. The expression rule is used to determine an XOR node to go to the document deletion node to delete the document if it exists, or to move to the end node if it has already been deleted. Right now, I am using a plugin isObjectExists() and it does work correctly but my supervisor wants me to improve the code to not use that plugin, any ideas for what to do?Here is the expression rule I created, it currently works how I want it to but I want to avoid using the plugin, any help is appreciated!

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.