Data Fabric

Data base table security or permission to query data from table, Do we actually need permission to actually retrive data from database table into Appian query entity/record?, what is the basic permission required...? ,

Hi Team,I have a requirement to export more than 100 columns of data into an excel file. Since we have a limit of 50 columns in export data store entity to excel, I am unable to achieve this functionality directly. Can anyone please suggest the approach of achieving this functionality? Thanks!!

I have record A and a record B on same source table but using different sync filters, all the DB writes and updates are happening through record A, so it is holding all the updated values, but record B is not getting synced to update the latest values.I tried establishing one to one relationship between record A and B, using same primary key, but still sync doesn't happen. Is there any other way to sync the record B whenever an update happens to the source table through record A?

Im using event history in my grid ,My event history data has more than 40 records which event type and pagination can be used.I saw the limitation of 100 records in full list Wif there are more than 100records how we can manage. When the user clicks the next page its not working.  Please suggest better solution for this scenario If more than 100 records needs to be displayed in eventhistory lis how we can configure. Thanks, Priyadharshini. S

Hi Dears, I am receiving Below Error while Viewing record data view All the Record Types. The Requested Record Type Is Not Available Expression evaluation error [evaluation ID = MFH3P] at function a!recordList: Type RecordType constructor passed 17 fields, but expected 50 fields (APNX-1-4198-000) Though the records are successfully crated, data is inserted in the table and no integrations in place.

I am not able to get the course or learning path for Appian Process Mining? Where can i get it?

We're using Appian 25.4. We have a ReadOnly Grid that gets it data from a Record, which has a DataSource of a Process Model. Recently, we added 3 new fields to a CDT used in this Process Model as a Process Variable (note this CDT does not get written to the database at any point), and updated the grid to include one of these new fields. Since then, when we export the grid to Excel, we get the error "Query has failed: null". Undoing the changes we made results in the same problem, which has lead me to believe it's a problem with the data in the process instances, especially as when we filter the data on the grid to exclude instances that have these changes, we don't get this error at all. The really strange thing is this error isn't consistent, as we've been able to export data that includes the changes we've made to the process model, the CDT, and the grid. Has anyone else encountered this particular error message?

Hi All, In our Test environment, monitoring tab is not opening. Getting 504 error. Also none of the record types are opening. Including the Maria DB Sync records. External record type(SQL) sync is failing & I was notified in email with below error. When I click view record type getting 504 error. A scheduled sync failed. The [X record type] is unavailable and cannot be queried. Review the sync history for more information.    Also When I query Appian sync record type(present in Maria DB), getting the below error. Expression evaluation error at function a!queryRecordType_24r4: java.lang.RuntimeException: java.util.concurrent.TimeoutException. I have tested external data source connection in admin console, which says Test successful. Does anyone ever faced similar kind of issue?

Hi All,I have record type which is configured as a service backed record using an expression rule that call an integration to an external system.Additionally, we have configured the schedule full sync at 12 am daily. I have few queries regarding this:1. Since the record type is service backed, does Appian store any data internally when the scheduled sync runs?2. will a!queryRecordType() always hit the external system even after the scheduled job runs?3. If data stores internally, does appian consume memory? if yes how much?4. If it hits external system every query, what is the recommended approach if we want to avoid repeated API calls and Improve performance?Any guidance or best practices would be helpful.Thanks in advance

As you can see in the images, if you use translations in a record field, Appian will not display the correct value, it seems to display the reference to the translation. Is this a bug or am I missing something?

Im having case table where using record data and showing values in grid. The requirement is to show the high priority data at first initial sort should be applied with condition of high priority records Can someone help me

Hello, I am currently working with a Grid-only view that includes sorting functionality. My goal is to sort records first by "Received Date" and then by "Priority" (High, Medium, Low). However, my "Received Date" is stored as a "Date and Time" data type, which makes sorting by date challenging because the time component (hours, minutes, seconds) is unique and affects the sorting. I would like to sort the records primarily by date and then by priority. To achieve this, I need to convert the "Date and Time" field to a "Date Only" format so that records with the same date can be sorted by priority. I attempted to use toDate() directly on the record type, but conversion cannot be applied directly. I also tried toUniformString(todate()), but it resulted in null values and caused issues with the UI. I don't want to change from the record type, and reset it to date only. Could you please provide guidance on how to address this is

Hello Folks, I have a case when data need to be sorted in one to many relationship.  For example: There is a grid where one column is not sorted because it has one-to-many record relationship. However, I cannot change the relationship. Can anyone guide me on this please? Thanks

Hi, Need help in below scenario. when a record sync fails for an instance, the record becomes unavailable. We have enabled the recovery option and the system applies full sync of all records. Is there an alternative approach to not let the record become unavailable/recover only the impacted record instance on recovery without triggering a full record sync? Please suggest

Hi Team,Is there way to get all the tables structure present in the appian db. I mean DDL queries for the all the tables present in Appian.Just exploring if this is possible or not, If there is a way to export all tables structure for creating them.Thanks in advance.

Hi All, I have self joined Record type. Write records plugin, smartservice both are getting successful, but persisted records are not  getting sync. Even though I manually sync, the data is not reflecting. See below What could be the root cause? Thanks Madhu

We display the groups a user belongs to in a read-only grid, and the data appears correctly in the UI. However, when a basic user exports the data using the default record export, the group names are not visible in the exported file.

I need to add more than 10 quick filters to the report, but the option is disabled. Is there a way to add more filters?

I am using a read-only grid to show data for reports. I need to export the data to excel but the grid has more than 50 columns. I have already tried default export to excel feature and a!exportDataStoreEntityToExcel() function but none of these worked. FYI: Data is in SQL. Appian version is 23.2. Columns cannot be merged or it's count can't be reduced Is there any way I can export the data to excel?

We have a requirement to delete data from multiple records ie., almost 30+ records. Seems like we can pass data of only one record type at a time while trying to delete using delete records smart service which increases the number of process variables. Is there any optimized way of deleting data from these many number of records ?? We are trying to query each record individually since the number of records to delete at a time can be high more than 100 which is more than the number of related records that can be queried.

Hi Everyone, I am working on an Editable Grid in Appian where the grid data comes from a Record Type (Employee Request). The record also has a relationship (requestDetails) which contains fields like categoryId, typeId, and referenceNumber. For normal fields (like department or location) I can update values using saveInto with the local variable and fv!index. However, when I try to update fields that belong to the relationship object, the values are not saved and I receive errors. Example dropdown: a!dropdownField( label: "Category", choiceLabels: local!categoryLabels, choiceValues: local!categoryValues, value: fv!item.requestDetails.categoryId, saveInto: { a!save( fv!item.requestDetails.categoryId, save!value ) } ) This results in the error: The save target must be a local variable that does not refresh on every evaluation, a process variable, or a node input... I understand that fv!item cannot be used as a save target, so I tried updating using loca

Hi Guys, what is the prefered way to create and use constants in an appian application. I have created the following record types "Order", "Order Lines", "Order Type" and "Order Status". The "Order" Record Type has an orderTypeId (Number - integer) and orderStatusId (Number - integer) fields and relationships added to these tables.  I have now created two constants called "CONS_ORDER_TYPE" and "CONS_ORDER_STATUS" which binds directly to the above mentioned Record Types. How would you use these two constants in eg. a dropdown list?  I mean, if you create a constant of type array and add text values {"Created","On Hold", "Fulfilled"} what is the purpose to create the "Record Type" entities for the constants (Order Type and Order Status) since you can just use the data type "text" for the orderStatusId and orderTypeId fields on the "Order" record type

Hi All, Greeting! We have faced this issue with one of the users. They are able to see the requests that they created. But when they are added as watcher for records, they are receiving an email with link from that link they are unable to open the record and facing this and they have necessary permissions as viewer in the respective group.  Could anyone please suggest any answer for this. Best regards, Kiranmai Palanki.

i Was getting this error in record sync Alert Details Could not sync because too many rows were updated in the source at the same time. To prevent this from occurring, limit the associated smart service or integration to not update more than 50,000 rows at a time. Process Name: [Not Available] Modified Source Rows By Primary Key: 49814, 49815, 49816, 49817, 49818 and mo