Data Fabric

Hi  I am using query record to fetch data from the database.Whenever i am using  query record to fetch image , its giving this error. I am using this code to get the image displayed on the interface: a!imageField( images: a!documentImage( document: todocument(index(ri!employee,'recordType!{89956f33-9ae6-45d8-9fb3-c45b6cc5877c} Request.fields.{87357f56-96ee-41b0-a7db-1972b5ab8161}imageid',null),) ), ), Its giving me this error: Could not display interface. Please check definition and inputs.Interface Def inition: Expression evaluation error at function a!imageField [line 4]: The image at index 1 in an image gallery component [label=""] has an invalid value for "document". "document" must not be null.

Hello, In our project, I have created an interface that has a file upload option. When I used that interface at views of some record file upload is not working. However, That interface is working fine in Appian designer and as a start form for process models at other places. Is it possible to upload files from interfaces used in views of a record? FYI, we are using this record on a site. If it is not possible, Kindly suggest any work around for it. Thanks, Shikhar

Background: In my application there is a simple paging feature that utilizes a server side application to retrieve data for each page of a grid that needs looked at. Upon receiving a response from the server, the onSuccess callback of the startProcess function that is called will use an expression rule which matches the data returned with data found in a view on the appian cloud db. This matching is done in order to alter one column of the data to fill it in with task Ids when one is found in the db for the given data row. Problem: Creating a new task works great and a task Id will show properly in the grid. Paging works great and existing task Ids will show properly. The issue is found when a user creates a task, navigates to a previous page, and then returns to the page where the task Id was. In this case the task Id will not be found. Walkthrough: Scenario 1Navigate to page 3, making previous page page 2create task, task Id showsnavigate to page 2navigate to page 3task Id is go

Hello Everyone, I had a requirement where I had to read an excel file and populate that excel data in a CDT (let's call it example_CDT) for displaying that data in an interface.  I did that and now the whole data is there as a list of items where items are of type example_CDT.  This CDT is already mapped to a table in the DB.  Now, I want to generate and download SQL queries that can be used to insert the data which is there in the list of CDT into the DB. Is there any Appian smart service available through which I can convert get SQL queries from CDT data? please consider example_CDT as a Nested CDT.

Hello I have a requirement that I need to create an interface to show some filtered  process history. An example would be to show all email, and user input tasks that have been run for a particular process. Any ideas on a solution to grabbing this info?  I see process reports don't seem to access this data. Thanks!

I have a txt file that i want to parse and convert to appian value. What do i use for this? Thank you. P.S. (readTextFromFile() was the previous function for this but was already unavailable in the current appian version)

Hi, I am new to Appian and in learning phase. I would like to know how do I treat empty resultSets while using using a!forEach  combined with a!queryEntity My requirements: Query a table When there are no results, return false  If there are results, iterate the results and return if the result set contains non blank items of a column I had added an if condition in a!forEach expression. I am using fv!itemCount>0 condition which works fine only when there are valid results. it is not going into the false block when the resultset is emtpy. How do i check a!queryEntity returns an empty entity/ data without any results? Your help is much appreciated! Please ignore any typos/syntax errors on the below snippet.  load( local!localCollections: a!queryEntity( entity: cons!MY_ENTITY, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "myPK", operator: "=", value:6 ), ignoreFiltersWi

Hi Team, We have a requirement to upload a file, read data from it and display the data on a button click in an interface. We have tried this in a two-step method by orchestrating this in a process model: 1. Uploaded the file using "fileUploadField" component and submitted the form. 2. Reading data in script task and navigating back to the same interface. But here the drawback is until unless the form has been submitted the file won't store on Appian KC so we can't read it. Also, the user has to perform two actions 1. upload the file and 2. click on the "Import data" submit button. Find the below image for reference.   Is there any way to implement this task with a single click? Thanks in advance, Mahesh

How I remove a view from my record? I cant seem to find this anywhere. Something is wrong about it and I cant even find the "Generate Interface". Thanks 

I am trying to make a table like below, how is it possible to merge the common URN no. for different customers? Can you please provide me an example?

Hi everyone. I'm with a problem with a property returned from a a!queryProcessAnalytics from a Report. The Report returns this data:   And I have a problem with a dp0 field that is mentioned on the column configs as the task details: I get that field in this way: And I put all that data in a grid on an interface, but sometimes I get this error: And I show it like this on the interface: Thanks for everyone who can help me with this problem!

Hello Community,  We have a requirement to monitor the maximum number of user sessions on a day in the entire environment. is there any ready made plugin available for this? Im aware that we can use login audit csv file. But this file can give only the number of user logins on a day rather this file did not furnish the details about log out for the same user.  TIA

I want to import the excel sheet data into the table using the Import CSV to Database smart service but I'm getting the outputs that Invalid column name: First Name . Can you help/suggest on how to provide the column names?? Thanks inadvance.

Dear Team, Interface error : document does not exist or deleted error appearing. We have document id with us , todocument(docid) is giving us document name , but the same same documentid when we are passing to document() it is throwing the same error. We are also not able to search document in objects using doc id. Any idea ?

Hi all, I am using a view as the data source for an entity-backed record.  I have a field "Student Full Name" in the view, which I am getting by concatenating "Student First Name" and "Candidate Last Name" using the function concat("studLastNm", ", ", "studFirstNm"). So, for example, in the view and record the student full name will be displayed as "Brewer, Allan".  There are no null or empty values in "Student Last Name".  My CDT for view has primary key.  When I sort the view for "Student Full Name" in the cloud database, the values are getting sorted properly.  But the same in the record gives the following error: The alias [[field=STUDENT_FULL_NM, ascending=true]] cannot be used because it contains illegal characters. The alias must contain only letters, numbers, and underscores, and must start with a letter. (APNX-1-4203-009) Does the record sorting no

Hi All, We have entity backend records based out of DB view and using a!recordData in the grid to display the record list When a user uses a record search bar to search a keyword, we are getting errors ""An error occurred while retrieving the data for "Record Name". Details: unexpected error executing query" . Looking at the logs, we figured out keyword searches against all columns defined view it impacts query execution time. This issue occurred recently as the volume of data increased.   Is there any way to customize or pass a minimum number of the query filter in the record on the search bar? Currently, we are also working on the DB view optimization.

I have a synced record with a database table. I can successfully write new data to the table using the "import excel to database" within a process model. Unfortunately, after uploading new data the synced record is not updating. If I manually sync the record it will update correctly. How do I ensure the data is synced when I upload new data? According to Appian Documentation the record is suppose to automatically sync: "To keep your synced data up-to-date with the source, an immediate sync occurs whenever Appian writes to the source of your data." https://docs.appian.com/suite/help/21.2/Records_Monitoring_Details.html Additionally, I've confirmed that Sync is enabled:  Any thoughts or suggestions is appreciated.  Thanks!

We have a requirement to produce a stacked column chart that displays a count of completed requests split by how many working days they missed the SLA date by (e.g. completed within SLA, competed 1-2 days after SLA, completed 3-5 days after SLA, completed >5 days after SLA). Our table stores both the SLA date and the completed date so we have the data but there doesn't appear to be an easy way to calculate the number of working days between the two (so ignoring weekends and bank holidays). We had initial created a view and used the CASE operator to define a column that categorised each request as Within SLA, 1-2 days after SLA, etc., but this does not take account of non-working days so is not acceptable to the business. A search has discovered several database solutions that rely on creating and populating a calendar table that includes all the days of the year and whether they are a working day or not, but that solution relies on that table being maintained and updated wi

Hi, I would have a question about a refresh aspect. I have an interface (let's call it "Form A") displaying many sub interfaces depending on many conditions. In one of theses sub-interfaces, there is a RecordType grid and for each line I've set a RecordAction (called "Edit row") that triggers a process. (The user has to make few clicks on different components to see that grid)  When the user clicks on this row RecordAction, it triggers the process which displays a start form Interface (let's call it "Form B"). This "Form B" interface has 2 buttons "Cancel" and "Save" (I've set submit = true for each one). When the user clicks on the Cancel button, the process simply goes to the end node (XOR step decision is used). If the user clicks on Save, the process store data in DB and end the node. My question is :  When I click on the cancel button of "Form B", how may I do, to havin

In my Appian cloud database, I need to figure out what type to list for my resume upload field. In my database I have a blob so what do I use in Appian? I cant use a text....

Hello All, I have added readable grid into an interface and linked the record to this interface which will provide me all the fields of the record. In the record user filter option available part of the a!gridfield. In the record I have enabled set showSearchBox to true which provides us with a global search option. But I have a requirement to add filter for text field for example, Iike CustomerName The version I'm using is 21.2, any alternative way to achieve this? Thanks & Regards Girish

How can I remove accent (replace special character) from the text  Input: "Cámara" Desired Output: "Camara"

Hi all, I have created a entity-based record type which is based on a view.  I have created a user filter in the record based on a!recordfilterlist function. The user filter does not give correct result.  The field on which I am using the filter has null values in the view.  Can someone help me to fix this ussue? Thanks in advance.

Hello.I am creating a column chart that shows me the companies created in a period of time, this part is done. But now I need to create an average line in the report that shows me the average number of companies created in a year. It is possible to do it in Appian, I am new and I do not know if it can be done. 

While creating record type, why we create additional views except summary view in record views?