New to Appian

Are there any recommendations, tips, literature available for Sizing the requirements for Appian development ? For other BPM platforms there are sizing sheets (Tool) available .

Hi All I am a new Appian and need some suggestions. Problem Statement: Created Record Type and there is one column i.e. request number which i created clickable link a!linkField( links: { a!recordLink( label: fv!row['recordType!{2774e922-1a67-4b2a-8113-4d7f9649efdb}IMS Invoice.fields.{979355da-81d8-4800-b32a-a9c3de5ae348}requestNumber'], recordType: 'recordType!{2774e922-1a67-4b2a-8113-4d7f9649efdb}IMS Invoice', identifier: fv!identifier ) }) When I click on the above link, a summary page will open. So I want this link to be dynamic like based on the condition, I have one column i.e. status. So when the status will be drafted different interface or page will open and when the status is submitted summary page will open Need help Thanks

Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error: An error occurred while executing a smart service: An error occurred while trying to write to the entity "EO_EmployeeData" [id=9e48e7c6-a034-4954-98db-450e8558d1bf@4713, type=EO_EmployeeData (id=4046)] (data store: EO Data Store). Details: org.hibernate.exception.GenericJDBCException: could not insert: [EOEmployeeDataDT5986]: java.sql.SQLTransientConnectionException: (conn=42215) Field 'a_id' doesn't have a default value: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Field 'a_id' doesn't have a default value: java.sql.SQLException: Field 'a_id' doesn't have a default value Data: TypedValue[it=4046,v={<null>,DEVESH KUMAR,2022-07-26,GZB,up,IND,,2022-08-02,2022-08-11,2022,1,1,<null>,<null>,}] This error will not be displayed to the user viewing this form. Click here to dismiss the error messa

Hi! Just wanna ask how can I make the text file only accept values that are in this format 1.1.1 1.2.2 etc

How do I update a process variable in  process model instance via WebAPI ?  ============================================================ The use case is an external system which triggers an onboarding process.  It calls a webAPI which starts an onboarding process. An email is being sent to the customer for email verification. The process waits for the code to be entered on the external system form. Once entered on the external system form, it should be  posted to the running process instance  to resume execution. So I need a way for the external system to post the code to the  previously initiated process.

Hallo Community, Goal: Display response of Rest API in Gridview and Dropdown. I have a working integration (via a public API) providing car manufacturers. The data is retrieved by Appian and consists of ID, Brand, Country. Now I like to simpy display the data in a DropDown and a read-only Gridview. I went through the Online-Course "Integrations" for some help  but ultimately I cannot get this to work. For GridView:     data: rule!BP_GetCarManufacturers().result.body (the Integration object) For each Column, I tried different approaches: * value: fw!row.ID etc. * value: {index(rule!BP_GetCarManufacturers().result.body, "Country", {} )} Same for Dropdown, I also tried out different flavours of index(), but the best I get is the whole API response in one Choicevalue. Any help/hint/guidance is appreciated! Dan Edit I understand that it might not  be best practice to use an API call directly in some UI, it's really about a PoC. Stating this,

I am exporting data from DB and storing into excel , in Export DSE to Excel smart service i need to add filters which will only export data for last month . How can i add this filtter to it . One Stored Procedure need to create which will delete the dats for last month after fetching from DB . How to create this for 2 different entities which will delete data for last month.

Hi,  How can we convert the datetime from GMT to PST time zone.

Hi All,  Anyone can help me, how can we create bots in Appian.

Can anyone please check this error?

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?