New to Appian

Hi!I create the interface as advised in the exercise, however, after I add the image component, the error message that displays does not disappear after I test the values. I type the following expression: : rule!AX_GetVehicleByID(1), I click Set as Default Test Values, then click Test Interface. After all this the error message is still there and prevents me from moving forward. Please advise! Thank you Rida 

I have two record types, what I am trying to achieve is, when I click on the Orderid (below) from record type one,    the second record should be displayed with only row where OrderId is 2345.   I have been able to display all the data (above image) from second record type but not the one which order Id I selected. Please help me with it.

Hi! I have an issue with refreshing a page. I've got a read-only grid and a delete button. After I choose some of the rows a press delete, which launches "a!startProcess" function; the problem is that I don't know how to refresh or redirect in that case. I have no rule inputs or variables...

Hi! Is there any possibility to use the same model for different interfaces? In my case: I have an interface where I insert an ID and delete the data with that ID, I used this interface as a start form for my process model. Now I created an interface with a possibility to select multiple rows in a grid and I want to be able to delete all of them by pressing a button. My question is: is there any possibility to use the same process model or I have to create another one? Thank you!

Hi! I'm working on a training project and my aim for now is to send an e-mail when a form is rejected.  I managed to send the e-mail, but I also wanted to mention in the e-mail the ID of the rejected data. However, when I use the following expression: =pv!customerDetails.customerID The rejected data is called "CustomerDetails" and contains a "customerID". In the process I also used a process variable - customerDetails, in which I save the CustomerDetails. I also tried to add an input variable which would have the id value inside, but I didn't manage to use it in the mail either. Thank you, in advance!

hey all ! I' am new to here, are you thinking using the Appian knowledge can get a job in a short time?  

Hi,       i am new to Appian. I am not able to find out why Appian agent ( AppianRPAagent.exe ) is not running in my windows machine. I just downloaded the agent i my system, I am using windows 7,  RAM 8 GB . But when i double click on the exe file it is not executing. What may be the cause? 

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 ?