General

Hello, I recently found out about 'Create Expression Rule Smart service' and 'Update Expression Rule Smart Service'? I am no sure these smart services provide what I need. Is there any guidance that I could follow to use these smart services? Thank you.

Hi Everyone, I have the requirement so that users can upload excel sheet to the application and save into database table and if the records already exists in table then it will leave that duplicate record. meaning, duplicate records from the sheet should not be uploaded to the database table. Please suggest me how to get this done. Thank you, Shubham

I have a requirement, i have a dropdown filed where if i select a particular group (lets say technical group) then the mail should be triggerd only for that group. Note : im fetching the dropdown values from ref table

I have to upload data(rows) from excel sheet to Db  and maximum number to rows in excel sheet can be 100 rows . What is the best  approach to get this?

Hi I need to start different process models in a WEB API based on the path segment. One of the process models would upload a document from an external system.A web api is created using "upload document" template. This web api is called in an integration where the document is passed as a part of "multipart/form-data" and other parameters are passed as query parameters and headers. I tried calling this integration in parent web api, I get Internal Server Error. If I try calling upload document code in the parent web api also I get the same error. How can we resolve this? Appian version : 21.1

Hello everyone, for a few days I have a complication, I don't know how to remove the (; ) after each of the array I have a rule that is responsible for extracting information and I build an array for each element, at the end I have an array of arrays that I print in a plain text document. when I run my rule it returns something like this:   0WF20220210630 14 2/14/2022 22/04/20225678 n453049 MXP 1.00000020220445678 P 11556020122010081089 944,414.101234121212121231089 944,414.1000000000022023/06/2020; 0WF20220210631 14 2/22/2022 22/04/2022234567 n525487 MXP 1.000000202204ERTYUI P 11556020122010081089 777,777.801234121212121231089 777,777.8000000003042005/10/2020; 0WF20220210631

can somebody explain this  Combin(64,2) returns 2016 

Hi Team, I have deployed the data store and CDT to higher environment and able to view that " A modified draft version " message is available on the top. But when trying to click on "Modified Draft" link to verify and publish the datastore,the appian tool is not navigating to the modified version. This is happening for us in all the environments and hence blocked with deployments . Regards, Divya Jyostna Dasari

Hello folks, In Tempo, when adding comments, we can also upload attachments. Is there filter or server settings that will prevent uploads of .exe files?  Thanks in advance.  Best, Mahesh Pillutla

Hello, In which case will use views and stored procedures in Appian ? I know the basics about it but I am not sure when will use stored procedure and views.

Hi, Is it possible to add a link to Microsoft Teams User profile on Appian User Interface. Thanks.

localvariables( max 10 max20 ) has to print 10 to 20  

I have a multi selection checkbox, so if i select any of the options in that checkbox then only that mail has to be sent to a group of users outside appian and also i want to link a record in the mail body can anyone please help how to achive this. Thanks in advance .....

Hi, Is there an Out-of-Box function in Appian to get the list of all groups a user is member of. Actual requirement is to filter the active tasks assigned to a group which the logged in user is member of. User should be able to view an active task if user is member of the group the task is assigned to. Thanks.

I would like to add audit fields to the document type CDT in IDP, when a document is processed not only the extracted data should fill into DB, but I also need to have audit fields to be filled. So, when I was looking into it I am unable to open the interface, saying that this node doesn't allow custom forms When I was trying to configure it from a process model, I was creating a script task and wanted to save data from there, and save the data to DBSo when I Configuring the script task, I am unable to save the data to the particular parameter in the document CDT type, Because the type of the CDT is labelvalue, I need to save the data to the created by a parameter which is in value, so I am unable to do that. This is the error I was getting

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