Data Fabric

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.

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.

First, please let me know if the following is correct regarding transaction control when using the Write to Multiple Data Store Entities Smart Service. If the same entity is accessed by multiple users at the same time, the update executed later will always take effect. I know that procedures can be used as a method to access tables (entities), but do you know if there is a possibility of inconsistency if a procedure and Multiple Data Store Entities have access to the same table (entity) at the same time. Is it an anti-pattern to also access by Write to Multiple Data Store Entities for a table accessed by a procedure? This is a question.

Is it possible to perform multiple inserts or updates in the Query Database? I understand that the method using recordTyoe and relation is recommended by Appian, but I am asking this question to achieve exclusive control of updates to multiple tables. I know that this can be accomplished by a procedure, but I would like to know if QueryDatabase can be used as another technique.

Can Delete Records and Write Records be performed in the same transaction? I would like to do a rollback if either Delete or Register/Update fails.

Hi, My team is trying to create a chart that warns users when an app is used the most. As soon as the user execute a process, we insert in Database some information (timestamp, typology, current user, etc). To generate the chart we use the following code: a!lineChartField( data: 'recordType!{2e39f6f7-a6b0-43c0-a1f2-39a16ddf112a}PGM interaccionesMotivosYCanales', config: a!lineChartConfig( showIntervalsWithNoData: true, primaryGrouping: a!grouping( field: 'recordType!{2e39f6f7-a6b0-43c0-a1f2-39a16ddf112a}PGM interaccionesMotivosYCanales.fields.{88cbc07e-c205-4ccc-8c3f-9245ea2bfbf1}timeStamp', alias: "timeStamp_hour_primaryGrouping", interval: "HOUR_OF_DAY" ), measures: a!measure( function: "COUNT", field: 'recordType!{2e39f6f7-a6b0-43c0-a1f2-39a16ddf112a}PGM interaccionesMotivosYCanales.fields.{dbcf9179-1efb-4c26-aac4-bc7c25fbded7}id', alias: "id_count_measures", ) ) ) The problem is when we use "HOUR_OF_D

In related action , after submitting a form ,the form must gets closed and it must enter details in db  but after submitting the form it is not updating the details in db and the form is not getting closed can someone please with this

I want to access sql result data in Custom Output of Query Database Smart Service, but I get an error. I would like to access the ResultSets, like in the Execute Stored Procedure Smart Service if possible, can I achieve the same operation in the Query Database?