Data Fabric

Hi! I´m having a problem related with data. The data in my record preview does not suit with the data in the cloud database. When compare my site (page created by a record list) and the admin console, it seems to be OK, but the record data preview is not equal. What can be happening? 1. Correct Data (Cloud Database) 2. Correct data (record list page of my site) 3. Incorrect data (the problem is that the second "idPedido" value is one that should not exist, I used it in previous ocasions but was deleted). It should appear idPedido = 2 It seems like the "Data Preview" is saving previous idPedido that were deleted What can I do? Thanks a lot *Extra: I added another row and same occurs. When I click in the table source (record-->data model --> edit data source), it also appears OK, but still wrong in the preview. I uploaded a pic in order to see it in an easy way

Hi All, I have a site which has home page. On Home Page we have a grid populated from Record List, when a user clicks on a record link it takes user to record summary. On record summary, we have record action which opens in the Dialog box. The requirement is that when user clicks on a button on this dialog box, he should be taken back to the Home page in the same window. Is this possible? any workaround or suggestions?

We are creating new Appian tables in a schema with a large amount of data (approximately 45 million) from Oracle DB. We are experiencing significant delays when connecting to the data source and configuring the record type. After selecting the data source, it takes approximately 4 minutes to load all of the tables in the schema, which I believe is unnecessary. We occasionally get a timeout error. Both the search and browse features work the same when selecting the source. Even if we can select the table and sync it, it takes a long time to switch between the record type tabs during development. Every button click takes some time. I appreciate any suggestions you may have.

Hi , I am getting this error while invoking a related record action ,which is not giving any info what could be the issue. Has anyone faced the same issue before, is there any way to trace it?

Hi all, I wanted to know about the best option for a query in static data on database. which would be the most optimal performance: "queryRecordType" or "queryEntity"?

Hi there, could anyone know when configure the "Export Data Store Entity to Excel"/"Export CDT to Excel" smart service, "Save in Folder" can only be set as the folders in Appian platform. Is it possible to export to the application user's local computer? Best regards, Lin

When we use Builders in interface , It will create Interface with rule inputs of given CDT or RecordType , I'm really curious to know how they creating variables dynamically(My guess is that they are running some java code in background) . As far as i know we can't create rule inputs dynamically ,If not correct me. Is there a way to create rule inputs of desired type dynamically??. I created a replica of Builders using functions like keys and runtimetypeof(), But i used local variables in value and saveinto parameters. I want to replace it with proper rule inputs.

Was the issue with Appian being unable to select the scheme in SQL server for recorded types/data stores resolved in 23.3?   Is there an ETA when this issue will be resolved.   This really slows down development on my team and makes appian much harder to use if you are pointing it to a database that has multiple schemes on it.  

Hi All, Scenario is we are connected to a PostgreSQL that has a custom data type, from which we we're able to create a CDT on Appian end and manage to verify it on our Data Store. for the custom data type on Postgre, we transform it to a text and it went well. However when doing a specific query to that specific field, thats where the issue persist. Can you advice on this? Data on Postgre Error when doing a query on the specific field

Hi! I have an interface in which the user can add new Rows. When the user clicks the "Completar creacion pedido" button, the values stored in my local variable are correctly passed to my rule input "recordLineasPedido".  I leave here my structured code: a!localVariables( local!LineasPedido, { a!sectionLayout( label: "LÃ%ADneas Pedido", labelIcon: "list-alt-solid", contents: { a!gridLayout( label: "A continuación, incorpore las lÃ%ADneas de pedido correspondientes y pulse el botón de creación", headerCells: { a!gridLayoutHeaderCell(label: "Linea Pedido"), a!gridLayoutHeaderCell(label: "Pedido"), a!gridLayoutHeaderCell(label: "Proveedor"), a!gridLayoutHeaderCell(label: "Material"), a!gridLayoutHeaderCell(label: "Precio Unitario"), a!gridLayoutHeaderCell(label: "Cantidad"), a!gridLayoutHeaderCell(label: "Importe Total"),

Hi All, We trying to connect to an external connection from another system. Though we are already connected, the tables we are looking for is not there. Upon checking, there are more than 2 schema available on their database, the schema that the tables we want is not the one showing on the recordType "choose database table" instead the other one. Additional Info, when creating a CDT and verifying it on Data Store, other schema and its table cant be map ( "no match table found"), however its verified for all tables under the schema that is appearing on recordType "choose database table" Can you advice if this support is on Appian Admin, or is it on the external side system to make the correct schema adjustment to be selected as default. Thanks

I want to redirect user to my interface instead of summary page. How can we achieve it? Below the screenshot from where currently i am redirecting user to record summary page but now i want to redirect user to interface.

I need 5 logical expressions inside the query record and each operator will have different values between AND/OR.

We have designed a process report to display tasks. We have added 2 process models in the report. The tasks of one process model are showing up in report but the other one is not showing up. But the task is showing up in tempo.Previously it was working fine for both. I am not able to find any reasons for this. Can anyone help on this?

Hi All, Can you advice  how can I map the "status" field with a custom datatype on the table to Appian CDT? I tried using the Text/String but when verifying on the Datastore, "No match tables found" - Data type on the Table - Creating CDT from Table - Error upon Verifying on DataStore

Hello, Let's say I'd like to sync a specific Record Type data from Production environment to a lower environment. Is it achievable?

I have a requirement where the user can select the 5 mutliple dropdown values,Sort for any one of 5 and operators for each value from operator dropdown and Gate operator (AND or OR). Ex: Employee Dept(dropdown) Sort On(radio button) Operator(dropdown) GateMedical Yes = ANDTransport No is null ORFinance No includes ANDBilling No = ORDelivery No in AND based on the user selected values I would required a query record with selected employee depts as fields in the filters with respective operators. Can someone please provide your valuable suggestions to write queryrecord. Thanks in Advance. [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05] [mention:2773a0b2dec7409a8eee377b9fc57b88:e9ed411860ed4f2ba0265705b8793d05] [mention:6b9f80ff18f9420082d13ef2d5121d56:e9ed411860ed4f2ba0265705b8793d05] [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05]

Hi Champs, I have a requirement where I need to do some customization with emp record summary view. Please let me know if those can be possible. 1) I need spacing between breadcrumb and the record title. 2)I want the color background for tab to be changed instead of blue. 3) I want the selected breadcrumb to be highlighted as black instead of blue. 4) The background color outside the content of summary and other page to be white instead of light blue color. Regards, Shyam

Hi all, I want to ask about the difference between "write data entity" and "write record". As an example, I have to store information in the database on 3 different tables, and I am using the  "write multiple data entity" option. which would be the most optimal performance in these cases, 3 "write records" or "write multiple data entity" with 3 transitions?

Hi All, I am using the cascading dropdown in the portal. A Cascading dropdown stores the ID in the database instead of the value I want to store the value in the database 

Hi all, We've created an expression backed record type, with the expression calling an integration to return the data. In the returned payload there are several fields which are return as lists (i.e. List of Text String), and these are not appearing in the record type and I can't seem to map them. Record type data model: Payload: As you can see, the list of text string names/ids fields aren't appearing in the record. Is there any way to resolve this?

Hi Appian Community, I have a use case where I'm using a record type as the source for a readOnly grid.  This grid contains both record fields and related record fields, and I'd like for all fields of this grid to be searchable using the out of the box search functionality.  Per appian documentation at https://docs.appian.com/suite/help/23.2/filter-the-record-list.html: When you hide search on the record list, the search box on the grid will use the default search behavior, searching across all fields referenced in the grid. The search box will also use the default placeholder text of "<Plural record type name>". The above described functionality is what was desired, so I went ahead and hid search on the record type while setting the "showSearchBox" parameter on the readOnly grid to "true".  However, the result is that related records fields with a one-to-one relationship are still searchable, but related records with a one-to-

My company's infra team is converting our internal MYSQL databases from 5.7.x to 8.0 since 5.7 is approaching End of Life.  With that comes a somewhat major deprecation of the utf8mb3 charset. We're formulating a plan that includes moving our larger VARCHAR fields to MEDIUMTEXT (and understand the implications with sync'ed records), however I have a few questions about some of the finer details related to Appian. utf8mb4 takes up to 4 bytes for storage instead of up to 3. When reading a VARCHAR field, does Appian always see the "maximum" size for a value when handling the 1mb limit? For example, does "asdf" under utf8mb3 count as 4 bytes or 12 bytes, considering that no upper unicode characters are used? When reading a VARCHAR field as part of a!queryRecordType, are there any differences between utf8mb3 and utf8mb4 as it relates to the 4,000 character limit on what's sync'ed into Appian? Any tips on successfully converting a VARCHAR data

I have excel sheet from which all data gets uploaded in db via smart service import excel to db but in record it is not getting updated immediately . I need to sync manually everytime to see the new records.Can someone please help me with this how to sync data immediately .

Hi,I want to create a process report in which I want to capture the process error information in a column , is there any way to do that?