Data Fabric

Hi! I was trying to make a security rule for my record (filter --> loggedUserName() = nomProveedor (one of my fields)), but in the security rule I can only put direct values or constants   I found out that there are security expressions, but how should be my structure to obtain a filter like the mentioned one? Example: Username: Proveedor 1 I want to filter the record so that he can only see the rows in which my field "nomProveedor" is equal to the Username Thanks a lot!

If I intend to use Rich Text for a field in an application, what type of formatting should the field have in the database?  Would a Varchar(4,000) work for example?

A record is created but getting null error for a field.  Checked the DB structure as well, the field nullable = Yes there

Hi! I would want to filter a site (record security) based on user conditions. When the user enters, I want to assign him a supplier name and a NIF, and then use this data interfaces to filter. Which would be your best-practice advices?

Please help me to display of individual item and it's count from a stock record type in the summary.Let's say there are 3 items A, B, and CBelow the Summary page, three individual tabs A, B, and C will be designed, when A tab is selected the particular item detail like item name, count should be displayed. Can anyone please help me how to achieve this?

Hi! I have developed a site and I want it to be filtered for each user based on its condition (supplier name). Basically, my idea is to use the site as a "Supplier Portal", so each supplier can only see its own Purchase orders and invoices. To be clear, I want this: - User 1 is the supplier 1 in real life. I want Appian to know that he is Supplier 1, and filter the records with this condition (in the record it would be nomProveedor = Supplier1) I have thought about the options but I would want your expertise and advice: 1) Create a record type (username - supplier), and use this information to filter the record (I have doubts on the steps to achieve the supplier field based on the username and how to put it into a filter/query.  2) Create a previous interface in which the user identifies himself with the supplier name (F.e. supplier 1) , and use this variable to filter 3) Create a group for each supplier and give permissions (it would be fine for 3 or 4 suppliers, but no

Hi all, I want to mimic my grid data in an excel report, the issue is that one of fields that I want to export is set to datetime in a DB and I want it to display AM/PM format in a report. Is there a way to convert datetime field for every cell in that column in a report?DB: Grid and conversion:

Hi Will it possible to filter the data without defining that column in record list means for example i have one column which has Boolean values as Yes or No  i have to define that column as filter in Record without defining that column in Record List. Kindly suggest in this

Hi! I´m trying to query a database which has: - A date field (month-day-year) - A number of days to add (integer) I want to use a query in order to add the number of days (integer, I want it to be days) to the date field, and return a date field.  I tried the following query but it doesnt work (returns null). And the function ADD_DATE is not able in appian. What can i do?

I have a record type which is not a synced type. It is referred using a CDT. I understood that synced records have better performance. I want to understand the difference between un synced record type and query entity, both are basically trying to fetch values from the Database. Can we use query entity instead of unsynced records?

I went thru the documentation and thought of increasing RTS count from 2 to 4 but looking for more info in terms of impact of this increment. We have 60 GB RAM and 4 CPU for the enviroment. Now Data server log file under ss folder is showing 9gb size and while starting up data server, CPU usage was 100% for few secs and some time in past it took 15 min to come up. In Appian Env, we have Record type sync and many columns are of 4000 char.  Will it be helpful to increase RTS count in this case to avoid any sync issue while bringing up the data server.

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