New to Appian

Hello All, can anyone advise how to get the sql view in record list

Hi All, I am able to see the user which is already selected previously in the pickerFieldUsers, how to hide/prevent the users' which already selected from pickerFieldUsers ? Thank You

Hi All, I am adding and fetching data from database through integration object and displaying it to the interface. First time when add button is clicked it gets displayed on to the interface and when second time I click on add the data gets added to DB but its not refreshing to interface. I have used the refresh variable in the interface as well. Can anyone please help help me.

WHEN I RUN THE PROCESS MODEL I GOT THIS ERROR , HOW CAN I RESOLVE THIS ERROR :.An error occurred while trying to write to the data store [K_EMPLOYEE_DETAILS_DSE].  No values have been written. Details: org.hibernate.exception.ConstraintViolationException: could not execute statement (APNX-1-4208-004) . CAN  ANY ONE PLEASE  TELL ME WHAT IS THE PROBLEM ?

Hi Everyone, I have the requirement to add multiple rows in editable grid and it should have a x icon for each row added before saving to remove that row. Can anyone please help me out. Many Thanks in advance!

Hello, As I am new to Appian and try to evaluate the tool I would like to import some data from excel/ CSV to test drive a couple of ideas. I have found a plug-in that should be helpful in importing data: https://community.appian.com/b/appmarket/posts/excel-tools#. Though when clicking on download it says "This app is available to download for Appian Customers, Partners, and Employees. Please make sure to self-associate from your profile" I assume the free account doesn't make you a customer, though how can I get a sample data set in the platform to test drive. Regards, Wolter

Hello everybody Someone could help me please?? I don't understand about engine, what it it? how it is working  regards

Hi, I have to make a call to SQL Server stored procedure with input parameters and get the return value. I have gone through the below URL for required documentation. docs.appian.com/.../Execute_Stored_Procedure_Smart_Service.html I am using 21.4 version of Appian, but still, I don't see Execute Stored Procedure smart service in my list of smart services. Can someone advise on this please. Thank you

Hi All, Can anyone please help me, How to refresh the columnlayout field inside section layout? Thanks in advance!

hii all, we have a requirement of  uploading a excel file and once user click preview the entire data in the excel should visible in grid for user , and once clicked on submit then the data should store in database  for achieve this we are plane to use a staging table(dummy db) for storing uploaded excel data and showing in grid , once user click submit the data in staging table should move to main database table and need to delete the staging table data , why because if the staging table not cleared the next user data also store and entire data in the staging table will appear in grid  please help with this , guide me  to achieve this. thankyou, Ramesh

Hii Experts, I am trying to create a expression rule to find out the difference in CDT (for Audit log) using CDT Comparison plugin. Could anyone help me out how to create ER for that  Thanks

Hi, I am a new Appian employee and I just wanted to understand how many environments do we usually have in Appian where to deploy our applications? What are their most important features? Are there some best practices to follow in using them? I know there are the development one and quality (or testing) one for building and testing the applications and the production one where the applications run, but is there a link to a more specific documentation of the differences between them? I couldn't find it. Thanks for all the help!

I am trying to aggregate a record type data and display it on UI using a!gridField(). Please help me with it.

if the Locale settings is "English (United Kingdom)" then invalid date format error should display dd/mm/yyyy . Appian is hosted in USA. Calender by default is giving mm/dd/yyyy.

feedback: when you try to create  sub folder and forgot to select the parent folder then there is no options on next screen to go back and select the parent folder. also once the folder gets created and you select that object and go to properties, there also no options to select the parent folder. only options you left with is to delete the folder and create new with parent hierarchy. hope in next release this will be considered as positive feedback and some feature will be provided to select the parent folder.

Hello,this question is connected to this. I have created a related type with a related action that calls a process model; i have a column in the list that start this process model. The record type has this security: <ADMIN user group>: Administrator <ALL USERS>: Viewer The process model has this security: <ADMIN user group>: Administrator <ALL USERS>: Initiator The integration service called by the process model has this security: <ADMIN user group>: Administrator <ALL USERS>: Viewer Please give me some hints.Thanks in advance.Marco

Hi All, I have the requirement to close the task after clicking over the button in interface? Can anyone please help me out?

Hi All, How to get the documents which are uploaded only by the reviewers (list of reviewers uploaded)? Regards, Supriya

On my Appian application website, I have used two record views using a single database table. Now I am using a radio button with the choice value Yes & No. If I select Yes the row should go to another record view if I select No it should be on the same record view on the website. Please suggest to me how to write the conditional statement to achieve the expected result.  a!radioButtonField( label: "Move to NOC Standard Handover", labelPosition: "ABOVE", choiceLabels: {"Yes","No"}, choiceValues: {"Yes","No"}, value:ri!record['recordType!{2eff113d-30b2-4e57-8fa0-e59fe7e0115e}NH Handover.fields.{d6c838a0-cfff-4d11-bff4-e6a26c63564f}standardHandoveritems'], saveInto: ri!record['recordType!{2eff113d-30b2-4e57-8fa0-e59fe7e0115e}NH Handover.fields.{d6c838a0-cfff-4d11-bff4-e6a26c63564f}standardHandoveritems'], required: true, choiceLayout: "COMPACT", validations:{}

I am trying to use record type's export to excel feature for that I need to convert my data which is in list of maps (image below) to record type. Please hep me with it.

Hi, I need to compare two Hebrew names if they are equal. Tried using exact function, regex but it doesn't work as expected. Thanks, Preethi

Hi All, I have two interfaces in which one is embedded to another. Is that possible to pass value from one to another without submitting the form or by just selecting the dropdown value in one interface? Thanks in advance.

Hi, I have an array like this wherecontains(2,{1,25,32,4}) I want to get 25 and 32 out from this. I will just pass 2 to this array as search parameter.

Hi, I have a requirement to upload the documents from knowledge center to external system using webAPI.  For this requirement should I be using get web API or put Web API? Also do we need to use integration object to use webAPI for this requirement? Thanks

 I want to upload the file and save it into the database in integer form. How can I do it?