General

Hi,  I want to remove the null value keys from the list of the map below. Please let me know how to achieve that:{a!map(ABC: 6.7, EFG: 15.44, HIJ: 470.888, KLM: "9.8989984", OPQ: null), a!map(ABC: 8.4, EFG: 15.43, HIJ: 470.656, KLM: "9.2342", OPQ: null), a!map(ABC: 7.2, EFG: 15.42, HIJ: 470.554, KLM: "9.234234", OPQ: null), a!map(ABC: 5.6, EFG: 15.42, HIJ: 470.234, KLM: "9.63242", OPQ: null), a!map(ABC: "", EFG: 15.42, HIJ: 470.665, KLM: "9.54343", OPQ: null)} Regards, Sowvik

Expression Rule Body: a!localVariables(  local!formatDetails: {{format: "#.#", columnorder: 9, name: "ABC"}, {format: "#.##", columnorder: 11, name: "EFG"}, {format: "#.###", columnorder: 9, name: "HIJ"}, {format: "#.#", columnorder: 11, name: "KLM"}},  local!data: {a!map(ABC: "6.78998", EFG: "15.44443", HIJ: "470.8888", KLM: "9.8989984"), a!map(ABC: "8.44544", EFG: "15.4323", HIJ: "470.656565", KLM: "9.2342"), a!map(ABC: "7.232323", EFG: "15.4234234", HIJ: "470.55445", KLM: "9.234234"), a!map(ABC: "5.64545", EFG: "15.4234234", HIJ: "470.2342", KLM: "9.63242"), a!map(ABC: "453.345345", EFG: "15.4234234", HIJ: "470.665434", KLM: "9.54343")},  a!forEach(    items: local!formatDetails,&nbs

We did cleaning up of process model version for around 800+ process models in our environment. But we didnt see any reduction in memory utlization % or disk used %. Can anyone tell where versions are stored and how they affect memory utilization??

Has anyone figured out a way to export a DMN file from the Decision Table in Appian? We want Appian to be the source of the rules, but we need the DMN model so we can execute the logic on another offline system which must get the same results as if it were run on Appian. Appian claims it uses DMN, but doesn't actually supply the DMN model...which seems odd. Thanks.

I am planning to take Certification ACD200. Is there any prerequisite before taking ACD200?  Can I take the exam directly or should I need to pass ACD100 before ACD200? 

Is it possible in Appian to have sound on click? like on cards, charts, gauge etc.

Hi team We've just set up an application that uses the Send E-Mail Smart Service. Our Health Check Report has this to say: "SAL Approve Installation (0002edb5-ade8-8000-43ed-7f0000014e7a) Node: ""Send To user"" references a smart service that is no longer recommended for use (Send E-Mail). Please remap this node in the process model to use the latest version." I can find nothing in Appian documentation saying Send E-Mail is no longer recommended for use I can find no details in Appian documentation of any Smart Service that might replace this I can't seem to find a thread in this Community that addresses this issue Can anyone assist me to resolve this?Thanks and blessings Stephen

Trying to move the logic from query entity connecting to VW to Proc with input parameter and was able to create a Procedure on Maria DB . Challenge is trying to recreate includes operator logic for an column on proc using LIKE operator but not able to achieve it 100% currently got to an extend as below , there are multiple input paramter on WHERE clause and one below AND ( input_parameter IS NULL OR input_parameter = '' OR REPLACE (LOWER(COLUMN_NAME),' ' , '')  LIKE REPLACE (LOWER(input_parameter),' ' , '') ) additional checks made From Appian while passing the input parameter have also converted the input parameter to lower case and have appended %% before and after the string Input parameter definition have set charset as per the column definition. Still issue is value with alphanumeric value ending with number fails Ex: %abc1234_def4%. No result (actual record exists), but %abc1234_def% gives results 

hmacsha256bytehashbase64key - We are using this funciton in appian onpremise and now we are deploying to cloud . In cloud this function is not supporting .Is there any alternative function to use instead of hmacsha256bytehashbase64key ?Thanks

Hi, I am trying to generate excel document by using the a!exportDataStoreEntityToCsv(). Below is my code snippet: load( local!exportDocId, local!errorMessage, { if( isnull(local!exportDocId), a!linkField( labelPosition: "COLLAPSED", links:a!dynamicLink( Label: "Export Inactive Users Details to Excel", saveinto:{ a!exportDataStoreEntityToCsv( entity: cons!VW_EPMT_EWR, selection: a!querySelection( columns:{ a!queryColumn( field: "ewr_number" ), a!queryColumn( field: "name" ), a!queryColumn( field: "active" ) } ), documentName: "EWR Grid Record Data", saveInFolder: cons!EWR_FOLDER, onSuccess: a!save( local!exportDocId, fv!newDocument ), onError: a!save( local!errorMessage, "Error in Exporting File" ) ) } ) ), {} ), if( not(isnull(local!exportDocId)), a!linkField( links:a!documentDownloadLink( Label:"Download Excel File", document: local!exportDocId ) ), a!textField( value:local!errorMessage, readonly:true ) )

I am running some processing in parallel that includes api calls.The result with then populate an interface attended by a user. I have tried both a!forEach and MNI but for both the performance is not as expected. By looking at the performance tab in the expression rule, it is clear that the items in the array are running sequentially and not in parallel, as the total time for the expression rule is the sum of every iteration. As a test I tried to put only a GET api call in the foreach loop and the result is the same. This is not what I was expecting, is there anything that can be done to enforce the threads to run in parallel to optimize the performance?

The description tooltip is not visible when hovering on the Record action icon. Although I was aware it was there, now unable to see this tooltip on icon.

I'm currently in the process of scheduling my first Appian certification exam. During registration, I was redirected to the Registration | ProctorU platform, which requires me to select an institution. However, I couldn't find my company's name listed, and this field is marked as mandatory. Could you please advise on how to proceed?

Hi, I want to show the following hierarchy image in my interface.  How can I achieve this?  Please provide the coding.

Hello everyone, We are currently working on integrating an external tool (let’s call it ExternalTool) with Appian. This tool sends data to Appian via an API, and we would like to know: Is it possible to store one or more fields (such as "ReferenceCode") directly into the Appian database at the time the API call is received, without requiring any user interaction or manual processing? If anyone has experience with this kind of direct data persistence from external APIs, your guidance or best practices would be greatly appreciated. Thanks in advance for your help!

Ideas which will covers all Basic Appian Features with good complexity - New To Appian.

I have a scenario where I need to call an integration multiple times for an array of items. That needs to be done in parallel as the result is then presented to the user in a form. The problem I have is that I need to save the output of the function (the output of the api is then processed further) in a process variable, and I am  not sure how to do that. If I set a node to run multiple times with an output variable, when all the instances end it will have saved only the result of the first instance (which is a CDT), while I would like the output variable to contain an array with all the replies. How can this be done?

Could someone share the configuration steps for setting up an Entra ID (Azure AD) application to enable SAML authentication for an Appian application instance?

Hello All, I have a requirement to get the document, Currently document is not there in Appian as it is stored in S3 bucket and coming as url to Appian. When user clicks on that url,  document is getting downloaded. But I need that document without user action. Is there any way to do that? Thanks in Advance!!

With CDTs I can do something like this to initialise a CDT with all fields set to blank/nullcast( 'type!{urn:com:appian:types}CustomType', {} ) Is anyone aware of a similar approach with records? Casting {}, null(), or a!map() to a record type just returns null In this use case I won't know the field names to be able to use them. I only have the record type **Edit: Adding more context If the record type has fields A, B and c then each of those fields needs to be set with null/blank (which is what would happen with the CDT). eg the value returned is recordType!CustomType(a: null, b: null, c: null)

Hi Everyone, I need to get "choiceLabels" and "choiceValues" list from the dictionary as shown in screenshot. Can anyone please help me how to get it?

I am having Appian 24.2 version and the recordtype is having only few records <100 and also few columns <10. When i created the recordtype, it has sync disabed. Export to excel button is visible and aso clickable. But when i click that button, download is keep on happening for full day but dint return excel. This is happening for all record types. Please let me know what might be issue.

Looking for an Appian tutor to get me over the hump for senior by next friday. Was close on first attempt. Please reply if interested. 

We have some Appian administrator users who, when they try to access process supervision, edit the process, and try to change a value in a node, do not see all the tabs and cannot change anything. For all other administrator users, it displays correctly. At first glance, it seems that both have the same groups, but we don't understand why the tabs don't appear. We are probably missing some groups, but we thought that an administrator could do everything.  Is that right? Thank you very much for your help.

We are trying to enter a decimal number into a!floatingPointField and storing it in Number(Decimal) field. Since it is a decimal we are trying to save it using rounddown(value, 2) so as to allow only 2 decimals according to our requirement. Note: This functionality is being used in editable grids. While doing so, for certain fields we are getting random numbers keep appearing after the decimal for the numbers. (47.3 shows as 47.3000000004, etc.). This is happening only for that particular row for only a specific value i.e in the example 47.30 only will show 47.3000000004, if we enter 47.322445 it will round down to 47.32. We tried using, round(), roundup(), rounddown() and floor(). SInce we have mutliple grids in the same fashion, this issue seems to appear in atleast 1 grid row.