Records

Is there any to find the size of the data that is returned by a query?? The default size limit is 1MB, but we want to understand how much rows we can pull from database without reaching this limit.

for a particular record type object getting following error message : Expression evaluation error [evaluation ID = HGT9M] : Could not find driver for MariaDB.since we are using mysql but getting error on MariaDB

Hi, I am using bigint for storing codes, account numbers(as they can go upto 15-20 digits) in SQL. I need to use them in Appian. Is there a way to map tis data?

can we make one user filter dependent on other. For example if we select category user filter then only corresponding sub category values should be shown in sub category user filter.

I'm getting the errorExpression evaluation error at function a!recordActionField [line xxx]: Cannot compare incompatible operands of type Null and type Boolean.I'm not sure why this is occurring.Code: a!gridColumn( value: a!defaultValue( value: ri!recordActions, default: a!recordActionField( actions: { a!recordActionItem( action: relatedAction1, identifier: fv!identifier ), a!recordActionItem( action: relatedAction2, identifier: fv!identifier ), a!recordActionItem( action: relatedAction3, identifier: fv!identifier ), a!recordActionItem( action: relatedAction4, identifier: fv!identifier

I'm looking to configure a filter in a!queryRecordType() that's similar to checking for null values on the outer side of a relationship that behaves like an outer join. For example, I have a data structure as described below. The table Invoices is managed by an Appian application and we have a synced record type based on that table. The table SAP Documents is updated by an external source and we have another synced record type based on that table. There is a many-to-one relationship configured in our record type from Invoices.SAP_DOCUMENT_ID to SAP Documents.SAP_DOCUMENT_ID. Invoices ID (PK) a bunch of other fields SAP_DOCUMENT_ID (FK) SAP Documents SAP_DOCUMENT_ID (PK) a bunch of other fields I need to query the Invoice records and return those where there is a value in Invoices.SAP_DOCUMENT_ID and where there is no corresponding row in SAP Documents - and I need to combine this with some other query filters, so this is not the only co

Hello Everyone, I am trying to insert a record which would be using the Write to Records or Write to Data Store Entity smart service to a table that has a trigger at the backend DB. The trigger is for checking for the existence of a particular value in another  table. If the ID being inserted exists in the another table, the insertion will proceed without any issues. If the ID does not exist in the another table, the trigger will prevent the insertion and typically raise an error. So in the second scenario if  the ID is not found, will the write to records execute normally or would it give an error because of the trigger? 

for example my array size is 3400 in the first write - 1 to 10002nd time write 1001 to 20003rd time write 2001 to 30004th time write 3001 to 3400 How we can achieve this one  can anyone help me out  TIA

We have a process where data from a third party system is imported daily into Appian based on a scheduled time of process model. Currently we are using the sync record web service to manage this data transfer. However , we are not using any data base in Appian. we're concerned about the 4 million record limit of this web service sync record. What happens when the record count reaches to the 4 million limit? is there an optimal approach to manage this process in Appian to avoid reaching this limit or any best practices for managing large volume of data with Appian record sync .

We have created entity backed record using database table. That time length of column was 50 character later we update to 100 but source field is not taking 100 it still shows 50.Anyone knows how to update column length?

Good day experts!  I am attempting to merge two maps and have gone thru many examples from the forum but can't seem to get those solutions to work for my use case. I have two maps that have different key value pairs that I want to merge into one map.  The example in my code shows that the maps are related by participantId.  I was able to get the key and value for one of the keys in the queueMap to update into the participantMap.  However I am struggling with getting all of the keys and values in queueMap to update into the related particpantMap. Here is my successful attempt at just getting the first key value from queueMap to update into participantMap: a!localVariables( local!participantMap: { a!map( participantId: 3402, blockId: 881, policyNumber: "VF80U16350", policyEffectiveDate: fn!date(2023, 9, 25), dateOfBith: null, firstName: "Bill", lastName: " Johnson", middleInitial: "W", ssn: "123456789",

Hi,  Can some one let me know what needs to be done for the below error? System tried to sync on nightly basis and failed and didn't provide any details on the same. Tried to look into the sync history but it didn't provide any details. Note: There was not change in the data in the past day.

I have a grid based on record, this record has defined user filters.  The client asks me that when he selects a filter and clicks on the details of a case and then returns to the main screen, the filter selection is not checked. Is there a way to reset the filters of marked users without manual action by a user?

Hello everyone! I am having an issue with a write to records. "Escribir Cliente" is not updating the records accordingly. But if I execute it manually it works, or even if I put a input task after it works just fine. I also created variables in the ouput of "Escribir Cliente" to store the Error Occured and Error values to validate that there is not any errors. I even tried to save the variable on itslef again used to update that is why there is "Set Cliente" and "Set Id Cliente". Any ideas of what is this happening?  Thank you so much in advance!

I want to create a custom record field that converts a string timestamp field to date or datetime just to use it in user filters. I chose the real-time option but it seems something is wrong with that because when I tried with sync-time evaluation it works. This is the code:  datetime( left(ri!stringTimestamp, 4), mid(ri!stringTimestamp, 6, 2), mid(ri!stringTimestamp, 9, 2)) instead of ri!stringTimestamp I am using the respective record field

Hi everyone, I have a simple process model with a single node configured as Write Records Smart Service. This process model is used to update the status of each record in a process variable which stores a list of multiple ABC Client records. The ABC Client Record has the following fields: clientid, name, status. In the corresponding Event History record I have a field for comments where I want to have the following information: "Status of " & recordType!ABC Client.fields.name & " was changed to " & recordType!ABC Client.fields.status but I don't know how to configure it properly. When I try to capture the event history for each of the records in the list separately, I encounter an issue with the standalone Write Events feature of the Write Records smart service. I can not find a way to individually reference items in the records list being updated (i.e. just like we do in the a!forEach function when

Hello, I have added new columns in the views and updated CDT and published data store. However, when trying to update the record type I'm getting below error. Note: The updated fields are reflecting in edit list after resetting the list but getting error in preview.  Expression evaluation error at function a!gridField [line 51]: An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit.

We would like to use Smart Service to delete records from the DSE (Data Store Entity) and create records according to the input received from the screen.In this case, will the Delete and Write transactions be separated?For example, if Write after Delete fails for some reason, I would like the Delete transaction to rollback. Please let me know if there is a way to execute Delete and Write in the same transaction on Smart Service.

Not able to create a new Record Type from scratch in Community Edition I am unable to create a new Record Type with a new database table i.e. not getting "I want to start from scratch" option. Is it a known restriction or a bug? Community Edition: Standard Tier: Please let us know your inputs if any.

I created a view in SQL to calculate the age of a person.  MariaDB is formating the age field as a bigint(21).  I am connecting an CDT to this view and I need to know what the columnDefinition would be for a big integer.  I tried INT and BIGINT and that doesn't work. @Column(name="Age", columnDefinition="INT") I even tried to cast the calculated field as an integer in the SQL statement, but that did not work either? CAST(TIMESTAMPDIFF(YEAR, `CM`.`ClergyDOB`, CASE WHEN `CM`.`ClergyDOD` IS NULL THEN CURDATE() ELSE `CM`.`ClergyDOD` END ) AS INT) AS `Age`,

Here is the Problem There is a excel which having the data i want to create a store procedure that read the excel data and save this data to temp table. after that it save the data to main table. and after save into the main table, SP now truncate the temp table. can anyone write the code of SP and tell me how to use this SP in process model Thanks

Hello,  I'm facing the following task - I need to be able to generate a unique sample from a table/view. A couple of notes: This is a large table, about 25 million rows This table will need to be filtered first, then sampled To filter, this table will need to join on other tables, which is why I'd like select the random sample from a view instead of the table The random sample would need to pull from a relatively uniform/normal distribution (basically not skewed) This random sample will need to pull from live data - there cannot be a 1 day delay or anything This table is a CDT in appian, due to point 1 DB system is Oracle I don't just need a list of random numbers, but I need a sample of random PK IDs These are the things I've tried/investigated: SAMPLE() I'm not able to get it to sample on a View, it throws some sort of primary key error. People have also reported that SAMPLE pulls from skewed distribution of data and I'm hoping for something more u

While i am practicing, i created a record type and when i am trying to generate record event types , i am getting an error " You must have edit access to at least one of the applications this record type is in to generate event record types ". I read a similar content and checked the following, but there were no problems. ・Record Type is added to any Application. ・There are not Missing Precedents. I can generate record event types about 8 days ago, but I can't do it 5 days ago.  I saw an article saying that it was automatically resolved so I left it alone, but it hasn't been resolved yet. ・Similar Content community.appian.com/discussions/f/data/35375/generate-record-event-type/137648 If you know, I look forward to your reply.

I have a read-only grid that pulls the data from record type . I am trying to enhance the feature to add an update link to the page to enter new rows and thats needs to be updated in the Table .  Is there a way to achieve this without a CDT ?                                                                                                                      (or) Is there a way to update a table from the interface without a CDT?

Can we add icons or images on Record Title?