Foundation

I'm having some issues understanding how to use indexes into a forEach taking the items from a expression rule. I'll explain my problem a little bit deeper; I'm trying to get some of the properties from the RecordType "Anomalie", i would like to use the expression rule with get me all of the anomalies linked to a specific pension by the pensionid, and get the description, the name, the action related to it. But i'm having trubles indexing these properties once I call the expression rule. When I try to use fv!item.description into the description rich text field it seems like it doesn't recognize the object as a record type.  I pasted the code snippet for the forEach i have in the interface, does anyone had some similar issues and may give me suggestions on what to try to make it work? Thank you so much!! (my finished product should be a card for each anomaly found linked to the record Beneficiary, each with their description, name and related action)

Hi All, I have a requirement to download the data into excel using web api in Appian. Data is coming from external API. Using web api, I am able to dowload .csv and.xls file. But To download the .xlsx file. Is there any way. Currently I am writing the sample code like below. a!localVariables( local!data:{ {name:"A",age:10}, {name:"A",age:10} }, a!httpResponse( headers: { a!httpHeader( name: "Content-Type", value: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" ), a!httpHeader( name: "Content-Disposition", value: "attachment; filename= test.xlsx" ) }, body:local!data ) ) whenever i tried to open the file. Below is the error. Can you please tell how can we resolve this issue? .  Thanks in Advance!!

Hi Appian Community, Any cloud customers experienced this issue? Our clients report not receiving our outbound emails that have been custom configured already in the Sender field (i.e. not Process, Process Designer, Process Model, or Process Initiator that will create different sender names) but a custom and consistent sender name. We have verified that the DNS in the SPF records contain all of our Appian site names. We also enabled DKIM to contain a verified email signature. However, whenever our shared Appian mail server IPs get added to the Outlook/Microsoft global block list, our outbound emails get blocked. Any resolution that anybody implemented to get around this issue? Thanks in advance.

Hello Everyone, In my record view interface, I have a child interface that contains a related action. I recently added another related action whose only purpose is to refresh the data. In the parent interface, I’m using a!refreshVariable() so that local variables are refreshed after a record action completes. The related action in the child interface has visibility logic defined both: in the record type (Views and Actions → action security/visibility), andinside the child interface itself.When I click my refresh-related action, all the data and components in the interface are refreshed, but the visibility condition defined in Views and Actions is not re-evaluated. As a result, when I refresh to load the latest data, the related action does not appear on the screen unless I do a full browser refresh. i tried to have a start form in my related action's process model even at that time screen was not refreshed. Pretty much tried everything still record level security was not

The grid was working fine before 2 days but now started to face this issue. None of the grid is loading

Consider blue path only! I used activity chain to start "Choose policy" interface immediately after the main interface. The process is started by a startProcess inside a saveinto of a buttonWidget. After clicking the button the process starts, but the interface isn't automatically loaded. The owner of the task is set as pp!initiator. What could I miss?

We are encountering the following error in our Appian application: ERROR com.appiancorp.record.service.visitor.DiscoverAllRecordBindings - Exception encountered in grid field tree visitor, falling back in try catch.java.lang.NullPointerException This issue appears while working with a grid component (record-based or interface grid). There are no obvious breaking changes, but the error is being logged intermittently. We suspect it may be related to: Null values in grid field bindings Record type relationships Nested field references in grid columns However, we are unable to pinpoint the exact cause. What typically causes this DiscoverAllRecordBindings NullPointerException? Are there recommended best practices to avoid this issue in grid configurations? How can we effectively debug which field or binding is causing the problem? Any guidance or suggestions would be greatly appreciated!

Hello Everyone, I’m using a Styled Text Editor for my comment thread component. If the character count exceeds 500 characters, I need to trim the text and display a "Show more" link outside the Styled Text Editor. The problem I’m facing is that the Styled Text Editor stores values with HTML tags, so when I trim the content directly, it can cut through tags and break the markup. This results in invalid HTML and rendering issues. Has anyone implemented an approach to safely truncate HTML without breaking tags? Any suggestions or best practices would be appreciated.

Hi All, There is a scheduler process that runs hourly and fetches data from a third-party system, then syncs it into an Appian table. This process is handling around 1,400 records. For each record, data needs to be queried from an integration. Currently, the parent process batches 50 records at a time and calls a sub-process to process each record. Inside the sub-process, the integration call is made, and the data is constructed and synced into the Appian table. In total, 29 batches are running. Since this runs hourly, it is taking around 12 minutes to complete in production for all 29 batches. However, the sub-process is being highlighted as one of the top processes consuming engine time, and it is also consuming a noticeable amount of CPU. I’m not sure if this is missing any design guidance. Can someone help how to resolve this health check highlight? Note- Each integration call takes around 600 ms. Health check Highlight is below.

Hi, I've found in an existing code application this function called with 5 parameters (please see below). But the Appian documentation says that the Property function must have 3 parameters only. This code works, but throw an error in Design mode (exactly like the "if" function which can take more than 3 parameters).  How would you replace this code ? with additional if conditions ?  property(  local!availabilityResponse,  "body",  "resources",  "type",  null)Regards

We have a dynamic array containing lists of data. Dynamic here meaning data1, data2..etc could be any length. We need a screen that allows users to reorder this data and we are attempting to do this with a gridLayout with allowRowReordering = true. When attempting this example below, we are seeing the error Expression evaluation error at function a!gridLayout [line 15]: A grid layout component [label="data1"] has an invalid value for "rowOrderData". The value must be a list of records, a list of maps, or a list of dictionaries. a!localVariables( local!map: { "data1", "data2" }, local!data: { data1: { { sortOrder: 1, label: "A" }, { sortOrder: 2, label: "B" } }, data2: { { sortOrder: 1, label: "C" }, { sortOrder: 2, label: "D" } } }, a!forEach( items: local!map, expression: a!gridLayout( label: fv!item, headerCells: { a!gridLayoutHeaderCell(label: "Checklist Sections") }, rows: a!

Hello All, I have a requirement where user can open the ui and redirects to the url that was mentioned in the ui and can change the data in the new tab.After changing the data. we are giving an buttonwidget in the ui to refresh a variable to know whether data had changed or not. It returns true or false based on the actions done in the different tab. But the problem I am seeing button is not working as expected. Below is the codea!buttonWidget( label: "REFRESH", value:ri!refresh, saveInto: { a!save( ri!refresh, rule!SD_IsDataChanged( )id:ri!id ) },On the above i am getting the data from the database to check data is updated or not and storing in the refresh variable. the problem here is first when user clicked on the refresh , refresh variable is storing the expected value. but later if i change the data and click on the button again it still having the same value. i doubt whether button save is working or not beacuse when i open the actual rule its giving the correct boo

I am trying to create a personal account, but I am receiving an error saying that an account already exists. I forgot my password, and when I try to use the “Forgot Password” option, I am not receiving any reset link to my personal email ID. Should I create a support ticket to resolve this issue?

I requested the transfer of my credentials, Community and Academy achievements, Academy historical training data, and Community activity history a couple of days ago. However, the transfer has not yet been completed. Typically, this process is finished within two working days, but it seems to be taking longer than expected. Could you please let me know how much additional time it will take? Also, is there a toll-free number I can contact for assistance? Additionally, I would like to know whether it is okay to leave the organization before the transfer of my credentials, Community and Academy achievements, Academy historical training data, and Community activity history is completed. If so, how can I continue to receive communications that are currently being sent to my organization email after I leave? Is there a way to update my email ID in the community profile so that all future communications can be redirected to my personal email address? Could someone please assist me with this?

Hi everyone, I’m working on an interface where the user needs to upload an Excel file with the .xlsx extension. My goal is to validate the file extension directly in the interface, before enabling the "ACCEPT" button. In my current setup, I’m using the disabled parameter of the a!buttonWidget() to check two things: That the variable local!excel is not null or empty. That the uploaded file name (converted to string) contains the .xlsx extension, which I have defined in a constant (cons!CEDT_CONS_EXTENSIONES_DOCUMENTOS). When I use touniformstring(local!excel), it only returns the file ID (a numeric value), not the original file name. Because of that, I can’t compare it with the extension constant to validate the file type. Here I’m attaching a demonstration of the interface when I upload a file that is not an Excel type.  Is there any way to retrieve the original file name (or its extension) from the uploaded file in the interface, so I

Hi Team, I’m unable to see the new Appian 26.1 release in my Appian Academy learning environment. It still shows the older version, and the new release content isn’t appearing for me. Has anyone else faced this issue? Could someone check and let me know if the release is available on your side, or if there’s something I need to do to get it updated? Thanks in advance!

Hi  I'm currently exploring Case Management and wanted to check with the community whether it's possible to use Google Mail (Gmail) to set up case creation via email. If this is supported, could you please share any guides or documentation on how to configure it? In the documentation I reviewed, it seems that case creation via email is mentioned only for Microsoft email (Outlook). I would like to confirm whether Gmail can also be used for this purpose and what the recommended approach would be. Thanks  Rahul Gundu

Hi Appian Community! I have a requirement where in the column chart below, I need to show a breakdown of the data for each bar of all the series based on the date. I had to manipulate the dataset so using a record type was not possible. Now I have my data structured where  x-axis is dates, and y-axis is the percentage of each area of the office's seat booking. How do I show within each bar, a breakdown of say half is booking type A and the other half is booking type B?

Hi everyone, I am building a report that is accessed by a Super Admin (business user). The purpose of the report is to display which users belong to which groups. To retrieve the group information, I am using the a!groupsForUser() function. However, when the report runs under the business user context, I receive the following error: Expression evaluation error in rule at function a!groupsForUser [line 6]: The user does not have sufficient privileges to get groups for user. [User Context: ...] does not have sufficient privileges to perform the requested action. It appears that this happens because some users belong to restricted groups (for example Developer groups or Health Report groups) that the business user running the report does not have permission to view. Because of this, the entire report fails instead of simply ignoring those restricted groups. My question: Is there a way to: Retrieve only the groups that the logged-in user has permission to see, without the expression fa

My Appian Senior developer certification had an expiration date of March 18.I have completed the 25.4 Release showcase on the same day.Could you please confirm if my certification will be considered renewed based on the showcase completion.Regards,Priyadharshini.S

Hi All, I'm trying to pass Json type data input (which is a rule from my interface sending it to process model via start process) to JsonToExcel Smart Service. I need the output format as below. Please advise. expected sample output format - = "[{ ""startPublicationDate"": ""2021-09-05"",""endPublicationDate"": ""2021-09-05""   }]" The challenge I see here is my rule has nested rules inside it and output is a list of dictionary. 

Hi Appian Community, I'm working on a PickerField component that needs to display data from a large dataset (~15,000 rows). Here are my requirements: Requirements: Display a PickerField with approximately 15,000 rows of data Implement a search functionality that only triggers after the user enters 3 or more characters Load the data using a Record Type as the data source Optimize performance to handle the large dataset efficiently Current Challenge: I want to avoid loading all 15,000 rows upfront for performance reasons. Instead, I'd like the search to execute only when

org.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session:

Hi All, Please help on below -  I'm trying to pass my below rule to JsonToExcel Smart Service which needs a json data. How do I pass this rule so my output looks something like this: expected output sample - "[   {     ""Name"": ""Robert"",""age"": ""30""   }]" Rule I want to convert to json by passing from process parameters in start process- a!localVariables( local!data: a!refreshVariable( /*RMSP1-2105 - Added rule input - refresh to getlatest data*/ value: a!queryEntity( entity: cons!RMO_ENTITY_VW_EMPLOYEES, query: a!query( selection: if( rule!RMO_RULE_isNullorEmpty(ri!columns), rule!RMO_RULE_employeeSelection(), a!querySelection( columns: a!forEach( items: ri!columns, expression: a!queryColumn(field: fv!item) ) ) ), logicalExpression: a!queryLogicalExpression( operator: "AND",

Hello Folks,We are trying to deploy a Process HQ report to higher environments, but while doing it,  we are seeing protected as status for the Process HQ Report Object, did any one faced this or have idea?Please let me know as this is a high priority task. Appreciate your time & response![mention:9861aef97eb2483a8b76175d9eda1e37:e9ed411860ed4f2ba0265705b8793d05]