Data Fabric

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.

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.

Hi team, Is there any way to add personalized tooltip in google chart as it is giving information of the entire column, But I need the information of the hovered slice as shown in the picture. Also is there any way to add personalized colors for the slices? Any suggestions would be helpful. 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

Hello Everyone, I want to highlight the selected slice in column chart as below (as red color selected slice) on drill down selection. Any suggestions? Thank you in Advance.

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?

Hello Everyone, Can anyone help me with the Purpose of process reports?

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

Is there any way to export the data which is displayed in bar/pie/line charts defined in an interface data to interface (graphs) pulled from new version of record type. kindly suggest on this.

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.