General

Hi, I want to extract only the email addresses from text string. this is the text:        "Bob: Bob@abc, Karen: Karen@cde, Sam: Sam@def"  expected output: "Bob@abc,Karen@cde,Sam@def"        "Bob: Bob@abc, Karen: Karen@cde, Sam:Sam@def" output: "Bob@abc,Karen@cde,Sam@def" or         "Bob: Bob@abc, Karen: Karen@cde,Sam@def" output: " Bob@abc,Karen@cde,Sam@def" or         "Bob Karen: Karen@cde, Sam: Sam@def" Output: "Karen@cde,Sam@def" Thanks,

We received the below notification when trying to debug a view, we were not able to export or anything with this error up. The error occured in our UAT environment and this view hasn't been changed in months, all other environments remained unchanged: I cannot find a reason why this view would fail in only this environment, i have checked the tables and they have also not been changed collation type. Any thoughts much appreciated? 

Hi guys, I'm trying to import a site object and I'm getting the following error in the import-log: Problems (1):site 5139d5ff-e29d-4874-912c-6d56ffd81d7b 3 "siteName": An error occurred while updating site [id=3 uuid=5139d5ff-e29d-4874-912c-6d56ffd81d7b]: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update (APNX-1-4071-008) In the system logs I can see this:  2021-08-19 13:14:28,076 [ajp-nio-0.0.0.0-8009-exec-9] ERROR org.hibernate.util.JDBCExceptionReporter - (conn=6611215) Duplicate entry 'siteName' for key 'site_urlstub_uc' Any ideas how to resolve this? We were able to deploy the object to all our other environments without any issues. Thanks.

   When i use following    caladddays(today(),3)     For example today is 8/19/2021 then if i execute above function then it gives me output as 8/24/2021.    It should give as 8/22/2021.

I want to display validation on editable grid when user will make the value as null without clicking on any button.Is that possible?

Hi, I have below query: Suppose, We are having two database tables : Table 1 and Table 2 And having column with same name and same type of values in both the tables: column 1 (Table 1) and column 2 (Table 2) We have to match the values of column 1 with column 2 and if same value does not exist in column 2, we need to insert new row in table 2 with that value. We have to create this functionality from scratch. We are just having two table with data. So I can't provide any code here. Please help me to understand how can we achieve this .

i was trying to create  workflow library in the appian rpa, i was getting below error. >> Could not transfer artifact com.novayre.jidoka.module:jidoka-client-api:jar:7.9.0 from/to jidoka (https://****.appian.community/rpa/repo/): Transfer failed for https://jxip.appian.community/rpa/repo/com/novayre/jidoka/module/jidoka-client-api/7.9.0/jidoka-client-api-7.9.0.jar 400 setting.xml pom.xml

In drop down  choice labels and choice value ..can we display value based on if conditions.. I need to display value in drop down based on the product availability.. And I have around 10 products Can someone help with codes

I have a requirement to show the default time for eg 12:00 Am in the date-time component when the page gets loaded. Date should be blank .

Good Moring ! AFAIK we cann't trace the historical groups of a user but wanted to check with larger audience if there is any way to do so. Ex.  User "A" belongs to group "X", "Y" and "Z" on 8/1/2021. On 8/13, someone changed the group of user "A" to "L", "M", "Z". In this scenario i wanted to pull the past groups of user "A". TIA, Ajay

what happens if i cancel the exam? will i get full amount what i have paid??

Hello! I am using docx dynamic plug in and when I was passing white spaces it was throwing errors, so I did some research and replaced all the spaces with " " but now I am getting this error The entity "nbsp" was referenced, but not declared. Can anyone guide me please ? Thanks 

Hi All, I am starting a process from a report dashboard and I have a requirement to refresh my dashboard based on process result. But while using start process link I am not able to refresh my dashboard. Any suggestions/Solution would be really appreciated. Thanks in advance

The documentation in the frequently asked questions for the certification exams does not say what a passing score is for the exam.  It also says that there will be matching and other types of questions other than multiple choice, but none of them are available on the practice exam.  Is the practice exam old?  What is the passing score?  Can we expect updates to the exam practice test any time soon?  I don't want to pay the fee for a test I haven't been able to practice for.

Hi Folks, I have a use case, say I have editable grid with 2 columns column 1 and column 2, user should see existing data in read-only format and when ever user clicks on add new row link in the grid, new row should be appended to existing list and editable. Consider I have below table structure is similar to my use case Column 1 Column 2 Check box Key1 Value1 Key1 Value2 Key1 Value3 Key2 Value4 Key3 Value5 Key4 Value6 In the above table Key1 has there different values, user should have a option to decide which value should be returned out/ mapped to that key1, to achieve this I have enabled section option in editable gird. When I do check on one row to map default value for key1, all the rows were selecting by default though only one should have been selected. Can anyone suggest me how to achieve selection in editable grid?What would be the reason for selecting all rows instead of only one row in above scenario? Thanks in advance [emoticon:c4563c

Team, We have list of users in array , we want to know there direct group names which they belongs too. Regards, Gaurav

Hi all, In our current project, we are discussing the use of a wizard-style form versus a single interface form; however, the form will need to support offline functionality.  Will we be able to use a wizard-style form offline, where each navigation action saves the form's data or is that too far outside of the current offline functionality? Thank you, Jacob Benjamin

Hi All, In recent day, i encounter a weird issue. I am in a stage of Go-Live in my project. From couple of day back my credentials, has stopped working. I am not able to login in Dev and Test evnironment. whenever i try to login i get "The username/password entered is invalid. Usernames and passwords are case sensitive.". I reset my password from Admin console  and try to login with the temperory password i get the same message ""The username/password entered is invalid. Usernames and passwords are case sensitive.". I did forget password and got password reset link in my email, when i click that it say "Your Link Has Expired". I created new account but still same result with that. Kindly help me here.

Hi guys, been facing this issue on our DEV environment for a couple of weeks now. When trying to reset the passwords for certain accounts via the admin console we're getting the following error:  An Error Has Occurred Expression evaluation error [evaluation ID = 89ca3:c4826]: An error occurred while attempting to store into the following variables: [local!passwordResetWriter]. Details: [[local!passwordResetWriter:The user [test.account] does not have sufficient privileges to perform the requested action because they are not in any role.]] When trying to reset the password via the "Forgot Password" link, we're seeing the following: ERROR com.appiancorp.security.auth.forgotpassword.ForgotPasswordRequestServlet - Unexpected exception when processing password reset request. com.appiancorp.security.authz.AuthorizationException: The user [test.account] does not have sufficient privileges to perform the requested action because they are not in any role. (APNX-1-4188-001

I'm trying to load my developer course and the page is extremely slow. It wouldn't load. Anyone else experiencing a similar issue?  All other webpages load perfectly fine, including this discussion forum as well. 

Hi, I have to pass 10 digit number in the rule input, how to replace first 5 digit number with * and remaining 5 digit will same ?

Hi, New to Appian! I have a query filter rule: a!queryEntity( entity: cons!PINBuddy_DSE_Wizard, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "particpaitUpdateCutOffDate", operator: "

I have 2 page/interface say A,B,C,D. Each page has 3 items. Am able to store the value of items in CDT(Array). My doubt is Suppose I have selected 2 items from each page and want to display the value of items in page 3. How to achieve it. Thanks.

Hi, I have this code where if the index points are not returned, it should return the default value. But instead it returns empty data. How do I make sure that the default value is returned a!localVariables( local!address1: {{id:1},{id:2}}, local!mdmAddress:{{id:5,name:"abc"},{id:3,name:"pqr"}}, index(local!mdmAddress, wherecontains(local!address1.id,local!mdmAddress.id),"Hello" ) )

We need a simple way to migrate a large number of documents from our Appian-based APS application to a non-Appian application. To do so, we need a way to attach metadata to the physical files that reside on the application server, under accdocs. We can obtain the following information regarding a document in Appian:    Document Name: sf1449    Document ID: 59834    File Type: TXT    Parent Folder: All Objects > APS Community > Contract Documents > Contract CORFD-21-C-0001 > Attachments    Parent Knowledge Center: All Objects > APS Community > Contract Documents > Contract CORFD-21-C-0001    Parent Knowledge Center ID: 59680 Using the Parent Knowledge Center ID, 59680, we can find the folder on the application server where the document is stored.    Folder on Application Server: /app/APS/_admin/accdocs1/59680 By going to the application server and visually inspecting and/or downloading a