Data Fabric

I want to generate a table inside a word doc, below is the config of the smart service "Text Doc from Template": 

I need to make a record-like query for a 1 to N relationship, in which it only returns the values ​​of the parent record if all the values ​​in the N relationship meet a condition. Example : I have a record called "Need" and it is related to another called "needchangestate" through a relationship 1 to N, I need it to return only the needs where all the needchangestate meet a condition, if all the elements of the relationship N do not meet the condition, the element Need should not appear Currently it returns me an investment where the condition is met in at least one of the records of the relationship N but this is not what I am looking for.

I need to deploy a series of datatypes to another environment. So I deployed the datatypes and then the datastore, and overwrote the original. Now the datatypes I needed are on the new datastore.But when I go on with the deployment sending the rest of the changes to my environment, the Data store entities constants related to the datatypes I recently sent to my other environment give me the following error: UnresolvedDataStoreEntityException: entity [...] in data store [id=... uuid=...] cannot be found.help, please!

Hi, I need help understanding why record sync is not occurring when using the "Write to Datastore" smart service in one environment, while the latest data appears in the records in another environment. In the environment where sync is not happening, a manual sync is required to view the latest data. Can someone help me understand the cause of this issue?

Hi, I'm using Appian 24.2.270.0 and trying to insert an eventHistoryListField with comments in an interface , but when I click in the field for comments, the buttons appears like in the image here below.By clicking, the comment is inserted fine but why those buttons?Any solution?Thanks!

I want to change the field name of a CDT to match the renamed field in the database. The old name was "FIRSTNAME" and the new one is "FIRST_NAME". Related to the best practices, the best way to do so is to download the CDT as XSD, change the field name in there, and re-upload the XSD, verify and publish the data store as a last step or is there any other best practice thing? Thanks in advance.

Can I add hidden record fields if data sync is NOT enabled on a record type?

Hi All, Hope you all are doing well, quick question, is it true that using a!queryEntity can skip the Record Type synchronization? I'm facing issues in my application cause I have an after insert trigger that is inserting a record based on some conditions, but the new record inserted is not being reflected in the application until I manually click Start Full Sync, wondering how can avoid this issue. By the way the version that I have is 23.4 Any help would be greatly appreciated. Thanks in advance, Jose Castellot

Hi Team., I have made changes in the DB for the column size changes, but in the Record type is not getting reflected in RT, or is any modifications need to be done here. note: no CDT used in the application only RT. thanks.

User uploads the word file with number of screenshots to APPAIN using file upload component in an interface, but some of the images in the word file is missing and facing the blank space in the place of image, what might the cause for it.

Hi, Am unable to use aggregate functions on child CDT having many to many relationships with parent CDT. Background I have a parent CDT called Campaign which has many to many relationship with child CDT called Channel. I have Campaign table, Channel table and mapping table as well to hold the relationship in database. Requirement I need to group the Campaigns based on Channels. Issue I am unable to use Aggregate functions on channels field in my Parent CDT - Campaign. How can I achieve this using CDT relationships. Thanks  

Hi team, I am fetching data from database for KPI and the field names that are showing on y axis taking lot spaces can anyone help in this. Requirement: "New product Development" field   Name taking lot of space and  the field name is dynamic it may be 20 characters or 30 characters. How can I restrict space on y axis

Hi, Is there a possibility to connect Appian Cloud Database from outside. Thanks, Sadhu Surendra

I have Room (roomID column) and a Key (with keyID, roomID, and keyDescription columns) . A room can have multiple keys. I setup a one to many relationship between the Room and a Key using the roomID.  I used the Room record to populate a gridField. The search is not returning anything if I put an information that should match the keyDescription. I have the code below. I am only after for keys that are active which is one active key per room. Even if I remove the filter in the code, it does not return anything. Is this expected for a One to Many relationship?    { a!gridField( data: a!recordData( recordType: <room_record>, relatedRecordData: a!relatedRecordData(relationship: '<roomRecord-keyRecord>', filters: { a!queryFilter( field: '<keyRecord.isActive>', operator: "=", value: true ) } ), columns: { a!gridColumn( label: "Room ID", sortField: 'roomRecord.roomID', value: fv!row['roomRecord.roomID'], ), a!grid

I am using export DSE to Excel smart service, but the output data is not the full data the Table is having. I am having around 21k data in table where as the excel that was generated through the smart service is having only 20k rows.Are there any limitations for smart service?

Hi, We have a record type based on a service. Data syncs every morning 3AM. Today morning data synced well. We are using this data on a UI. The issue is, CaseInvalid on UI. When we look at the cause of it, we found the service is down. Is it mandatory to have the backed service up to use the already synced data from Record type to be used on UI? Thanks, Keerthi

HII'm trying to count the number of records in the data entity HVSDC_PlanesMejoramiento_Entity that meet a specific filter on the field CodigoSIRECISujetodeControl. This is the SQL query, which works fine: SELECT CodigoSIRECISujetodeControl, COUNT(NombreAccion) AS total_accionesFROM HVSC_V_PlanesMejoramientoWHERE CodigoSIRECISujetodeControl = '11745' GROUP BY CodigoSIRECISujetodeControl; This is the query in Appian: local!count: a!queryEntity( entity: cons!HVSDC_PlanesMejoramiento_Entity, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "CodigoSIRECISujetodeControl", operator: "=", value: tostring(ri!codigoSireci) ) } ), aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "NombreAccion", aggregationFunction: "COUNT" ) }, groupingColumns: { a!queryGroupingColumn(field: "CodigoSIRECISujetodeControl") } ), pagi

I have an endpoint which returns data consists of 5 columns (text and date fields). I want to keep an text field and then when I enter values in the text field, I want to filter the data based on the value I entered. It should filter dates if possible

I have an interface that stores the data in a record type, which has several fields. Once the interface is submitted, I want it to be saved in the database using a write record. And I get the following error: Unable to write to or delete from the source due to a data integrity violation.Error Details: Field 'Detalles_Trasladado' doesn't have a default value. That Field is not in that interface, but it is in other interface of the process.  How should I write the new record in the record type? Thanks in advance

HI,  I need to download a Ui page in site as a pdf doc, how can i achieve this. Eg:  I have a report in a page like showed above, By a click i need to download this page as a pdf.

Can any one explain how to generate PDF from reports with grid data.

I have a simple PM to write single record using a Write to record smart service. It has been working fine in our lower env's Dev and SIT. First ran into the below error after promoting this Pm to UAT.  Error: Unable to write to or delete from the source due to system error.Error Details: Invalid argument(s) in call I am pretty sure the cause for this is not configure the sequence in the Record Type(couldn't test/push changes to UAT yet) . Do you guys agree this will solve the problem? if not please share your thoughts.  if this is indeed the root cause of the issue, it raises a different question. How did this NOT cause a issue in our dev or SIT env's ?? Pm is working fine writing new records into DB with out sequence being configured in the record type in both the env's. Kindly shed some wisdom on this.  Note: 1.Exact same table and sequence structure used across ENV's. 2. Only non nullable column in the table is primary key. Thank

Hi everyone,  I'm not sure if you guys have the same problem as mine, but haven't found any similar topic in the forum... I am having an interface, which is using a recordtype as data source. The record type already had 5 user filters to be used in the interface.  Appian's recordtype based interface is currently providing a prebuilt feature that allows users to Manage Filters (Save/ Set as Default/ Reset filters), and we are using this feature to save some filter choices. However, recently I added a new user filter, and realise all my saved filters were removed from the filter tab. It brings quite an issue to some users, as they have saved lots of filters to customize their reports.  Have you seen this issue before? And is there any way that I can retrieve the filters back/ or prevent this issue when deploying the new user filter to PROD? 

I am trying to make a field unique by following these instructions - (source : 24.3 24.3 Case Mgmt Studio (CMS) Common Customization and Configuration Guidance) How can I navigate to the db table corresponding to CMGT_Agency? These are the options I see in source settings.  

In Case Management Studio, the due date utilities, objects and interfaces are dependent on the SLA field that is configured when creating a case type.  For my use case, I would like a user entered due date(from data intake form) to be set as due date( and connect to the calendar interface, show overdue message etc). What is the best way to achieve this? Similarly, I would like a user entered "Assignee" to be saved and used instead of the default field.