Records

Hi, Could someone let me know ? 1. what are scenarios where we can use ? a!recordActionItem() 2. Why do we need to define the default value while adding a row using Add Row link?     is it mandatory?      addRowlink: a!dynamicLink( label: "Add Employee", value: { startDate: today() + 1 }, saveInto: { a!save(local!employees, append(local!employees, save!value)) } ) ) }3. In what scenario/s we will go for Editable GridThanksFaisal

Hi, I have a question: When you have some multiple dropdowns (with items stored in reference table), do you always store your data in 2 different tables ? a first table for the data source, and another table to save the multiple values and make the link with the first table. I have already seen, multiple values stored in a single table with concatened values to store the keys in a text field, but unfortunately, this seems not a good way because of the DB foreign key constraints missing. Regards

I am attempting to create a site to view the data from a web API on Appian. I set up the integration, which seems to return the results just fine: However, in the record data source, it only shows the first part of the results: I would also like to note that I am attempting to adapt from the tutorial on the SpaceX tracker on Appian Academy. Thanks.

Query Entity fails when using operator "include" for the column having NULL value in database. I am using view to retrieve the data. This is working fine when I remove the query filter having "include" operator. Seems "include" is having problem with columns having null values specially in case of view. Anyone, please suggest some solution around this. Exception details: Expression evaluation error at function a!queryEntity [line 3]: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [TWMVwDocumentMappingDT4091], query: [queryentity expression], order by: [[Sort[isDeleted asc]]], filters:[((isDeleted = TypedValue[it=26,v=0]) AND (siteId includes TypedValue[it=3,v=AB41855]))])

Query Entity fails when using operator "include" for the column having NULL value in database. I am using view to retrieve the data. This is working fine when I remove the query filter having "include" operator. Seems "include" is having problem with columns having null values specially in case of view. Anyone, please suggest some solution around this. Exception details: Expression evaluation error at function a!queryEntity [line 3]: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [TWMVwDocumentMappingDT4091], query: [queryentity expression], order by: [[Sort[isDeleted asc]]], filters:[((isDeleted = TypedValue[it=26,v=0]) AND (siteId includes TypedValue[it=3,v=AB41855]))])

Hi, I have a requirement where I have to query the data from database for a particular column of type CLOB which has data more than 1 MB and display it in a text file . While fetching the data from queryEntity it is reaching to memory threshold or it is reading the column data as null while trying to fetch the output directly from store procedure to flat file. Please recommend me some way of how we can handle large files in Appian. Thanks in Advance!

I see this tilde every-time the value of my floating point reaches 9999999999999. Does anybody know why?

Team, Scenario, We have a UI where Admin team selected the table from dropdown where they want to make changes . Now i have to send that CDT as an input to write to datastore from interface. Can this is something we can do , entity remains same but input changes based on user selection . What to select in type usually we select CDT for which we want change , but in my case it will come from UI. Any thoughts how to do it ? or any other solution basically based on table selection we need to update a value in one column,

Hi All, I created an entity backed record on the main table which works as expected. However, as part of requirement we require to do search on the data in the child table which has one-to-many relationship (for each entry in main table, there can be multiple entries in child table). I tried using expression-backed record. But I'm only able to display the entries of child table, but cannot search on those fields. Is there anyway we can do the search on child table from record default search? Note: We are currently on 21.2 and explored the new feature of adding relationship for records. However,it does support only Many-to-One and one-to-one relationship which is of no use for our use case

I have a entity-backed record, with sorting applied on Transaction Id. While sortinfo is on date field. Sort is not working as expected. When i first land on the page, sorting on descending as expected. When i click on next button to get next 25 records, getting data starting from 26 - rest. Again if i click back icon, seeing records from 1-25 instead but not the data form screenshot-1.  Any suggestions please?

Hello. Can you use a CDT as the rule input to create the Summary view of a record? Thank you

I have a use case where I need to use the data in Microsoft project file (MPP file). Tried converting it to an excel file and using it, but after converting because of merged rows, parsing data to cdt is not working. Any leads on how to resolve this?

I have a record with multiple related actions displayed as cards using the a!recordAction field on the record summary view. Currently, when the user clicks on a related action, all of the data for that related action is queried in local variables on page load. Many of these related actions use the same queries, so if the user clicks on two different related actions, they need to wait for that query to execute each time. The queries can be quite slow, so I am trying to figure out a way to query more data up front before the user goes into a related action so that a) the page load is faster, and b) the same query does not have to be run for each related action. I tried adding additional fields to the data type of my record, and querying for the additional data I need in the Single Record Source query to populate those fields. Here is an example of what I tried.  This is a genericized version of the rule that I use on my record to query a single record (th

Hi Team, We are currently using the Microsoft SQL Server with 8 millions of records which we are thinking to migrate to appian internal db Mysql , Is this the good idea? Is Mysql db what appian provide will have the capacity to insert millions of data How the performance looks when I try to pull that data in Appian reports? As of now it is 8 million but it get increase day by day , What are the suggestions?  Thanks, Udayasai

Feature Request: Enable local variables where we can query or get some important data related to a record item so that it can be reused in all the of the related actions visibility because we usually do same set of queries/group checks most of the time. 

Hi Team, Please find attached  I am using the rule in my process and it fails sometimes, can i know is something issue due to connection or something issue in code How we can avoid this issues

Hi All, In third party database, we have a column (number datatype) which can have more than 10 digit value. How to display the value on Interface. We have tried mapping type = "xsd:integer" and "xsd:long" and "xsd:int" in XSD  xsd:int gives Numeric overflow error, on changing it to xsd:integer / xsd:long, it retrieves blank value on query entity but there is value in DB (which has 14 digits) How to retrieve the values having more than 10 digit value? Any advice. Thanks and Regards,Diksha

Hi, Yesterday my client met this issue in Production (no deployement made since two weeks), this happends with a specific user.     "UI Expression evaluation error:      Expression evaluation error [evaluation ID = BQLBSYMP ] in rule .... at function a!gridField [row: 21]:     The record data does not exist, has been deleted, or you do not have sufficient privileges to access it" Then, he had a HTTP ERROR (code 413). To correct the issue we just emptied the browser cache and it has worked back. but, today, the client met exactly the same problem again on its TEST environnement. This time, emptying the cache did not correct the issue. What I have did, is just to edit the first rule concerned (called by a Report) and edit and re-save it. After that, it has worked back again. Could you tell me if you know what it is behind this error please ?

Our application became terribly slow after adding a Grid column with Related actions. We have a record type with Type "Other Web Service" which calls backend Integration and gets 20 records, it also has 9 Related Actions. Before adding new related actions grid column, page used to load in 5seconds but now it is taking around 40seconds. When checked the performance of grid, grid column is making 20*9 = 180 integration calls which is causing the slowness. Any idea on how to reduce the integration calls?

I have a CDT named "LNE_Servicing" which has 2 foreign keys, one from CDT userList and one from CDT soldAppliance. When I try to create a recordType for Servicing and check the record it gives me the error: The Requested Record Type Is Not Available Expression evaluation error [evaluation ID = Y38GMQ7D] at function a!recordList: Cannot execute a query with a blank field name. (APNX-1-4198-000) In the performance tab of the record type it shows: Could not calculate performance. Please check record type definition. Expression evaluation error [evaluation ID = RUAXQRTA] at function a!recordList_ui_design: Cannot execute a query with a blank field name. (APNX-1-4198-000) On clicking edit list in the List tab it shows: Error Evaluating UI Expression Expression evaluation error at function a!gridField [line 27]: Cannot execute a query with a blank field name. This is my servicing table:

I currently am writing a basic ticketing system which has an interface used as a record summary view, in the interface is a submit form where users will submit comments to be saved to the database. I am wondering what is the best practice for saving that data in the database? Is there a way to initiate a process model on a record view?

Hi, I want to update existing multiple records in appian table having a primary key. How can I do this ? is there a smart service to update bulk records in sql appian table ??

Hello everyone, I am building an interface dynamically for a questionnaire based on previous responses (so I can view the previous answers and then edit them if necessary when re-reviewing). The questions are stored in one database, the items being assessed in another, and the responses to my questions in a third. So, the issue is when I add a new question and answer, I receive the following error: Interface Definition: Expression evaluation error at function a!forEach [line 140]: Error in a!forEach() expression during iteration 25: Expression evaluation error at function a!radioButtonField [line 145]: Invalid index (25) for list: valid range is 1..24 It reads as though it's able to loop through my first 24 questions and then throws up on the new entry, but I am not constraining the index to 24 values. I believe this is because it's not handling the missing values properly (previously assessed items have no response for the new question) so I manually inserted the values into a

Hello,we have a problem using the attached rule, note that the value for batchSize is 10.The following error message appears:Error evaluating expression [....] in rule [...] at function queryEntity [line 3]. An error occurred while retrieving data  The entity being queried is a VIEW in the SqlServer database, and this view contains about 68.000 rowsIn the tomcat-stdOut.log  we found the following rows:2021-05-05 13:12:52,416 [ajp-nio-8009-exec-9] ERROR org.hibernate.util.JDBCExceptionReporter - The query has timed out.2021-05-05 13:14:20,013 [Timer-4] INFO  com.appiancorp.cache.sail.StatefulSailCacheImpl - Stateful SAIL db cache cleanup process executing...removing expired entries from                                                &nb

My requirement is to refresh my related action button when any event happens and the visibility for the related action set to false