Foundation

I am trying to export data from an editable grid in an interface to a PDF file. The only problem is that the data that I have managed to get exported does not appear displayed with each field being displayed in different rows as it was supposed to. It is displaying as showed below: I have tried using "char(10)" in between lines but it has not worked. Below, an example of the code that I have implemented in order to do so: Could you please help me understanding how to get something like this: N; N; N; (...) instead of something like this: N; N; N; (...)??? Thank you for your attention.

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?

Hello All, We have an Angular page where we are displaying Appian task list.  We have provided a run button in one of the HTML table's column , which simply run Appian task in a new window/tab. I would like to know if there is a way to send some message back to Angular page after user complete the task/ or click submit button. I would like to get the updated task list automatically (refresh the task list section) once user finish any Appian task. Please share your thoughts. Thanks, Gaurav

Hi, I'm following the Appian dev course and one of the steps require me to Generate an Interface from the "Views" section of a record type. However, that button isn't showing up on my workspace. I tried to create an interface manually but couldn't get around to doing it since I am new to Appian.  "GENERATE INTERFACE" not showing up. Appreciate any help I can get on this one. Cheers!

I have a ref CDT and from the ref CDT i am extracting id and name values using expression rule and using this expression rule as a local variable in the interface (i,e local!ammenityTypeList). Now for choice labels i used the name and for choice labels i used id . For storing these values i am using another CDT which consists of an integer field which is a foreign key. here my requirement is : 1) when I select the values it's displaying the numbers when it is in read-only format . But I want it to be names! . 2) I should have the option to select my own values but instead, it is selecting all and taking all of the values.  These are my requirements , can anyone suggest how to solve them.

Hi All, Could you pls any one explain MNI and when do we use MNI ....what is the Purpose of MNI Thanks in Advance!

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 .

Why process model does not inherit security from their parent folder? Regards, Priyanka

question in the title. Thank you.

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 

Hello Everyone, Please let me know whether any one implemented adding dynamic columns in paging grid? Actual query outputStudentName Age City StudentA        15   LosAngeles StudentB        16   Newyork StudentC        17    Austin Below is my requirement to display the data in vertical grid formatRequirement is below(Kind of vertical grids). StudentName      StudentA   StudentB StudentCAge                       15           16           17City                      LosAngeles Newyork Austin 1)Question is number of students may be varying based on input conditions. So please let me know whethercan added dynamic columns in paging grid?2) or did any one implemented vertical grid? Thanks in advance

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

We have a variety of tools to force data refreshes on interfaces on local variable changes. For example, this is easy to do using a!refreshVariable and I've even found ways to force read-only grids based on record data to refresh using little hacks like this in the filter logic: a!queryFilter( field: <field reference here>, operator: if(local!updateMeToRefresh,"=","="), value: ri!id ) However, even this technique doesn't seem to work in charts such as a!barChartField() where a!recordData() is used as the data source. I have an interface where I'm showing some charts based on record data and I'd like the user to be able to refresh that data on demand (there are other components in the interface that are used to update the data behind the chart) without having to reload the page entirely. I want to use record data here, but I may have to change to local variables unless there is a way to make this work. Looking forward to your ideas!

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.

How to UnArchive any Archive Process? Could you pls let me the steps for that. Thanks in Advance!

Hi, I want the Approval form as Read Only except the radio button for approve or reject purpose and no cancel button. I want different logic other than given in  https://docs.appian.com/suite/help/21.2/SAIL_Tutorial.html. I do not want to pass a step input and then make it read only. Could someone please suggest? Thanks Faisal

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