Records

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.

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 .

I am tasked with mapping data to a docX to generate a pdf. I have most of the data mapped properly, but I wanted to know if it's possible to generate a pdf download of a record list or read only grid. Is it possible to print off the entire record list? Mapping data to a pdf requires that you know how many fields you need to populate. How can I generate a pdf that has a dynamic amount of data?Thanks,

The problem statement is: To create a username for a person by joining their Last name and first letter of their First name. Following is the code: a!localVariables( local!userList: { "derek.romeo@gg.com", "gloria.juarez@gg.com", "pearson.vue@gg.com", "stefan.price@gg.com" }, local!names, local!result, { a!forEach( items: local!userList, expression: { append(local!names,tostring(reverse(rdrop(split(split(fv!item,"@"),"."),2)))), local!result:{ index(split(local!names),";")&index(index(split(local!names,";"),2),1) } } ), } ) This code is throwing the below error: Expression evaluation error at function a!forEach [line 13]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function 'split' [line 18]: A null parameter has been passed as parameter 1. When I run the code without lines 17 and 18, I get the below result: List of Variant - 4 item

Hi All, I want to create ERD Diagram for my Database schema in Appian database. What is the best way to do this? Regards, Ghanashyam

Hi all, In my record type I have a related action, this I am triggering from a UI grid column. The related action points to a PM that performs operations and has no UI associated, but as soon as I hit the related action I am getting a white dialogue box, as if there is a UI in the associate PM, and then closes automatically. Usually if there's a UI the dialogue box would make sense, but why is it coming in my case. It could create a kind of confusion if a UI is coming into picture. Is there any way to disable the dialogue box other than selecting its size?

My app is built on an Oracle Database. Would it be possible to overcome the 4000 byte of Text limitation we have for Synchronized Records fields? I know the VARCHAR2(4000) limitation is considered to be a standard column type by Oracle, then choosing the EXTENDED for param. max_string_size in the DB would make it an "extended data type", as CLOB is. But since CLOB is forbidden to become a Snyc. RT field, would my large VARCHAR2 columns be also forbidden? Asking for people who tried it. If no one did, I will ask the DBA, but could be easier to ask here ;)

We have configured a service backed record with full sync configured. We also have a use case of syncing the changed records after the put call of that service is successful. In the put call process model, we have used Sync Record smart service and have passed the identifier into the node. Our sync expression uses token as an authentication to the service. This configuration works smoothly in dev environment. After deploying the code to QA environment using a Deployment Admin account , our sync record smart service is failing. The error is of failed authentication. (To cross verify, we passed the same identifier to sync expression manually and it returns the row) The Deployment Admin does not have a valid token to successfully call the integration. To resolve that we have configured the smart service node to run as whoever started the process. Even then the sync is giving error of authentication. We checked in System logs and even there we didnt find any additional information apa

Hi All, I tried to use a!queryrecordtype to query a process backed record and am getting result. When i tried to put ".data", am getting below error. Any idea on this error? Thanks in advance

Hi Champs, I have a use case where I need to execute an action/process Model to update a column in a database table on user entry to a record view. It should be automatic. There is no user interaction required for this. Is it feasible? The functional use case is ,I am showing the alerts to the user in summary page if there is any message in history log table. Once User click the History log tab, I have to make all the unseen messages to seen automatically. To Better explain, I have two views in my record which is Summary View where I will show the alerts to the user if there are any new messages and the other is History/log message View. Regards, Ghanashyam

Dear Community, We encountered an issue recently regarding disk space, where it reached its full capacity two days ago. Upon further investigation, we identified a timer that was causing file duplication, leading to the storage becoming full with over 1.6 million files. To address the situation efficiently, we attempted to remove the entire folder (Knowledge Center > Artifacts > folder xyz) instead of deleting individual files. However, we are now facing a challenge as the "artifacts" folder is displaying 40GB of consumed memory, while there are only five files totaling 200KB in size. Despite our efforts, we have been unable to locate any hidden files or identify the reason for the excessive storage consumption. We are seeking guidance on how to identify the root cause behind this issue and optimize the storage usage effectively. Thank you for your support in resolving this matter promptly

Hi Champs, I am getting a strange behavior when calling a record view from a site, it's not showing the breadcrumb as highlighted below when called from in site. Instead it is showing like this without the breadcrumb. Am I missing something while configuring in site.