Records

I have a requirement to show a record with a hyperlink in excel after exporting to excel just how we show in a grid with record link. After clicking on this link in excel it should open this record. Is it possible to implement?

I'd like to populate a dropdown with all users in our Active Directory but do not need all the users in Appian. I've seen some threads on Azure AD but mostly to do with SSO which isn't the case here. Just would like data to be populated based on that Directory.

Hello everyone, Can anyone suggest how we can use userfilter in column chart? I am fetching data from records in column chart. However, filter is not working. Please suggest. Thanks

I'm trying to get a rudimentary understanding and example use case for the use of the targetLocation parameter in a!recordLink(). I've read the documentation but I still can't picture a use case. I've played with it in terms of configuration. I'm just not sure why someone would need it. Has anyone every used this parameter before? What was it used tor? 

HI, I have a question regarding the Filters.Like I have table of name Employee and it has column -ID,Name,JoiningDate and LastDate.So Is there any way to count the number of working days of the emplyoee and show on the Interface in the records.Using filters as well,

Hi Team, While querying the data from database I am Geeting error msg like I have given batch size 1, -1y, I want to retrieve all data from database view table(6500 rows) Can you please help me on this. Thanks, Nag  

Hello, Could anyone guide me how to create record type from View table? Thanks

I have a list, how can I do something like what pagingInfo does? I want to pass in batchNumber and batchSize and get the part from the list. The list is not queried from record, it is from an api response, but the api response was not paged. I was blocked when I tried to create a record type using this api, so I was thinking maybe I can page the response in recordDataSource file. Is there any other ways that I can do this without changing the api?

Hi team,  I'm planning the architecture of a new Appian Project for a new customer. The customer needs to know what are the tradeoffs of choosing the native appian cloud database (MariaDB) to store business data vs the own customer's database. I know that exists some information about it in the documentation but I would like to know more about your practical experiences on it. Thanks.

Hello all, I'm getting an error "Expression evaluation error: [XXX - Record name] must be indexed by its corresponding record type fields or relationships (APNX-1-4291-001)" while I'm trying to get the 'Summary' for a Record from the Records 'List'. I configured a view to list all the records and when I click on any particuler Recor from the list, it should show the Summary for that Record. Using the following code for recordLink: a!recordLink( label: fv!row[record.numberValue], recordType: record, identifier: fv!identifier ) Appreciate your help in getting a solution of this error. Please let me know if you need any other details, thank you.

In database view has been created by combining many tables and it shows the results properly. When we use a!exportDataStoreEntityToExcel function to extract the content it fetches only 22k instead of 24k which is shown in view results. Is there any limitations on the extracting content except the column count 50 (ours only 25 columns)?

I have a use case that requires keeping the API response in CDT and the API response would have more than 150+ fields. It's only for keeping the values in CDT and we are not storing/retrieving them into the Database.? These changes impact any performance and data break into our system. Also, provide your regards regarding these changes.[mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05]  [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05]   [mention:92ac9d4559ff43edb28eaa01ed77691b:e9ed411860ed4f2ba0265705b8793d05] 

Hi  i am trying to filter the createdOn filed with both data and time Example : I need to get data from 16-04-2024 1:00AM to 16-04-2024 2;00AM can any one help me how to implement this ?

Hi Champ, I have Record which is having one to one relationship with one more record type. I have enabled the checkbox which says write or delete related record. It is behaving in a very awkward way.  So, my Use case is having a milestone. Where I can save my data as a draft. If I save the data as draft by filling both record data, it is writing data in both table without any issue by using the foreign key. But when I saved as draft without filling related record data and 2nd time in filling in , it's giving error as unique constraint violation. So to give more explanation. I have a table A having activityId as primary key and auto incremented. I have a table B having  activityId as Unique key and a foreign key to table A activityId. Scenario 1 If I fill both table A and table B data initially and saving it..It is working fine and writing data to both table. Scenario 2 I am filling info which is part of only in table A . then data is writing fine in Table A

Hi! Does anyone know how can I fixed the next situation? I want to get the date of a datetime using the function todate() but if the datetime is after 9PM (Chile Time), the result for the function is not the real date but the next day and this should only happens when the time is past 12 AM.

I have two user filters in record, is to possible to hide and show second user filter based on value selected in 1st user filter. For example in the below image I have two filters named 1) FEEDBACK and 2) APPOINTMENT DATE,  FEEDBACK filter had 2 values Good and Neutral, Is it possible to display the Second filter(APPOINTMENT DATE) only when we choose Good in the FEEDBACK filter?

Hello Everyone, I am working with record type. There is a requirement to prepare record type using rule input. This is the logic I am using: a!forEach( items: ri!reminderInfo, expression:fv!item['recordType!{e5a6a458-a1b1-4679-91c9-944cecdfdac6}AMS_DG Appointment Reminder.fields.{5515212e-0535-40f5-aa3e-1d92c83c23ca}appointmentId': index(ri!appointmentInfo,'recordType!{5746f330-8c31-4ea7-9807-cbbd2fd557eb}AMS_DG Appointment.fields.{274539be-ac91-4f4c-95ed-69bd50175dae}appointmentId',null), 'recordType!{e5a6a458-a1b1-4679-91c9-944cecdfdac6}AMS_DG Appointment Reminder.fields.{e7f92751-d0c8-4ce6-a252-2bd4b3bee143}createdBy': index(ri!appointmentInfo,'recordType!{5746f330-8c31-4ea7-9807-cbbd2fd557eb}AMS_DG Appointment.fields.{9cc0bbe6-dc99-4b3c-bf8b-e70e36fbbbb0}createdBy',null), 'recordType!{e5a6a458-a1b1-4679-91c9-944cecdfdac6}AMS_DG Appointment Reminder.fields.{82394d77-2331-4196-9d8e-3aaaf57888a3}createdOn': index(ri!appointmentInfo,'recordType!{5746f330-8c31-4ea7-9807-cbbd2fd5

Hi everyone,  I have seen 2 posts with same error but didn't find any solution that works for my case.  I have created a view, and a record type with data source is an expression rule that query data from the view. The rule will return me below data subset. When I check the record list, I can see data being presented without any error.   However, when I create a gridField based on my record type's data, I got this error. I checked and can verify that my data don't contain any duplicated row. Is there any other reason that I should look at? Thank you,

Hi  I am trying to write data to a table using write to datastore entity . In production environment, some of the instance is not working as expected. Nodes are getting executed successfully but not writing in db. If i restart the particular node it works. Anyone faced this issue? What could be the issue? Please help. Thanks in advance 

I have a one-to-one relationship between the Loan and UCC Information entities, and I'm trying to add the same relationship from the Loan record, but it doesn't recognize the FK (Only displays entity's PK) from the 'UCC Information' entity for some reason. Any kind of pointer will be  valuable!                                                           Loan Record Relationship Snippet                                                                                       ER Snippet 

Hi All, Currently the Appian OOTB record feature doesn't provide the progress of export. Once we click on export option there is no response for some time , after few seconds the document will be downloaded. There is no way we can show to users that document has been downloaded or at least the progress of download. Does anyone have any alternate hack/solution for this? The excel tools or any other plugins will show the progress option in browser tab, but we would like to use record export. Thanks, Karthik

Hi All, We have a new project coming up, it is expected to have almost around 600,000 records being created in a year. We have one existing application with let's say around 100,000 records using entity backed synced record. My concern here is that existing application performs very slow with 100,000 records and most of the times export to excel fails also with 20,000 records to be exported now if we talk about 600,000 cases I am not 100% sure to use Appian OOB records.  I know we can create different records based on the personas and default source filters to make it work but what if customer wants to see all the records? What could be the alternative approaches to deal with this? Thanks!

An error occurred while evaluating expression: =repeat(count(pv!ordersId), pv!invoice.id) (Expression evaluation error at function 'repeat': Cannot repeat list type) (Data Inputs) so I having many to many relationship names as invoice to ordersId so while mapping data into CDT using repeat function I am getting this above error I want to store 2,1 orderIds  within same invoice 

Hi all, we have a record based on a view in an oracle database. Some day ago we delete some data from the tables from which the view get the data and now the view has 253 rows, but if I open the record list we found 11583 rows. How is it possibile? With this scenario the record should execute the query every time we open it

Hello, I have a field for mobile numbers in my Appian application, but it is in text format instead of integer. Appian does not support 10 digits as an integer, so I cannot change it. I need to sort this mobile number field on a read-only grid, but it is sorting as a string due to the text format. I need it to be sorted as an integer field.