Records

We have recently upgraded Appian to 22.4. I have noticed since the upgrade, when importing packages with nested CDTs that it takes quite some time (anywhere from 10 min - 2 hours) to import the data types. If there are other data types in the package, it will import all of those and get hung up on the nested data type. Then, if there are other packages to import to the application, they get held up because the first package has not completed. Has anyone else had these issues or know of a way to fix this? The nested CDTs are just to store information from API calls, and not used to write to a database. Example of an import with two data types in it, took 21 min to import:

I want to pass a record type local variable to a process model, I get an error on either ways I'm trying, I just want to make sure I'm on the right track, which of this two was is the correct one, if any? local!myVariable or local!myVariable[recordtype!myRecord] thank you

I am new to Appian and I need to write a rule that takes an array of CDT objects; updates all of their "id" and "loanId" values to null; and returns them. I have been trying to use a foreach loop as follows but the data won't change. what am I doing wrong? a!localVariables( local!assestsLiabilitiesDetails: ri!assestsLiabilitiesDetails, expression: a!forEach( items: local!assestsLiabilitiesDetails, expression: { fv!item: a!update(fv!item, "id", null('type!{http://www.appian.com/ae/types/2009}Integer')), fv!item: a!update(fv!item, "loanId", null('type!{http://www.appian.com/ae/types/2009}Integer')), } ), a!save(target: ri!assestsLiabilitiesDetails, local!assestsLiabilitiesDetails) ) Thank you in advance for the help!

You need to edit data in a table. You ate currently using the following statement:INSERT INTO product (productId, productName) VALUES (3, "App1e");What is the issue? A. You should be using an UPDATE statement. B. You forgot the WHERE clause in your statement. C. You should be using a CREATE statement. D. You should be using an EDIT statement. The correct answer in the site from where I got this question says 'C', I think it should be 'A'. What's the correct answer?

I need to add a field as source filter which is available in a related record. How to add that field as source filter in appian record ?

it saves when I use this: a!writeToDataStoreEntity( dataStoreEntity: cons!AF_EXCELPIPELINE_CONS, valueToStore: local!pipelinetest ) but does not save when I use this:  a!writeToMultipleDataStoreEntities( valuesToStore: { a!entityData( entity: cons!AF_EXCELPIPELINE_CONS, data: local!pipelinetest ) } ) why is that so?

Hi! I´m constructing an editable grid in which the user can add new rows (purchase order lines). I would like to add a column with the number of the row as an "identifier" for each PO line, something like this: So my question is, how can I configure the text field to auto-generate values from 1 to infinite after the user adds a new row? Thanks for your time!

Hello All, I wanted to know what the best way is to export the data to excel. We know the records the best way to do it but due to some reasons we cannot use records as we have multiple departments and for each, we don't want to create Records. Coming to OOTB smart service provided by Appian (Export DSE to Excel) - it doesn't allow us to do any customization on the data from db. So,, for that we have written a view, but it takes considerable amt of time since we need to show multiple Display values instead of codes. So, joining with the reference table for each category is also slowing down the performance. (We are using MySQL) We are trying best to improve the performance but seems, there might some changes come future which may slow down the performance.  So trying to find the best way to handle it right now.  Do we have any integrations specially for excel? Or if anyone has worked on specific requirement, we where we need to fetch data from Mutiple tables and al

Hi team, I am capturing data from process metrics report and storing to oracle db as it's business requirement. Now I just want to check is there any inbuilt functionality of Appian which only writes the rows in table which has been not inserted in the previous run ? if not is there any suggested way you recommend that can be followed to achieve the same ?

Hi All, i am developing an application in whcih I have to fetch all the records from table. now the problem in doing so is while running the expression tule it's failing which i think is failing because  i am fetching everything at a time. I want to fetch it in batches how can I make it in such a way that it fetch in batches but while writing, it should write it all at once. And also one thing this table will increase everyday by 5-7k rows. And also if i fetch data in batches won't it hit db multiple times ? What should be preffered batch size ? Please suggest me good practice to achieve the above.

Hi all, My problem is that I am trying to delete multiple rows from a DB table at once. All the rows I'm trying to delete have the same PK as the PK is a FK from another table. This is the code I thought would work but didn't: = {     a!forEach(          items: pv!CTI_mnthlyrevene_cntrctmnths,          expression: a!entityDataIdentifiers(               entity: cons!CTI_ENTITY_MRCM,               identifiers: fv!item.ctmnthlyrvCntrctmnthRcrdd          )     )} I've tried not using the foreach and it still gives me the exact same error:  An error occurred while trying to delete data. No data was deleted. Details: javax.persistence.PersistenceException: org.hibernate.jdbc.BatchedTooManyRowsAffectedException: Batch update returned unexpected row count from update [0]; actual row coun

Hi! I was trying to make a security rule for my record (filter --> loggedUserName() = nomProveedor (one of my fields)), but in the security rule I can only put direct values or constants   I found out that there are security expressions, but how should be my structure to obtain a filter like the mentioned one? Example: Username: Proveedor 1 I want to filter the record so that he can only see the rows in which my field "nomProveedor" is equal to the Username Thanks a lot!

If I intend to use Rich Text for a field in an application, what type of formatting should the field have in the database?  Would a Varchar(4,000) work for example?

A record is created but getting null error for a field.  Checked the DB structure as well, the field nullable = Yes there

Hi! I would want to filter a site (record security) based on user conditions. When the user enters, I want to assign him a supplier name and a NIF, and then use this data interfaces to filter. Which would be your best-practice advices?

Please help me to display of individual item and it's count from a stock record type in the summary.Let's say there are 3 items A, B, and CBelow the Summary page, three individual tabs A, B, and C will be designed, when A tab is selected the particular item detail like item name, count should be displayed. Can anyone please help me how to achieve this?

Hi! I have developed a site and I want it to be filtered for each user based on its condition (supplier name). Basically, my idea is to use the site as a "Supplier Portal", so each supplier can only see its own Purchase orders and invoices. To be clear, I want this: - User 1 is the supplier 1 in real life. I want Appian to know that he is Supplier 1, and filter the records with this condition (in the record it would be nomProveedor = Supplier1) I have thought about the options but I would want your expertise and advice: 1) Create a record type (username - supplier), and use this information to filter the record (I have doubts on the steps to achieve the supplier field based on the username and how to put it into a filter/query.  2) Create a previous interface in which the user identifies himself with the supplier name (F.e. supplier 1) , and use this variable to filter 3) Create a group for each supplier and give permissions (it would be fine for 3 or 4 suppliers, but no

Hi Will it possible to filter the data without defining that column in record list means for example i have one column which has Boolean values as Yes or No  i have to define that column as filter in Record without defining that column in Record List. Kindly suggest in this

Hi! I´m trying to query a database which has: - A date field (month-day-year) - A number of days to add (integer) I want to use a query in order to add the number of days (integer, I want it to be days) to the date field, and return a date field.  I tried the following query but it doesnt work (returns null). And the function ADD_DATE is not able in appian. What can i do?

I have a record type which is not a synced type. It is referred using a CDT. I understood that synced records have better performance. I want to understand the difference between un synced record type and query entity, both are basically trying to fetch values from the Database. Can we use query entity instead of unsynced records?

I went thru the documentation and thought of increasing RTS count from 2 to 4 but looking for more info in terms of impact of this increment. We have 60 GB RAM and 4 CPU for the enviroment. Now Data server log file under ss folder is showing 9gb size and while starting up data server, CPU usage was 100% for few secs and some time in past it took 15 min to come up. In Appian Env, we have Record type sync and many columns are of 4000 char.  Will it be helpful to increase RTS count in this case to avoid any sync issue while bringing up the data server.

When we try to pass values  queried through entity based expression rule to value field field of record type query filter it fails. How to make it working? I have checked in both cases for querying data  same set of list of integer is returned but it fails for query entity

user gets this error frequently at peak time - "An error occurred  because the record type source is currently unavailable or the query reached out a timeout or memory limit",

I am Facing Some Issues While Mapping Data store entity. I have created a view by joining three tables, and I obtained the exact data. Then, I created a CDT (Custom Data Type). However, when I attempted to map it into a data store, it failed and displayed an error.