Records

Has any one done an expanded/collapse row grid within an expanded/collapse row grid.  I am looking at the https://docs.appian.com/suite/help/23.2/recipe-expand-collapse-rows-in-a-tree-grid.html#expression in the documentation and it look like what I am looking for, I just need a third level.  I am looking at creating a grid that displays primary customers, then expands to show those primary customers ship to's then another expansion to show the ship to's contacts.

Hi, We are trying to generate CSV with 1 million rows. But when we try to transfer files over SFTP, the file transfer fails. For less number of rows the SFTP transfer goes fine. What is the rows allowed for SFTP file transfer?

Hi All, We have only one rows in DB to sync using record type but record sync is failing with below error: [RecordSyncScheduler_Worker-1] ERROR com.appiancorp.record.service.BulkLoadServiceImpl - Error syncing record type with uuid: ******** com.appiancorp.suiteapi.common.exceptions.AppianException: Unable to sync due to a system issue. Issue identifier: ****** Caused by: com.appian.data.client.AdsException: APNX-3-0300-000: Unable to process the request: java.net.SocketTimeoutException: Read timed out We are getting this error in all cases whenever record sync is triggering. Like immediate sync, Manual sync, through system etc. And it is failing for all record type which has sync enabled. Also because of this CPU and RAM usage on server side reaches to 100% which in turn bring the whole server down. Does anyone faced the issue or if anyone has any solution to fix this. As we are stuck cause of this. Thanks in Advance.

Hey Everyone, Users in our Appian system are periodically unable to open records. It appears that the records themselves can be opened when using the same login account but on a different browser or incognito mode.Google chrome: Chrome incognito: Has anyone encountered an issue like this before? Thanks

Is there any way to compare two record values of different record type to find the difference and provide the result matched and not matched record

I have registered a CDT with @version columns available. When updating this CDT with OptimisticLockException using the Write To Data Store Entity Smart Service, the status of the Smart Service becomes "not attended" and the process stops.  Are you aware of a technique for handling an exclusive lock as an error when it is detected by Smart Service?

Hi,  I am using a Record Type, and it has years of existing data. Unfortunately, the active data is identified by the length of the column name "uniqueFieldId", which is a text value so there is no consistency. Note, this is not a primary key in the table. The active field length must be 5 characters long. Anything greater or less is not considered active. Since it has years of existing data, we do not want to insert a new column, as I was thinking the easiest solution would be run a sql inserting an isActive column and then running the filter on it.  Now, my requirement is to use a record type, and filter the data. I am unsure how I can use record filters to ignore data by the length of the characters in the uniqueFieldId. The record type is then being used in a readonly grid. A gist of the code below, the aggregation below is necessary as there are other fields and calculations I am doing using relationships to this record type.  In a gist, is

ID refId Title Status 1 10 Test1 Approved 2 10 Test2 In-Review 3 10 Test3 Approved 4 10 Test4 Approved How to write query filter to fetch refId=10 when status all rows should be Approved

Is it possible to delete versions of record type? I see in documentation version 21.3 that only web API versions can be deleted but in 22.2 release It include record type as well to not to delete versions. So, Also tell when 22.2 release applied ?

When CSV is generated from Excel, first row is being skipped. And a blank row is added at the end. Any suggestions?

Hi! I used to work with records, uploading the data based on a manual task in an interface (user introduces parameters and the record updates the info). However, I had to use a data store entity for an editable grid programmation, and I dont know if there is a chance to upload the record based on the data store entity. Thanks!

Table I want to query's structureDOCUMENT { docName docDesc color size priority } I have a list of {{ pickle.doc, blue}, { habenaro.doc, green}} I want to use to query the table with. Is there a way to do this in a single query? My list is of the form {docName, color}, none of these combos are unique.  I could get back 20 entries and still be fine with that solution.

I generated a view but I deleted one of the interfaces associated, creating another view and interface. The case is that now I cant generate new actions and I cant eliminate the previous view

Good Evening Appians, i have a student record type and a course record type and both works fine but the problem is, i want to pick the ID of the particular logged in student and attach it to an interface where it will save to the db on triggering the submit button. Please how do i achieve this ??

Hi All, I am getting a datatype mismatch erro when I am connecting and creating a fk from a pk from another table.Each and every confirguation is same for both the columns except the following: PK column is default none with auto increment FK column is default null  Can you please guide me on what mismatch I am missing as this is a usual case and easily implementable.

I want to add multiple columns from different tables to a existing views in Appian Cloud database. Can I use CREATE OR REPLACE VIEW for adding multiple columns from different tables to an existing view? can anyone provide sample script.

Hi Community, I am using webservicequery() function in one of my expression.It is working perfectly fine in our development environment. However when we have moved that Application to the UAT environment.We are getting below error:Expression evaluation error at function 'webservicequery': The WSDL cannot be processed because the remote server's certificate is invalid. Check that the certificate has not expired.   Can someone help me on this ? Is there any settings which I have missed ?I have verified the Expressions in both the Environment. They are exactly same even the User Name and Password.Regards,ABDUS SAMAD

Hi all,    While Data Sync Enable, Doing related action For Update query in the table by using the Write to data store smart service. I am getting data sync error as below screenshot. I have generated the related action by using "generate a Record action". but in documentation said that Immediate sync is possible by using write to data store smart service.But it is failing and returning error as below Thank you.

hi everyone we just have a trouble in data sync. we have created some record types from the database, but one of them failed in data sync. the status is "failed" in sync history. the detail shows "Alert: Unable to sync due to a system failure. Issue identifier: [e0bcc3cb-4961-443e-be9d-ced7237ae97c]". is there some proboble reasons for this trouble? Thank you all.

Hi all, I have a nice process model, let's call it ProcessModel_A The process model has a PV, of a CDT type. Let's call it CDT_A. This CDT has some text and number attributes and also contains an attribute which type is a second CDT, let's call it CDT_B: CDT_A:    name - text - no multiple    age - number - no multiple ...    moreData - CDT_B - multiple There is no database here, just the process models, and no Records, just CDTs. Please, bear in mind that the moreData is a list. I've created a Process backed record, RecordPM_A, of type ProcessModel_A. When I run a query on the process, like: a!queryRecordType (   recordType: RecordPM_A,   fields: {      [RecordPM_A.fields.moreData.CDT_B] ... when I query it like this, in the attribute moreData it keeps telling me that this is a list of text and is retrieving only the first element of CDT_B. Any idea on how to FORCE it to understand that the list of element

I'm having an issue currently where a single column, very occasionally, will revert back to null soon after it is updated. I set up a trigger that tracks when alterations are made to this column. I then checked all process instances that were running at that time and finally narrowing it down further by searching for PMs that were a depended of the database constant. I find that the only PM that fits the bill is the one that updated from null to 0 in the first place. I was wondering if anyone had experienced an issue like this before. Below are some pictures showing time stamps for when updates occurred.  In both instances it is updated back to null very quickly. The first 11 seconds later the second one within the same second. Anyone have an idea of what this could be?

Millions of data in query entity is possible to query for fetching data

How to add column in cloud database

What should be the best practices in terms of Record Type or Entity  if requirement is as per below- 1- Data structures has to have more then 100+ columns 2- Many attributes are of 4000 Char length Is it safe to use query entity instead of query record with above cases with the perspective that every thing is driven thru record type in future and most of the new featres will be based on record type.

I am using a record type to back some read-only grids via a!recordData. The grids both use the same record type, but with different queryFilters passed into a!recordData. Both instances need to show the OOTB search box, but I need to disable the "My Filters" view and the "Save Filters As..." feature to avoid users getting confused. Furthermore, the application of a saved filter as default will be applied to both instances of the gridField, which is something we must avoid. Is there a way to disable My Filters / "Save Filters As" while retaining the OOTB search box? Else I would need to build a custom search.