Community

Hi dear, I have written code like in the picture, I just want to print the max no without using max function.

Hi, I want to execute a Stored Procedure for that I am using a!executeStoredProcedureForQuery() function but I am getting following Error. Also, I tried with ExecuteStoreProcedure smart service but there also giving same error. I am using postgres DB. In Database I am able to execute it, but from Appian end it is giving error. Thanks, Kiran

select * from Table where column1= value1 and column2= value2 and ( column3= value3 or column4 = value4) I need to query above sql command into appian query. How can I write? Can anyone help me with this please.

Hi dear, I have written code like in the picture, I just want to print the max no without using max function.

Like above giving errors, can you please try to help me to overcome this? Thanks in advance.

We have a table that has the primary key as a auto increment called unique_id, the table has a account number that is set as a foreign key to another table. For some reason the program was not checking when account numbers are entered to see if that account number was already used, which will be fixed. The issue is a user entered a new account with a account number already being used. I now need to figure out how to safely remove the account they entered, when I try to run a sql delete statement to remove it I get the error. Is there a save way to delete the record so it is no longer in the table, I am using the primary key unique_id for the record in the where statement to delete it. When the query runs I get this:  Cannot delete or update a parent row: a foreign key constraint fails

How can I resolve following error?

Here, If I give quantity value for 1st row then it is coming to all the rows with the same value. Item, ItemName, Price, are in one Rule input and Quantity, Total are belongs to other Ruleinput.How can I save the Quantity value in their indexes ?

I am trying to display the all the tasks assigned to level one authority in the process report but not being able to display. Any help will be appreciated.

Hi All, I am trying to import CSV file to database, first I am reading the CSV file through rule and mapping the values to CDT. After that I am trying to insert the data into DB, But I am getting below error.  Please provide Solution on this. Thanks, Kiran

Hello, We tried to upgrade to Linux Installer (Includes Hotfix Version 22.2.425)" from version 22.1. But was not successfull with error. (version 22.2.205 was successfull) So, tried to install in new with version 22.2.425. but, also failed with the error message saying "invalid schema". Is some thing wrong with version 22.2.425? Is there anyone who's having the same problem? Thank you.

Hi, I am trying to learn Appian RPA (parse excel file) on macbook as a resource as per the procedure given by Appian at https://academy.appian.com/#/online-courses/57b938d8-8880-4d2c-bf8e-aa5c3e9cb1fd (page 12 of the tutorial).. Background (what works) While using a windows resource and if we mention pv!fileProperties.path in the File Path menu - the BOT works as expected.  Problem Statement (what I need help with) Now since I am using a mac my fileProperties value is looking like [{"name":".DS_Store","path":"/Users/jbanerjee/Desktop/Business Opportunities/.DS_Store","size":6.00390625,"createdAt":1659959223000,"lastModifiedAt":1659959223000,"extension":"DS_Store","type":"FILE"},{"name":"ParseExcelTutorial.xlsx","path":"/Users/jbanerjee/Desktop/Business Opportunities/ParseExcelTutorial.xlsx","size":4.9775390625,"createdAt":1659959185000,"lastModifiedAt":1659959185000,"extension":"xlsx","type":"FILE"}] as you see for some reason 2 values are captured instead of 1. I h

Hi team,  I am having a process model which looks like below. Now, I want a single place or a page where user can interact with the interfaces and flow directly as a normal user do. I don't want that user should come into the process model and then he should click on run process for debugging. How can I do that ? Can anyone please help here o urgent basis ?  Thanks in advance,

I am newer to Appian and in the cloud database in the SQL window trying figure out how to do a Parameter Query.  I need to have the parameters in the query so it can be ran by other people as well on the fly. I have this: SELECT * FROM `accounts` WHERE `state` = :state and `county` = :county and `servcode` = :servcode and `area` = :area How do I add these before the SELECT statement and give them the values? so basically I want to be able to do something like this @state = "IL", @county = "Jackson", @servcode = 2568    etc.... Then the query use those to run Thank you Bill

I have a string that need to convert into an array. E.g: local!name: "shukur", - > {"s","h","u","k","u","r"}How can we add that?

how to delete a entire row in readonly grid?

 in that applicationstatus filter  is ok  and Applied department & application status is not working at a time what we do?

for this template i have downloaded it and made some changes to that but how can i update this template and see the changes  here i can see only cancel and save button 

How can download the certification that I did. I have completed L1. How can I download

My free version of ' My Community Edition Site' is not working from the past 14 days. It always shows the message 'Error Starting'. Can anyone please fix this or know how to fix this up. I need to practice. 

I know this may sound little trivial but I couldn't figure out the logic. I want a button should be enabled before 5 calendar days from the last date of the month to the first 3 calendar days of next month. Example from if it's Aug, then it should enable on 26 Aug and stay enabled until 3 Sept. Any help appreciated.

I have a requirement to generate a document. Which all smart services can I use? Requirement is generate a word document where the document has dynamic table and defined tables. I am not sure about which smart services should I use. can anyone help me with that.

Hello, Is there a possible way to add rownum column in readonly grid? If possible, it would be appreciated if you could attach an example for reference. Thank you.

Hello Everyone,  I can't submit my answer for the specific quiz suddenly prompt an error "Unable to submit assessment". It is already 2hrs. now but nothing changed. Can somebody help me on this issue? Thank you.

first  1)how we will configure Cascading Dropdowns using rule inputs ? next  2)after configuration how we will do in process model level by using smart services in PM? please suggest?