General

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'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

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

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? 

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

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.

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 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

I am trying to add an existing attachment dynamically to the "Send Email" task. These attachments were previously uploaded to the application and the attachment name and document are stored in a table. I have added documents previously that were static and had a constant name. Thank you for the comments.

Hi, is their any other alternative to between operator? bcz am querying data from db.. giving different o/p in UI same query i have used to query the data from UI so  a!queryFilter( field: "expiredDays_int", operator:"between", value: {rule!CR_CMU_DSC_getExpiredDaysInSecurityDocumentation( selectedItemType_txt: 1 ).startIndex_int, rule!CR_CMU_DSC_getExpiredDaysInSecurityDocumentation( selectedItemType_txt: 31 ).endIndex_int

Hi, I am working on a process model which has a Create New User smart service and in that smart service, there is an option to send Account creation email which when turned on sends the user an email with Temporary credentials with predefined content. My current requirement is to change the content of the email. Is there a way to change the content present in Body of the auto generated Temporary Credentials email sent from Appian?

Can someone explain what's going on here?  If I try to get the output for the following string:  fn!char(65020) & " 21,245.00" the result I get is:  ﷼ 21,245.00 however if I try to get the output for the following: fn!char(65020) & "ABCD" the result I get is:  ﷼ABCD Can someone explain to me why it's essentially the same expression, but the symbol is on the right with the number and on the left with the letters?

Hello All, I have an XML generated and based on a valid XML tag I need to display the data. «[#if doc.xml.A1 == "true"]» «@before-row[#list doc.xml.good.A2 as l]«${1}» «@after-row[/#list]» «[#else]» «@before-row[#list doc.xml.good.A3 as l]»«${1}» «@after-row[/#list]» «[/#if]» In my case the If condition is not working when called from DOCX template which is called from a DOCX From Dynamic Template through a process. I need to should 2 rows, but in the document it always shows 4 rows. Can anyone help to check conditional logic is correct? Thanks & Regards Girish

Hi, i have two dropdown field, when i select one some values related to that dropdown will be selected in next dropdown.. but after selecting values in both the dropdown when i try to change the value in first dropdown it throwing the error.. actually it has to erase the value in second dropdown and show the values to select  below i have attached the code and the UI this is the UI for ex: when i select stand-by lc and related detail i have to select after selecting the detail if i try to change the collateral type then it is giving error  when i try to change the collateral type then detail data need to erase how can i achieve this   a!dropdownField( /*label:"Collateral Type"*/ placeholderLabel: cons!CR_APP_TXT_PLACEHOLDER_VALUE, choiceLabels: touniformstring( rule!APN_distinct( index( ri!crREFCollateral_cdt, "collateralDescription_tx

Need to use "Text Doc From Template Smart Service" for exporting more than 300 columns data from a table. Can anyone help me out how to configure this smart service and use it in PM which will give data in csv format or excel format.

Hi All,     I want to write the logic for the below requirement  For example: ------------------ My Input is 1  Output should be : {2,3,4,5}    can  anyone share the logic  Thanks in Advance!

Hi, I created a simple sample application with 2 connected systems one for PostgreSQL DB an one for Http Connected system, both connected system are working fine on development environment. I have exported application package and import customization file. I have updated the Import customization file and tried to import application (with import customization file) on different environment, during inspect i found below errors I have verified import customization file that parameters are present. I am not able to understand why this error is coming during import?

Hi, I am facing an Issue, When we maximize the browser zoom for the site page then the local variable are refreshing and getting null. Can anyone please help me on this Issue? Thanks In advance

Hi, Is there any way that   Appian can identify content  from email. Thank You, Hema

Good Day!Goal: Using Get API response the html code stored in my DB.Issue:I'm having this issue on my API response on my DB there is no "/' but on my API response it display "/'.pic for details.API Response:

smart services are there to create a user account and adding them to the groups also, Because I want All users  should be  able to sign up (if he/she is a new user(this candidate added to user group dynamically)), this  app should be mobile friendly as well, that should available for wide number of civil users, So please let me know possibilities available to achive this in appian, Pro's & Con's, can also let me know if their is any best suited technology to achieve this 

Hi Everyone, I am getting this error while I am trying to fetch the data. A user picker component [label="User Name"] has an invalid value for "value". All users must be valid and visible to the viewer. Please help me on this.