Foundation

Hi, A new vulnerability, known as Spring4Shell, has been notified. This vulnerability, under revision, affects applications that use JDK v9 or above that run Apache Tomcat as the Servlet Container in a WAR package and use dependencies of the spring-webmvc or spring-webflux from the Spring Framework. This vulnerability is being tracked under CVE-2022-22965. Please could inform us it Appian or any of its modules, development, plugins  etc, could be affected by this vulnerability so far known? Best regards, Jesus Salazar

I have four sub processes which are going in AND gateway as input but when control comes to And gateway iit s stuck?

Hi,  I am using a barcode scanner to read an asset and display its details. This part is working fine but I want to clear the existing entry in the barcode field for subsequent barcode scans.  How can I make it work? Thanks  a!barcodeField( label: "", labelPosition: "ABOVE", instructions: "Scan the QR Code of the Asset", acceptedTypes: "QRCODE", value: local!asset.partId, saveInto: local!asset.partId, refreshAfter: "KEYPRESS", validations: {} ),

i'm testing a very  inconsistent  database from an integration   and i'm trying  to get a especific fields if it is there but  the thing is that the  end limiter could be different in too many ways   and this throws me an error that broke my program i tried to many times of not breaking  it  like using index() but  nothing helps  also i tried to   use another function to obtain the values like  the func wherecontains() as a starindex   whitin a mid() function but i didn't fiind the way  of making it work

Hi, I am getting "Missing Keyword Syntax" icon besides my expression rule. There is nothing wrong in calling my expression rule. It is expecting 2 inputs and I am passing.  Not sure how to resolve this. Any recommendations please.

I'm trying to think my way through a problem. What I need is, given a list of groups, I want to see a list of users that are members of all of those groups. The existing tools almost, but not quite do what I need.  groupMembers() will give me the members of a single group, so I thought maybe if I got the members of each group and got the union() of them, that would solve my problem, but union only takes 2 lists and looping through with foreach  (I do so wish there were other types of loops!) would mean somehow getting the union of each member of the list, then unioning those results until I get down to just one list, but that sounds like a pain to code and probably not terribly efficient.  isMemberOfGroups() is nice in that I can take a user and see if they are a member of all of a list of groups, but then I have to loop through basically all users (or at least all users in some initial group) and ultimately I am not sure how many users there could be or whether the

Hi All, I have user interface with a read only grid and a button called "ASSIGN" to each row. When the user clicks on any of the button "ASSIGN" then for the respective record I have to update few columns again the selected database record. When I try to use a process model with a "Write to Data Store Entity" then it is making NULL to all of other column value except which I have try to pass. How can I update the specific column value when the user clicks on the "ASSIGN" button without touching all other column/field values in the database.

I have used query databse service in my process model. Here I wrote this query to update particular fields in database table. I searched on google and i found that active class parameter should be used in query to update database table.  I have made parameter like this and i used these parameters in my above query using ac! . But when i run this model it doesn't move ahead from this stage eventhough there is no error on this stage.  Is my configuration proper?

Hi all i have button layout and i am adding an additional button, with this one, when clicked, the button should go to external website, per say google.com. but a!buttonwidget doesn't have a link field. I found a workaround but that creates a linkfield that opens up once the button is click, the user than has to click the linkfield. but this is outside my acceptance criteria. once the button is clicked, it should go directly to the external website. Any ideas? Thanks.

I was looking for a function that converts standard unix millis to a timestamp. I came across datevalue() but that is based on an Appian epoch of 1/1/2035 instead of 1/1/1970. Short of figuring out the number of milliseconds between those two dates and subtracting the difference, is there some other way to get that time stamp?  Also, while on the subject, why did Appian choose to base their epoch on some time in the future? 

In my process i have two reasons not to put my start interface in the properties in (process start from): first because i have to check condition before start the interface second because the cycle contains loop and i can't loop to the start node  The Process Model works well in the debugging but it can't be added to site or initiated from Action button

is making reports using stored procedures is good practice or using expression rule ?? which is best and why?

Hi, I am using 'Save draft' functionality on a User task. The user task interface has an editable grid, containing file upload control in each row. The row can be dynamically added or deleted (using the X icon implemented in the top right column - dynamicLink). As explained in https://community.appian.com/support/w/kb/802/kb-1480-unable-to-save-changes-on-a-sail-form-if-an-file-upload-component-is-present-with-uploaded-files 'Save Draft' functionality doesn't work with files temporary uploaded to the form and I have to live without it [emoticon:c4563cd7d5574777a71c318021cbbcc8] However, I have a problem if users uploads a file in a grid row and deletes the row (clearing the grid row item in a grid data source and clearing the save target of the fileupload component contained in the grid row). I am not able to clear the inactive temporary saved file from the memory and Appian keeps preventing the Save draft as the fileupload is still there, although fileu

Hi, My requirement is to, Enable the particular row( Remarks, start and end date) columns for just the selected grid row item(goal) . I am storing just the index of the selected items in the local variable. On click of the save button only they get saved to a rule input. so while the user chooses a particular goal, the corresponding remarks and start and end date should be enabled else disabled. attaching the snapshot and part of the code for reference. Please help. Thank you a!localVariables( local!tabs: { "Functional goals", "Job Knowledge Goals", "Productivity Goals", "Review" }, local!isselected, local!activeTab: 1, local!FunctionalGoals: a!forEach( items: rule!MOB_fetchFunctionalGoals(), expression: { goal: fv!item.subtype, description: fv!item.description } ), local!selectedFunctionalGoals: tointeger({}), local!JobKnowledgeGoals: a!forEach( items: rule!MOB_fetchJobKnowledgeGoals(), expression: { goal: fv!item.s

Hi Team, We have a requirement to get files from external system along with some input parameters to our process model via a web api. The web api which starts a process would upload the file to the target folder and write/update data in respective appian DB tables. How can we achieve this? Request format :  document - type (document/file) id - type int name - type text etc This request can either be in form or json format. Appian version used is 21.1

Hi Folks, I am new to Appian (Had a quite bit of experience with BPM tools). I wanted to know if Appian has the capability to read and parse data from excel files. I am using Appian community edition and  I did my fair share of research and haven't seen any function or utility to read any excel files. Can anyone please help me.

how to write validation in date field so user cant select any date from past?

Hello!Apologies if this has already been answered but i am attempting to capture the current user name, date and time when they open an interface and then record this for later.So i have:loggedInUser()  - which with no other details gives me the current user(great) now() - which gives me the current time and dateI am unsure of how to tie this all together I am guessing if I use a process model I can call a rule to get this information but then I need to add this to a record type and this process would need to be fired on open of the interface?? I'm just lost right now! Sorry i'm a bit lost any help would be greatly apricated.Thank you! 

So I have a CDT with a bunch of fields in it. One of the fields is a category, while the other is string. That string field will be identical throughout a particular category, but may or may not be different in different categories. So for example: local!data: {{category:"round things", string:"bubbles, <otherdata>}, {category:"round things", string:"bubbles, <otherdata>}, {category:"soapy things", string:"bubbles, <otherdata>}, {category:"hard things", string:"rocks, <otherdata>}} I'd like to get the union of categories for that set, but instead of the output being the categories, it is the strings.  so something like union(local!data.category, local!data.category) and have the output be: {"bubbles, "bubbles", "rocks"} instead of {"round things", "soapy things", "hard things"} I hope the idea is clear?

Hi All, I have a use case where I need to convert Date and time based on user time zone. I have a date and time component, and if user of timezone CDT selects date and time as "4/1/2022 11:46 AM CDT" and submits the case. If another user of time zone IST logs in then they should be able to see the date and time value as "4/1/2022 10:16 PM IST" (whatever the usertime zone is). Based on user time zone date and time value needs to be changed in UI. I have tried with todatetime(), gmt() and usertimezone() functions but none of them works. Please provide your suggestions. Thanks

Hi, the issue is batch size in the paging.. count[no of rows] is miss matching.. when i give the batch size =-1 then count[no of rows] will match to db data  when i give the batch size =10 or 1 or 20 or 50 whatever it will miss match the count[no of rows] from db to UI  why this will happen! what is the exact issue? why batch size is giving issue? can anyone help me with this 

Hi all - I'm having trouble with the User Picker field to populate a rule input with a specific user.  I'm able to search and select a user. it shows for a split second then goes blank again.  When run in Design Mode, it does populate my rI! field, but at runtime, just shows then goes away. What am I missing?

Hi Team I have a requirement where I need to generate different update query statements for different tables depending on some conditions in a  process model.Do we have any feature to implement this? I do not want to use a XOR gate and create different nodes from XOR condition as the query statements may be huge.Or if we can generate the query statement in a Script Task and directly call the query to update the tables in the process model.We use Appian version 21.1 Thank you!!

Hi Appian Team, We have a use case where Appian API integrated with SAP , and  the SAP system will input base 64 encoded strings for pdf, we have to read the same from the input variables and convert the same to PDF. Can anyone help us to implement the  same if we anyone have already implemented or have knowledge about this? thanks Sunu Sam

in a simple process that consists of two steps first : student upload image or pdf of his certification second : secretary review document  My Question : how to connect the image component in the secretary  interface to the uploaded document by student ? p.s in the student form the uploaed document is saved a table of Document Type