Community

#1452 - Cannot add or update a child row: a foreign key constraint fails (`Appian`.`#sql-alter-34ce-15086d9`, CONSTRAINT `table1_ibfk_2` FOREIGN KEY (`first_id`) REFERENCES `table2` (`first_id`)) What does this error mean?

I want to do some typecasting in data store and save it in new column . For example I import  the  excel and it read the date as varchar,if I change its data type as date then the value shows as 00-00-0000 , I want to do typecast for entire column and save it in a new column so that i will use the latestcolumn for query entity. Please help me on this

I have requested for trial account access three days prior but still not received trial account login details

How to write trigger in appian database? Any KB?

Hi All, I am creating the relationship between two tables but system does not allow me and throws the error "1452 - Cannot add or update a child row: a foreign key constraint fails ". Do I need to update in the CDTs for these tables as the CDTs are already created for these tables. 

Hi, Can anyone please help me how to import the excel in appian database without using database.

Can anyone please tell me how can I link tables in Appian so that data flows from one table to another using primary foreign key relationship?

Is that possible to create multiple CDT from a single database table ?

Hello, I am currently building my application.  However, There is just a certain bit of functionality in my process model that's too data manipulation heavy, and I would like to run it on am external web server.  I can write code that can handle this for me in Python, and I can set up an api for it on a web server.  Now all I need is for Appian to call that API every time I need to run that ETL functionality in my process model. is there a way for Appian to call an external web API from a process model? 

Hello All, I have a requirement that status need to be updated until following Monday. We will upload spread sheet on Every Monday or Tuesday or Wednesday. While uploading it will check the date(it is a column in spread sheet) current date and previous date records will be updated to New Status. Now the requirement is it should be validated previous dates, current date and until following Monday records. We are able to achieve previous dates and current date. How to get following Monday date as we are not sure about the file upload week date. For example: On 08.12.2021 If I upload the file it should be validated on or before 08.12.2021 and until following Monday(08.16.2021).   On 08.11.2021 If I upload the file it should be validated on or before 08.11.2021 and until following Monday(08.16.2021) Please Suggest. Thank you

Hello Appian, From the appian cerification FAQ link, https://community.appian.com/learn/certifications/p/faqs  It says that "To maintain your certification, we require that you consume the quarterly release training and complete a short assessment." Where can I find the Quarterly release training? Is the "Release Showcase training" the right one? https://academy.appian.com/#/catalog/e17ac3d6-142b-418a-a4d6-1a23386be533  Also, do I get a message or alert before my certification gets expired? 

Hi, I am using the send email smart service. I let the user write the body of the email in a paragraph field, save body text in a text variable, and in setup>Message Body field, I use an expression to fill the body with the text variable.  However, the email gets sent with no formatting. At least, I want to capture the "new line" breaks that the user enters in the paragraph field. I would appreciate your help.

My use case: "Implement a related action. The related action will send an email. The list of recipients is inputted by the user. The subject line is inputted by the user. The body text is inputted by the user. These user inputs are captured after submitting a form interface"  I am using the "Send E-Mail" smart service. I am passing recipientsList, emailBody, and subjectLine text values as inputs to the process model.  How can I use these process variables in the Send E-Mail smart service node? I can't seem to figure this out!

Is there a way we can use xpath expressions on Appian Selenium api without initializing webdriver class?

I have a table called reference amenity in which I have manually mapped amenityId and amenity types, I want to call this table using the foreign key field of another table called amenity table and want to store the amenity Type.By using the expression rule I have called the reference table but I want to store the amenity types  using the foreign key  can anyone suggest to me how to do this. Reference table: ammenity table:from this table I want to call the ammenity type  ...

Hi My use case is as follows.  I have a button that initiates a process that creates an excel follow.  After pressing the button, and upon successful creation of the excel file, I want to display to the user a document download link. As for the label of this link, I want it to say "Download + FileName", where the file name is a Local Variable  for example, I want the label of the link to say "Download Excel File Number 5" for example Is there a way to make the label field dynamically displayed based on the value of a local variable. 

Hello All, We have an Angular Page(Dashboard) where all the Appian's tasks related to logged in user will display. There is a run task link which will open Appian task in new window and user can complete the task. Once the Appian task is completed the task window will get closed automatically and dashboard will display the updated task. We want to show a success message at Angular page(Dashboard) something like “ Task : [name] has been completed”. Please can someone share any idea to achieve this. Thanks, Gaurav

I have a process model that is calling an excel sheet that no longer is tied to the constant that is being used for a process variable.  We are working with an existing code base and there has been some deprecation since taking over the project.  When running the process, the error is "Invalid Content ID".  In the constant used for that data input has a value that says "Not Visible".  Is there a way to determine what document that constant was tied to, even with it saying "Not Visible" as a value?

Can any one provide proper answer and justify the answer with brief explanation with examples.

Hello Appian, How do I make a link to return to the previous grid, after having drill-down to a summary view? 1. drill-down to summary view through read-only grid(record grid) 2. from within a summary view --> want to go back to the grid using a link Thank you!!

I have one login form, I want to add one link from where i can redirect user to next interface or register page if not register, can i do that using interface component . I was trying to do that but not able to give the uri for next interface, please check below code: a!linkField( /*label: "New User? Register Here!",*/ labelPosition: "ABOVE", links: { a!safeLink( label: "New User? Register Here!", uri:" ", openLinkIn : "NEW_TAB" ) }

Hi, How to create a horizontally scrollable card list similar to what is shown in the image below.

Hi, I am unable to add " all users " group as parent group to " admin group " in my application. While I was creating the Admin group and tried o find " All users group " in  the parent group column, but it was not visible. Can anyone help me. Thanks, Praveen 

I have workbench installed in my system how do I connect it with my cloud appian??

Hi, I have a basic question Suppose I am working on ExcelDataProvider template, and I want to change content of the file as well as name of the input file and some logic of mine to process the rows. What is the process to build/deploy the java code using IDE. and do we need to import deployed code again in Appian ? Thanks, Mohini