Foundation

Good day, I downloaded the Database Load Generator on the App Market and tried to import it on the environment, but I've been having data store error? anyone have suggestion/insights on how to solve this problem? I've also already added the plugins that are needed for this.

What is the reason behind this error? Can anyone suggest on this please?I have mapped the correct rules only. Thanks in advance.

a!dropdownField( label: "POL", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: local!polDetails.pol, choiceValues: local!polDetails.id, value: local!pol, saveInto: { local!psl, a!save(local!selectedSubPol, null) }, searchDisplay: "AUTO", validations: {} ), a!multipleDropdownField( label: "Sub - POL", labelPosition: "ABOVE", placeholder: "--- Select Values ---", choiceLabels: local!subPol.subPol, choiceValues: local!subPol.id, value: if(a!isNotNullOrEmpty(local!pol),local!subPol.id,local!selectedsubPol), saveInto: { local!selectedsubPol, a!save(local!selectedsubPol, null) }) error is coming when i am un-selecting the default selected values . can somebody help me on this

Hi Team, I have a requirement to extract/read bar code from the user uploaded pdf file as part of the IDP process. Can you please suggest the possible solution to achieve this?

I have the above expression rule, and when I call it in my interface I am getting the value of [ID:7]. Is there a way to only return the integer value of 7? I'm sure this is probably an easy fix, I'm just very new to this

Hi,Could someone help me understand the concept and solve my below problem? I have a Two tables 1. VehicleTypesFieldId   category1    Cars2    Buses3   Trains 2nd table SubVehicleTypes SubID Id SubCategory1         1     Sedan2         1     Suv3         2     Luxury4         2     Semi luxury5         3     Ac Trains6         3     Non Ac Trains Requirements:1. Drop Down 1 will have data from Table 12. Drop Down 2 will have data from Table 2 I want to display the selected field in 2nd dropdown with the list like Actually i want this

Hi, I am tasked to do a timesheet POC, I am asking the user to select the date, and I will using the weeknum function to find out the week number, after that will add into the database and wait for supervisor approval.  How to verify the week number is exist in the database record before the user submits the form.  Please kindly assist me thank you 

Hi Team, We are using "googleHistogramChartField"  by "Appcino Technologies" the requirement is  Is it possible to color the boxes (of reach composition) based on the overall risk (green, yellow, red) I was unable to find any setting for the same  https://developers.google.com/chart/interactive/docs/gallery/histogram can anyone suggest that how we can implement histogram in Appian without 3rd party plugin Regards Bihitak

Hi Team! Good morning! Need your help/suggestion on the below: I have got a requirement like the check box should appear on the UI with all possible values as selected(ticked) by default, then the user unselects the option that they does not require and submit it. I have tried the below snippet, where in UI its appearing with all the values checked, but upon unchecking the box, it gets selected again. Can you please help me or let me know if there is any possibility to achieve this functionality ? Code snippet: a!localVariables ( local!Checklist:{"A","B","C"}, a!checkboxField( label:"Checkbox testing", choiceLabels: local!Checklist, choiceValues: local!Checklist, value:local!Checklist, saveinto: a!save(local!checked, save!value) ) ) Expected result: 1. At first ,all the options get checked by default 2. The user can able to unselect one or more of the option and submit it  Actual result: But after unselection, the values gets chec

Hello all. I am following the Appian online course and making a side project to practice. In the query data section for querying VehiclesAddedThisMonth it shows us how to query and filter a vehicle that was added this month. The problem I am having is that the field I am using is datetime and not date. Error: Expression evaluation error at function a!queryRecordType: Cannot apply operator [EQUALS] to field [createdOn] when comparing to value [TypedValue[it=1,v=10]]. Code: a!queryRecordType( recordType: 'recordType!{7dc09094-e6de-418e-855a-35ab22892fc7}BB Product', filters: a!queryFilter( field: 'recordType!{7dc09094-e6de-418e-855a-35ab22892fc7}BB Product.fields.{34fab307-ea54-4ea9-a01b-40a0706f32c7}createdOn', operator: "=", value: month(now()) ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100 ) ).data Seems like the issue is that the operator cannot compare the month function to my datetime field however it is ok if the month compare to

Hi All, For my requirement , I have to create a stored procedure in database which executes a sql query. And I have to execute that store procedure in appian process model and have to save that output in  process variable to proceed further. While creating the stored procedure in Database ,I am facing some difficulties. If I just run the sql query in DB by passing value for input(task_id = 261),then it gives me output of 16 rows with 22 columns , I want that to be saved as output in my process variable as a result. For this query I written below code to create store proc, create or replace procedure test(i_task_id in NUMBER)ASBEGINselect column1,column2,column3,.... from xyz where task_id = i_task_id;END; But this shows me the error like PLS-00428: an INTO clause is expected in this SELECT statement. Can anyone kindly help me to solve this.Thanks in Advance.

Hello! I would like to prevent users from using emojis in comments, however I have absolutely no idea how to accomplish that. Have you got any advice, folks?

How to make a card layout collapsable?

Getting this error how can i resolve it. I have given 2 different CDTs  Thanks In Advance

Hey everyone! I'm working on an email template which I'll be using inside a Send email node and I have to add a logo as a signature. Because of company requirements, I can't use href HTML attributes and I already tried using inline-css, svgs and base64 versions but those are not viable options due to email provider incompatibility. So the only option left I could think of was the following: Storing the logo inside the Document Folder in Appian. Creating a constant pointing to the logo file which is a PNG. Inside the process model I create a Document type process variable. That pv as a value has the file constant. Inside the Send email node I went to the Setup window an inside the Message body I inserted the logo pv as an expression.   But the received email doesn't show the image, it only shows the following message.  Do you know if there's a way to send files that are stored in Appian through the send email node? Also, attache

Hello,  I am trying to design an interface when a technician clicks on "Accept Ownership" will trigger a process where we capture the user who clicked on the link and update the database. Below is part the interface code for accept ownership. a!sideBySideItem( item: a!richTextDisplayField( label: "Technician Name: ", labelPosition: "ADJACENT", value: { if( a!isNotNullOrEmpty(local!technicianInfo['recordType!{668f9fee-8c8c-4ec0-8719-8fe261ecebe6}CG Technician.fields.{28788328-2480-438c-be68-4a5bfccfa974}assignedto']), local!technicianInfo['recordType!{668f9fee-8c8c-4ec0-8719-8fe261ecebe6}CG Technician.fields.{28788328-2480-438c-be68-4a5bfccfa974}assignedto'], a!richTextItem( text: "ACCEPT OWNERSHIP", color: "NEGATIVE",

I have a question, well I have a requirement which we need to extract files from appian from a directory on a server using the Sftp functions, the problem is that when we want to do that function the destination folder does not support SFTP, Well, is there any solution to send files to a folder if it does not support sftp? Thanks!! 

Hello, I want an event to happen (send email) after submitting a user interface (form) only if a certain attribute has been changed. I figured that I would need the old and the new value of this attribute in the process. What would be a good way to achieve this? Thank you in advance

I am retrieving a large JSON document from a web service and need to display this on a set of interfaces.  The JSON has separate sections for different aspects of the data and my plan is to create separate interfaces for each section then add each of these interfaces to a single master interface.  The end user will be directed to this master interface to view all the necessary information from the JSON document.  This data is strictly read-only.  We will have other JSON documents that may allow edits which are then passed to an integration to be saved in a database, and/or to notify other system components of the change. Some of these components are made available to multiple Appian applications which are created by other developers (not involved in the creation of these common components). The question I have is around passing data internally between Appian objects (process model to interface, interface to interface, interface to expression rule, etc).  Should

Hi friends, I got a chance to interact with [mention:115d03e07c2843c691ef69b0951c7286:e9ed411860ed4f2ba0265705b8793d05] on my podcast and she has explained a lot of things related to the Appian Community that should be very useful for all my fellow community contributors. The discussion includes topics like -  The solution to spams in the community Big plans with the Appian community  And the upcoming problem with the Appian World 2023 Live build challenge. Find it here - https://www.youtube.com/watch?v=PDiFsvfYWWY

Hi All, I need to extract the process completion date of process instances  which has been archived. Is there any way that I can extract the archival processes in report. Regards, Vikram Kumar Singh

Hi, There is an issue i am facing with query databse smart service, Where i am executing a stored procedure which fetches data from multiple tables and insert same data to a table. - It works if i execute the stored proc with same parameters by SSMS(SQL Server Management Studio) - By Query Database Smart Service it sometimes gives me error -  The amount of time allocated for the completion of an unattended activity was insufficient to allow the activity to complete. attached screenshot for reference Thanks 

Hi All,  I am working on a use case where i need to first convert CSV to excel then import converted excel with extra column to a staging table.  Reason to use import excel to database intend of directly using csv to database is i need to dynamically add process instance id in staging table. I didn't find any option to achieve same in CSV to Database.  CSV to excel is working fine. I am able to generate XLSX file and passing it to import excel to database. My process is getting completed successfully but i don't see data in staging table.  I tried converting csv to xlsx in my local machine and used locally converted xlsx in process model, it worked but same when i am trying to achieve from CSV to excel smart service generated excel, data is not getting imported. I don't have auto generated column in my XLSX file. Please advice what can be done resolve this issue.  Thanks in advance for your help. 

Hello Community, I have an interface that displays two types of data coming from two methods that delivers the json values. If this is an individual I have built out a CDT that ties into the method "individualResult".  If it's a group, I will have to tie into the "groupResult" method.   The properties are the same, but the methods are different.  I'm wondering if anyone has a recommendation as to how to build this out? Let me know if more information is required. Thank you.