Discussion Categories

I need an Expression Rule that has an or condition for a filed. I have a list of clergy assignments and I need to pull all current assignments and those that terminated over the last year.  The record type, CPMA Clergy Position has a termination date for the assignment, clergyPositionTermEnd which is a date formatted field.  If the assignment is for a fixed term, then there is a future date in the field.  If the assignment is a permanent assignment, then the field date is null.   The or function would look like this. or( RecordType!CPMA Clergy Position.field.clergypositiontermend >= today()-365, isNullOrEmpty(RecordType!CPMA Clergy Position.field.clergypositiontermend) ) However, I do not understand how to use this inside an Expression Rule.  My Expression Rule using the queryRecordType function looks like this. if( a!isNotNullOrEmpty(ri!clergyId), a!queryRecordType( recordType: 'recordType!CPMA Clergy Position', pagingInfo: a!pagin

What’s new in Appian 24.2? See how the latest Appian Platform features can help you: Improve any process and inform any decision with Appian Process HQ. Easily add generative AI to your processes with eleven new AI Skills using an embedded Large Language Model (LLM) powered by a collaboration between Appian and AWS. Streamline tedious development tasks with AI Copilot. Register to join live or get the recording: May 16 at 12:00 p.m. EDT (Americas) May 16 at 12:00 p.m. BST (EMEA) May 17 at 12:00 p.m. AEST (APJ)

Hi Experts,We have a requirement to get files from SFTP server and put in Appian Doc repository.The input we have received from client is that these files size can vary from 1MB to 1GB as there are multimedia files as well.What will be the recommended approach for meeting this requirement. Is it going to cause any impact on the performance of the server or not.What if total size of the files being moved to Appian doc repository exceeds 100 GB.In my assumption we will have to consider our existing cloud storage and request for extra if required. Is there any other server level configuration needs to be done and how can we manage memory in this case? Thanks.

Hello, guys. I am wondering how can I craete a component that has a button to copy its text content to the user's clipboard. I would like to be able to copy the rich text's content only. a!columnLayout( contents: { a!richTextDisplayField( label: "Lorem Ipsum", labelPosition: "ABOVE", value: { "Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt." }, marginBelow: "NONE" ), a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Copy to clipboard", submit: false, width: "MINIMIZE", style: "LINK" ) }, align: "CEN

Hello Team,I'm using a MNI startprocess with the Run one instance for each item in pv!array (spawn all)  along Run all instances at the same time(move when  All instances are done), in process parameters I'm sending pv!array[tp!instanceindex] to another process.In one scenario I have only one element in pv!array, but it triggered 2 instances for the same data. Could anyone explain me why this happening?[mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05]  [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05] 

I have a list of integers from 1 to 100 and i want 30 random numbers from that list how can we do this?

Hey developers, I would like to send an email to a client if their balance reaches a limit. How can I do that? Is it possible to set a condition on the balance in the interface definition and then trigger a process model that sends the email?a!localVariables( local!emailSent, local!button :false(), a!sectionLayout( label: "", labelColor: "#000", contents: { if( ri!account['recordType!{b37748b2-8103-41ea-8028-2b358e4f229c}PBY account.fields.{4a9de4b2-f127-44f1-86d2-21c2a6b2ee2d}Solde'] > 20000000, {}, { a!buttonLayout( a!buttonWidget( label: "Voir détails", value: true, saveInto: { local!button, a!startProcess( processModel: cons!PBY_sendEmail, processParameters: { account: ri!account, }, onSuccess: a!save(local!emailSent, true),

If it's CDT rule input, we can give "{}" simply to provide test values. For recordType! rule input, how to provide value?

I have a bar chart driven by a recordType which displays the value of each bar.  What happens is that these values are being placed on top of the bar for the longest bars. I'm surprised that Appian does not automatically adjust the color when it overlaps the text onto the bar.  How do we get the text readable both overlapped and not overlapped? One easy answer is to use a lighter bar color.... However, I am required to meet WCAG AA color contrast between the white background and the bars.  This means the bars have to be a dark color. I have found that I can adjust the Y-axis maximum value to force the bars to be shorter which keeps the labels to the right of the bar. The challenge with this solution is that the range of possible values is theoretically infinite (practically within about 10-ish years).  The only way to know what the current max value would be to query the recordType ahead of time, add some buffer value to it, set the Y max to that value.&nbsp

We had an interface, while loading the interface in the flow sometimes we are getting Memory Circuit breaker error and we could not able to move forward as we cannot click anything on interface. We already optimized the code to maximum extent. Is there any way that we can show that error in separate section which will not block the interface, so that we can move forward by clicking on submit button

Hi All, we are currently working on the integration where we are sending a document and payload using multi-part form data to another system and we are retrieving the document back on request basis into Appian via Integration object using REST API Calls as we cannot keep the documents in APPIAN.  Document can be any MIME-Type, In this case, we are taking example of .msg file format. when we retrieve the document back from other system, they are attaching boundary data & MIME Type details as shown in the below screenshot. Because of this, .msg file is unable to open after we retrieve the document into Appian and downloaded. Only way is to remove those line items from the document as marked and resaved it. can someone suggest here anyway to ignore the line items in the response and able to open the file. Here is the response Here is the way that I setup my Integration object

I'm evaluating BPM/Decision Engine solutions to integrate with our in-house built platform and I like much of what I see in Appian: its SAAS, so I don't have to host it, it has a lot of documentation and a broad user base with very active support forums. But, I can't tell if they want our business. They don't list any pricing that I can see, and won't respond to my "Contact Us" requests. Is this really just for large enterprises?

Curious if any other practitioners are running into issues with Oracle 12.2 and it's use of editionable views? Currently running Appian 23.3, we are upgrading a business Oracle database we connect to from version 12.1.3 to 12.2. With this version of Oracle, the best practice is promoted no longer reference base tables. Instead, editionable views are automatically created to utilize and this is what is mandated by our Oracle teams, via a synonym pointing to the editionable view on the table. Appian (at least in my current version 23.3), does not seem to support the use of synonyms in this new fashion, as in the past we have always used synonyms within Oracle to satisfy data store validation and operation, for objects residing in different schemas, etc. With Oracle 12.2, these editionable views are created automatically from the first 29 characters of a table name such as below: Table: ORACLE_TABLE_NAMEView:  ORACLE_TABLE_NAME# This practice forces changes to the original synony

Hi there, My Email Smart Service is working great when I upload a plain text document. I need to change how the email looks. Uploading a .txt or a .HTML with the HTML, exposes the HTML while still making the correct replacements from the template. Am I uploading something or doing the HTML incorrectly?  Thank you for any help.

Can you disable dates in a datefield based on a date? That is, disable calendar dates starting from a specific date

I have added some fields to the user interface (UI) and marked those fields as required. The UI that includes these fields has been merged with another UI. This combined UI is then linked to another UI that contains a "save" button. In the "save" button, I have set the validation parameter to true. However, after clicking the save button, the validation for the required fields is not being displayed.

Can we handle the exceptions in Appian interfaces ?

hi  in the abov out put only role tasks were diffrent  so  my requrement here is i want the out put -------  group by comment_id ORDER by created_on DESC.

Hi team, We have a requirement to fetch the data from FTP server where the file exceeds 100Mb size or more and we have to store all those files(100GB) into Appian Folders. We are storing the files to display in grid and then download the file whenever required. Is it recommended to store all those files into Appian, If not what is the best way to do so? Thanks.

Hi all,We are using export to excel default functionality for exporting data from record. We are using priority column as initial sorting field. While exporting to excel, for some users its getting sorted with priority and for some users, its getting sorted with id. What could be the reason for this behaviour? The only difference is for user whose excel is having id as sorting, they can see all cases, while for others, they can see only particular cases due to record level security.TIA

Hi team, im looking a way to start a rule input with data, for example: i get data in a child sail that i need to pass in a parent sail at the first moment the parent sail calls to child

Hello Everyone i need small help regarding to the  "audioPlayerField()", i want to play the mp3 audio in interface so that i am using the  audioPlayerField() but i am unable to play the song can any one help for this 

Based on DR Strategy 3, documented here: https://community.appian.com/success/w/guide/3329/high-availability-and-disaster-recovery-configurations#disaster_recovery, it sounds like it's possible for an HA environment to loose nodes and continue functioning, with some potential updates to configurations.  Has anyone tested this process? If you have 3 engine/data servers, if 1 node goes does, can 2 continue functioning? Likewise, if 2 nodes go down, can 1 function alone? What about search and app servers?

Hello Everyone, I have recently completed all of my Appian Release showcase trainings and got a revised validity date on my Associate Developer Certificate. Can anyone please suggest how I can download my Associate Developer Certificate with the latest validity date on it. (Also I'm not able to find my old Appian associate developer certificate) Please guide. Thanks & regard

Appian delivers process automation powered by enterprise AI. We help organizations connect their customers, partners, and employees in end-to-end processes on a single, secure, platform. This release, Appian 24.2, welcomes new updates to the Appian Platform for process automation, data fabric, enterprise AI, and more. Join April Schuppel and other Appian experts on May 23rd at 11am as they dig into highlights from the release. Tune in to see Appian 24.2 in action and ask the experts your questions. Turn on notifications to make sure you don't miss it!