Community

Objective is to display the firstName of all active users. a!queryRecordType( recordType: 'recordType!{SYSTEM_RECORD_TYPE_USER}User', fields: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{firstName}firstName', filters: a!queryFilter( field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{active}active', operator: "=", value: true ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)).data ref {user() Function - Appian 23.2} throwing below error  Expression evaluation error at function a!queryRecordType: The record type [identifier=SYSTEM_RECORD_TYPE_USER] cannot be queried because it is a service-backed record type.

Pls answer the below question 1.What is the difference between Entity Backed records and Process Backed records?

The page I am testing has a line chart with a download icon on it with the tooltip Download PNG Image, but I am unsure how to have my FitNesse script perform the download. I see support for downloading charts was added to FitNesse for Appian November 2023 - Release 23.4, but I don't see in the Cheat Sheet or documentation how to download charts.

Hi Team, Beginner here. I need to send a message to a Kafka topic that's used by another team. To do this, we're using a plugin that accepts messages(parameter) as text. The message I need to send is a dictionary in Appian, and I'm converting it into a JSON string using a!toJson(). so that the other team can parse it. However, the other team expects the dictionary to be enclosed in single quotes, like this: '{"a": "hello", "b": 1}'. I have few questions: Is it possible to create such string enclosed in single quotes in Appian? In the Expression Editor's output tab, there are three formats: "formatted," "raw," and "expression." Which one should I consider as a output. I mean the output format we see will be different while passing into pv! right. for example {"a","b","c"} will be shown in the output as below(image), but in the instance if we look at th

Hello I need advice .As my requirement after registered data to database and redirect register form. below is my process model flow. which flow is better and good for redirect interface. Is there any other method other than the Flow I implemented? Thanks

Hi Expert I have an interface where I have read only grid . Now, when the user clicks on completed Status , I want a way to open the interface as a dialog.  if there is a way please let me know. I tried with record action but not able to achieve this . a!gridColumn( label: "Status", sortField: 'recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{status}status', value: a!richTextDisplayField( value: a!richTextItem( text: if( a!isNullOrEmpty( fv!row['recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{status}status'] ), "", fv!row['recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{status}status'] ), link: if( and(fv!row['recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{status}status'] = con

I have an interface where I have read only grid. Now, when the user clicks on Completed Status . I want a way to open the interface as a dialog, if there is a way please let me know. I tried with a!recordactionfield but not able to achieve this . a!gridColumn( label: "Status", sortField: 'recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{status}status', value: a!richTextDisplayField( value: a!richTextItem( text: if( a!isNullOrEmpty( fv!row['recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{status}status'] ), "", fv!row['recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{status}status'] ), link: if( and(fv!row['recordType!{1b81b174-97c1-47ee-aa85-b20723b749c3}CDM2_Target Record.fields.{status}status'] = cons!CDM2_VAL_TARGET_ST

Hi, Can anyone help me with converting multiple map into single map, example input: {a!map(),a!Map(),a!map()} output{a!map()} Help is appreciated

How to click a button to copy data to clipboard in Appian

Hi I am new on Appian and I'm trying to make a PDF from a Word file using a dynamic DOCX template, but I'm having trouble generating the Word file, and I'm not sure where I've gone wrong. I've attached the XML data and Word file that I'm attempting to override [View:/cfs-file/__key/communityserver-discussions-components-files/62/PDFSample.docx:320:240] 1 General ticket New changes Verification 2 1 7125 2 General ticket ghgh 2 2 7141 3 Hardware Issue jhj hjhjk 2 2 7142 4 Software Installation Installation of MSSQL 1 1 5 Software Installation Test Software installation 1 Pending 7191 6 NA Pending 7 Hardware Issue Battery issue 1 2 Pending 8 Others Log Analysis 2 2 Pending Unable to check the logs 0 9 Others Server Upgrade 3 1 Pending Server Needs to upgrade 0 10 General ticket SQL Installation 1 1 Pending Required Sql server to work on Database relat

Hi Everyone, I have two process models p1 and p2. In p1 there is a user input tasks which opens the interface. In this interface there is a save button which runs the p2, but when p2 completes it is not refreshing the interface variables. I am using the refreshAfter param in refreshvariable function. Can anyone please help me out.

In list of variantsI want to create a list of text strings.(As shown in the attached image) I want to understand clearlyAfter trying it out, I couldn't get the expected results.

Join us on May 9 to learn how to leverage Appian’s private generative AI capabilities using the new prompt builder AI skill. Learn how to craft a prompt, add examples for few-shot learning, and use the associated smart service in a process to solve a generative AI use case.  Turn on notifications to make sure you don't miss it!  

The Appian World Live Build Challenge is back for Appian World 2024! Accomplished Appian developers from around the world will compete head-to-head on the main stage, showing off their speed and skill in a timed app-building challenge. Join us on Wednesday, April 17th at Appian World to cheer on our competitors as they battle it out for a chance to win a cash prize and bragging rights. Turn on notifications to make sure you don't miss it!

Dive into the riveting insights from our 2023 Appian Developer Sentiment Survey. Spoiler: Appian developers are accelerating their careers and enjoy delivering mission-critical projects. Check out the full infographic here! Share the story on LinkedIn, Instagram, or X (Twitter) and let the world know how you're making waves with Appian. Want to be a part of next year’s survey? Join Appian Community today.

Tune in on Thursday, March 21, to learn how to use translation sets to internationalize applications easily. Translation sets allow developers to quickly translate apps for users in different countries with a few simple steps. In this stream, we will turn our application into a robust multi-lingual app for users of many languages to use and understand. Turn on notifications to make sure you don't miss it! 

Appian 24.1 is here! Learn about the latest features of the Appian Platform, like the new prompt builder AI skill, Case Management Studio, component plug-ins in portals, and the ability to save and share data fabric analytics. Check out the 24.1 Product Release page for 24.1 highlights, product announcement webinar recording, resources, and more!

Appian World is the ultimate destination for the latest in artificial intelligence, process automation, and digital transformation. You’ll hear from experts, share your successes, and build lasting connections.  This year, we will have an exclusive, Developer Day tailored for the Appian developer community. Gain insights from Appian Community expert-led Tech Talks, engage in collaborative feedback sessions with the Appian Product team, and seize the opportunity to get Appian Certified while on-site. Don't miss your chance to amplify your skills and impact on the Appian ecosystem. We hope to see you in Washington, DC, April 15–17, 2024.

Hi Team, There was a timeout error, what this signifies? Here, we pull the data from snowflake as a batches. In the integration, we have setup to 1500 seconds. Will increasing query timeout help here?

Hi Everyone, I have ha grid having four columns that have a button at the last column. The button is record field action and the grid is selectable. I would like to display the button in that row only which is selected. Can anyone please help me how to achieve this.

Hi All, I'm not having the desired result when using proper() with words including special characters.  We receive the error when the user's name has special characters.  EXP)  O'Neal is being saved as O'neal, Aube-Kubel as Aube-kubel, etc. I need to implement a rule for capitalizing letters after special characters, but not sure how to proceed.  Any assistance is appreciated, thanks!

Hi Experts, Need your help in the following issue: I have created one view that is getting data from a table in a DB. Then I created the CDT for the same from that DB and then the DS is also verified and published with no error. But on retrieving the data from a DB rom a query entity I am getting the following error:   Using the Record Type also I am getting the following error while viewing the Record list, We have only 194 records in that view:  Please help me to identify the cause of the error. 

Hello, im new to appian and we have a requirement that after submitting the Form it should go to the Record List interface next and i have checked and "Confirmation URL" should do the job done. but im having trouble configuring it. i have used : "site and tempo links" dev.appian.com/suite/sites/sandbox/page/record-list dev.appian.com/suite/tempo/reports/view/KQPHyA please help. thank you very much!

I have an editable grid when i go to add a row and fill it with some values and then clone the same row.I want to know that if the user clones or the data of both the rows is the same then the flag should be set to true and if the user clone the row and then change the data in that case set the flag as false. can anybody help me to make expression rule. Thanks 

Hi, I am trying to add page on Acme Auto Mobile Exercise. I keep getting error HTTP code: 504 message when adding the Record List and Content. Does anyone know a workaround for this?