Data Fabric

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?

Generate process Report which has process model stats, like process is errored out/completed , if process is errored out it should show the error in the report. Is there any way to achieve this in Appian, As we have a requirement to collect those data , convert to JSON and pass to an external application through WEBAPI?

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 ;)

I am trying to create a text column with properties from the user function inside a process report. I want to create a text field with "firstName lastName". I want to utilize tp!owner or the tp!assignees The user function is suppose to be compatible with reports but when I try to use it doesn't return anything.

 How to Download data to an Excel where a view has more than 150 columns?

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