Records

Hello, We need to export data from a database based on user-selected filters into an Excel sheet for reporting. Currently, our process queries data in batches of 500 rows and uses the deprecated "Export CDT to Excel" function to generate the report, as we need to export 80 columns. Since we are running in batches, we cannot keep the smart service into separate start process as we are appending the generated document with new values and incrementing the start index.  However, as the data volume has increased, users are exporting data upto 50,000 rows, leading to memory heap issues causing Appian server to go down. The latest export functions have a limitation of 50 columns, which does not meet our requirements. We made process variables as hidden but still memory is hitting upto 6k AMU. We are using mySQL as database which is hosted on AWS RDS. Currently we are using a!executeStoredProcedureForQuery() to query the data from database. Before we wer

So, I'm building a record where i have all the items in the store, then i can drill down to 1 item and update ir, but when i click on update item related action i get this error:  An error occurred while applying the context for the AS Items In Store related action [identifier=21]. Details: No process parameter found corresponding to override [name=pv!item]. Non-parameter process variables cannot be overridden. Any help?

Hi, I'm just getting started with learning Appian. Was trying to create a recordtype from scratch with v25.1 community edition. But, dont see an option to do so Can someone please help?

Hi team,Scenario - There are many table for our application and all of these tables have there respective Appian records. Now, if someone adds unique key constraint to any of the column on any table then we also need to re-map column on the respective records. Ask - Is there any direct way to generate a summary report to fetch all the records whose mapping of columns is breaking/ where we need to remap the columns in our record.

I want to add searchable filters in a recordtype, is there anyway to achieve this? For example, i have made a custom filter below which calls DB & gets the productionUnitCode upto 15 & then i can select multiple in it. I want same thing with record filter rather than custom making it.

hi, I was wondering if I can export data in process model  with expression rule? Data from expression rule: List of Dictionary - 2 items    Dictionary           name "John"(Text)           memberID"X123"(Text)    Dictionary         name "Jane"(Text)         memberID"X456"(Text) Export the below data to csv or txt file( without any header) John, X123 Jane, X456

Hello Appian Community, I've been given a somewhat complex JSON format to ingest into Appian and stage all the data into the DB.  The intention of the data is for reference/comparison/reporting.  I've tested the regular readtextfromfile/fromJson/jsonPath functions to grab each attribute but it feels very tedious/clunky to have an JSON path expression for ever attribute I need.  Could I get any advice on a more efficient way to parse this data and get it in the DB? Data Context: One JSON will have thousands of "FullProduct" entities so I will be dealing with files with a size of at most 25MB.  This structure is the final format so there is no altering the original file. JSON Sample: { "FULLPRODUCTFILE": [ { "FullProduct": { "ID": "*dfg333", "Details": { "StatusType": "LIVE", "Status": "ACTIVE" }, "Classification": [

I have a View in the Appian Cloud database with a column that concatenates some values, lets call it column "CODES". I started in our dev environments creating a CDT from Table/View and verifying the datastore. I then did a distribution to the test environment of the CDT, View and Datastore. While verifying in test environment I get an error that CODES is not a MEDIUMTEXT, it's a LONGTEXT. Not knowing what to do I try to create the CDT in test environment and actually the generated CDT in this environment is different that the one that was generated in dev, even though the database view is the same. Any suggestions on how to solve this issue? The thing is that I don't know in a production environment which datatype Appian will choose, and I don't want to create objects manually in production, I shouldn't even be able to. Thank you!

I want to generate a table inside a word doc, below is the config of the smart service "Text Doc from Template": 

I need to make a record-like query for a 1 to N relationship, in which it only returns the values ​​of the parent record if all the values ​​in the N relationship meet a condition. Example : I have a record called "Need" and it is related to another called "needchangestate" through a relationship 1 to N, I need it to return only the needs where all the needchangestate meet a condition, if all the elements of the relationship N do not meet the condition, the element Need should not appear Currently it returns me an investment where the condition is met in at least one of the records of the relationship N but this is not what I am looking for.

I need to deploy a series of datatypes to another environment. So I deployed the datatypes and then the datastore, and overwrote the original. Now the datatypes I needed are on the new datastore.But when I go on with the deployment sending the rest of the changes to my environment, the Data store entities constants related to the datatypes I recently sent to my other environment give me the following error: UnresolvedDataStoreEntityException: entity [...] in data store [id=... uuid=...] cannot be found.help, please!

Hi, I need help understanding why record sync is not occurring when using the "Write to Datastore" smart service in one environment, while the latest data appears in the records in another environment. In the environment where sync is not happening, a manual sync is required to view the latest data. Can someone help me understand the cause of this issue?

Hi, I'm using Appian 24.2.270.0 and trying to insert an eventHistoryListField with comments in an interface , but when I click in the field for comments, the buttons appears like in the image here below.By clicking, the comment is inserted fine but why those buttons?Any solution?Thanks!

I want to change the field name of a CDT to match the renamed field in the database. The old name was "FIRSTNAME" and the new one is "FIRST_NAME". Related to the best practices, the best way to do so is to download the CDT as XSD, change the field name in there, and re-upload the XSD, verify and publish the data store as a last step or is there any other best practice thing? Thanks in advance.

Can I add hidden record fields if data sync is NOT enabled on a record type?

Hi All, Hope you all are doing well, quick question, is it true that using a!queryEntity can skip the Record Type synchronization? I'm facing issues in my application cause I have an after insert trigger that is inserting a record based on some conditions, but the new record inserted is not being reflected in the application until I manually click Start Full Sync, wondering how can avoid this issue. By the way the version that I have is 23.4 Any help would be greatly appreciated. Thanks in advance, Jose Castellot

Hi Team., I have made changes in the DB for the column size changes, but in the Record type is not getting reflected in RT, or is any modifications need to be done here. note: no CDT used in the application only RT. thanks.

User uploads the word file with number of screenshots to APPAIN using file upload component in an interface, but some of the images in the word file is missing and facing the blank space in the place of image, what might the cause for it.

Hi, Am unable to use aggregate functions on child CDT having many to many relationships with parent CDT. Background I have a parent CDT called Campaign which has many to many relationship with child CDT called Channel. I have Campaign table, Channel table and mapping table as well to hold the relationship in database. Requirement I need to group the Campaigns based on Channels. Issue I am unable to use Aggregate functions on channels field in my Parent CDT - Campaign. How can I achieve this using CDT relationships. Thanks  

Hi, Is there a possibility to connect Appian Cloud Database from outside. Thanks, Sadhu Surendra

I have Room (roomID column) and a Key (with keyID, roomID, and keyDescription columns) . A room can have multiple keys. I setup a one to many relationship between the Room and a Key using the roomID.  I used the Room record to populate a gridField. The search is not returning anything if I put an information that should match the keyDescription. I have the code below. I am only after for keys that are active which is one active key per room. Even if I remove the filter in the code, it does not return anything. Is this expected for a One to Many relationship?    { a!gridField( data: a!recordData( recordType: <room_record>, relatedRecordData: a!relatedRecordData(relationship: '<roomRecord-keyRecord>', filters: { a!queryFilter( field: '<keyRecord.isActive>', operator: "=", value: true ) } ), columns: { a!gridColumn( label: "Room ID", sortField: 'roomRecord.roomID', value: fv!row['roomRecord.roomID'], ), a!grid

I am using export DSE to Excel smart service, but the output data is not the full data the Table is having. I am having around 21k data in table where as the excel that was generated through the smart service is having only 20k rows.Are there any limitations for smart service?

Hi, We have a record type based on a service. Data syncs every morning 3AM. Today morning data synced well. We are using this data on a UI. The issue is, CaseInvalid on UI. When we look at the cause of it, we found the service is down. Is it mandatory to have the backed service up to use the already synced data from Record type to be used on UI? Thanks, Keerthi

HII'm trying to count the number of records in the data entity HVSDC_PlanesMejoramiento_Entity that meet a specific filter on the field CodigoSIRECISujetodeControl. This is the SQL query, which works fine: SELECT CodigoSIRECISujetodeControl, COUNT(NombreAccion) AS total_accionesFROM HVSC_V_PlanesMejoramientoWHERE CodigoSIRECISujetodeControl = '11745' GROUP BY CodigoSIRECISujetodeControl; This is the query in Appian: local!count: a!queryEntity( entity: cons!HVSDC_PlanesMejoramiento_Entity, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "CodigoSIRECISujetodeControl", operator: "=", value: tostring(ri!codigoSireci) ) } ), aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "NombreAccion", aggregationFunction: "COUNT" ) }, groupingColumns: { a!queryGroupingColumn(field: "CodigoSIRECISujetodeControl") } ), pagi

I have an endpoint which returns data consists of 5 columns (text and date fields). I want to keep an text field and then when I enter values in the text field, I want to filter the data based on the value I entered. It should filter dates if possible