Records

This is the what i want , please reply . Thank You in advance.

I have data that is not fetched from DB.  The Data is in this format:  List of Dictionary - 2 items Dictionary id - 1(Number (Integer)) Max_days - 54 (Number (Integer)) Max_amount - 36671(Number (Integer)) Dictionary id - 2 (Number (Integer)) Max_days - 1317 (Number (Integer)) Max_amount - 15158 (Number (Integer)) What I'm trying to achieve is that I get the whole object that has the highest value for Max_days. So as returning result I should get  Dictionary id - 2 (Number (Integer)) Max_days - 1317 (Number (Integer)) Max_amount - 15158 (Number (Integer)) Can you help me, guys? Thx

Hello everyone! I created a scrip task to extract data from a .txt file and save it to CDT. However, my CDT also has a column to save the file name of the .txt file where I extracted the data. Is it possible to do it? If yes, can you explain how? Thank you.

Hello! We have Appian running with SQL server backend, and I want to find out where is user's first name and last name is stored. I searched all the tables but I can't seem to find it (I only see a table called dbo.usr, which only has the username, but no columns for first name and last name, and other fields such as Nickname/Email/City/State/Country/etc). Is this something stored in the database at all, and if not, where can I locate those data? Thanks in advance! 

The issue that I'm experiencing is that I have an list of dictionary's.The structure of dictionary's is like { date: 03/05/2021,  code: "113", amount: "0", id: 4001 }, - END DELAY { date: 01/05/2021,  code: "110", amount: "234", id: 4002 }, - DELAY { date: 22/04/2021,  code: "110", amount: "234", id: 4003 }, - START DELAY { date: 18/04/2021,  code: "113", amount: "0", id: 4004 }, - END DELAY { date: 13/04/2021,  code: "110", amount: "234", id: 4005 }, - DELAY { date: 09/04/2021,  code: "115", amount: "0", id: 4006 }, { date: 03/04/2021,  code: "110", amount: "234", id: 4007 }, - START DELAY { date: 18/02/2021,  code: "113", amoun

Hi, I'm trying to query an external data base using a!query function, like the next image. The Data Store have all cdt created from the third party credentials. I need know if i can use all appian objects normally with an external database.

Here, I have created a decision rule, My requirements are if I call this decision rule in the interface in the orgName field the tax Id and Address should be displayed. How can i configure this in the interface?

Hi there, In the SQL, we can use LIKE as the filter, but in the Appian, there is no such "operator". so in my case, I am trying to build a query to search a database by people's name. if using operator "includes" or "starts with" to search value "Michael", then it will return list of people, but if search value "Michael S", it will return nothing, but it should return some. in the SQL, we can use LIKE 'Michael S%', but dont know how to implement this in the Appian. Could anyone here can help to point a direction? Best regards, Lin

How a record type can interfere with perfomance? Thanks

Hello All, I just want to know how can I update a specific field to a specific index? example is I have 3 list of items, and I only want to update the 2nd index first name to "Jerry" and not "Henry". I tried to use updatearray() but its only updating the whole data or I am missing something?  { index: 1, name: "John", lastName: "Doe" }, { index: 2, name: "Henry", lastName: "Doe" }, { index: 3, name: "Jenny", lastName: "Doe" }, Looking forward to anyone reply. Thank you!

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.

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?

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!

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