Records

I am tasked with mapping data to a docX to generate a pdf. I have most of the data mapped properly, but I wanted to know if it's possible to generate a pdf download of a record list or read only grid. Is it possible to print off the entire record list? Mapping data to a pdf requires that you know how many fields you need to populate. How can I generate a pdf that has a dynamic amount of data?Thanks,

The problem statement is: To create a username for a person by joining their Last name and first letter of their First name. Following is the code: a!localVariables( local!userList: { "derek.romeo@gg.com", "gloria.juarez@gg.com", "pearson.vue@gg.com", "stefan.price@gg.com" }, local!names, local!result, { a!forEach( items: local!userList, expression: { append(local!names,tostring(reverse(rdrop(split(split(fv!item,"@"),"."),2)))), local!result:{ index(split(local!names),";")&index(index(split(local!names,";"),2),1) } } ), } ) This code is throwing the below error: Expression evaluation error at function a!forEach [line 13]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function 'split' [line 18]: A null parameter has been passed as parameter 1. When I run the code without lines 17 and 18, I get the below result: List of Variant - 4 item

Hi All, I want to create ERD Diagram for my Database schema in Appian database. What is the best way to do this? Regards, Ghanashyam

Hi all, In my record type I have a related action, this I am triggering from a UI grid column. The related action points to a PM that performs operations and has no UI associated, but as soon as I hit the related action I am getting a white dialogue box, as if there is a UI in the associate PM, and then closes automatically. Usually if there's a UI the dialogue box would make sense, but why is it coming in my case. It could create a kind of confusion if a UI is coming into picture. Is there any way to disable the dialogue box other than selecting its size?

My app is built on an Oracle Database. Would it be possible to overcome the 4000 byte of Text limitation we have for Synchronized Records fields? I know the VARCHAR2(4000) limitation is considered to be a standard column type by Oracle, then choosing the EXTENDED for param. max_string_size in the DB would make it an "extended data type", as CLOB is. But since CLOB is forbidden to become a Snyc. RT field, would my large VARCHAR2 columns be also forbidden? Asking for people who tried it. If no one did, I will ask the DBA, but could be easier to ask here ;)

We have configured a service backed record with full sync configured. We also have a use case of syncing the changed records after the put call of that service is successful. In the put call process model, we have used Sync Record smart service and have passed the identifier into the node. Our sync expression uses token as an authentication to the service. This configuration works smoothly in dev environment. After deploying the code to QA environment using a Deployment Admin account , our sync record smart service is failing. The error is of failed authentication. (To cross verify, we passed the same identifier to sync expression manually and it returns the row) The Deployment Admin does not have a valid token to successfully call the integration. To resolve that we have configured the smart service node to run as whoever started the process. Even then the sync is giving error of authentication. We checked in System logs and even there we didnt find any additional information apa

Hi All, I tried to use a!queryrecordtype to query a process backed record and am getting result. When i tried to put ".data", am getting below error. Any idea on this error? Thanks in advance

Hi Champs, I have a use case where I need to execute an action/process Model to update a column in a database table on user entry to a record view. It should be automatic. There is no user interaction required for this. Is it feasible? The functional use case is ,I am showing the alerts to the user in summary page if there is any message in history log table. Once User click the History log tab, I have to make all the unseen messages to seen automatically. To Better explain, I have two views in my record which is Summary View where I will show the alerts to the user if there are any new messages and the other is History/log message View. Regards, Ghanashyam

Dear Community, We encountered an issue recently regarding disk space, where it reached its full capacity two days ago. Upon further investigation, we identified a timer that was causing file duplication, leading to the storage becoming full with over 1.6 million files. To address the situation efficiently, we attempted to remove the entire folder (Knowledge Center > Artifacts > folder xyz) instead of deleting individual files. However, we are now facing a challenge as the "artifacts" folder is displaying 40GB of consumed memory, while there are only five files totaling 200KB in size. Despite our efforts, we have been unable to locate any hidden files or identify the reason for the excessive storage consumption. We are seeking guidance on how to identify the root cause behind this issue and optimize the storage usage effectively. Thank you for your support in resolving this matter promptly

Hi Champs, I am getting a strange behavior when calling a record view from a site, it's not showing the breadcrumb as highlighted below when called from in site. Instead it is showing like this without the breadcrumb. Am I missing something while configuring in site.

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