Records

Hi everyone, I have a database view that contains a total of 62 fields. Most of the fields are empty except for the first few fields, some fields in the middle of the view, and the last two fields. It is crucial that the order of these fields cannot be changed. I'm creating a process that returns the data from the view to an Excel file. I'm using the smart service "Export Data Store Entity to Excel", but it has a limitation of 50 fields, so I cannot export all the fields to an Excel file. As a workaround, I have tried the following: I split the CDT that points to the view into two CDTs (each with half of the fields of the view) and linked two "Export Data Store Entity to Excel" nodes. The first node generates the Excel file correctly from cell "A1" to cell "AE1". I pass the resulting document as an input parameter to the second node in the "Document to Update" field. Additionally, in the second node, I use the data store enti

Hi I am trying to create a small application related to Internet bill tracker. Here user need to update few details and need to attach internet bill file of the particular month. So in Interface I have added few components like Bill amount, Month of the bill, uploaded by, File upload etc.  To store the uploaded files I have created a folder in my application. I have consider a local variable (local!file) as local file and the value is saving into local!file. While filling the form I am able to upload the PDF and same is stored in that Particular folder. But in Records I'm unable to get option to see that particular file and also Admin need to download the same PDF from the record section.  Please help me to resolve this issue. 

Scenario: I have a record like below: Container Record which has fields like id, caseId, claimsId, providerId and these 3 fields point to primary keys of 3 other records Case, Claim and Provider. Whenever an entry is made in Case an associated entry is made in Container for fields id and caseId Whenever an entry is made in Claim an associated entry is made in Container for fields id and claimId Whenever an entry is made in Provider an associated entry is made in Container for fields id and providerId At any point there would be only 2 column in Container which would have values. On Container we also have added custom fields to fetch other data fields like summary from Case, Claim, Provider and each of these 3 records have summary field We are using realtime custom field using customfieldmatch to decide which related record should be used to get the summary field for the custom field by looking at which identifier is not null. a!customFieldMatch( value: 'recordTyp

Currently, we have the database time set as GMT which is four hours away from the Eastern time zone. We are running into issues with Time based search and bots processing of cases for a certain day since the server time is different. 1. Is it possible to update database tiezone to EST? 2. If we updated to EST what will be the impact of Existing application?

Hello, I'm getting this weird whenever I pass in the rv!identifier of a record  Here is my related record action below. I'm only passing in the rv!identified which should be stored in the corresponding rule input ri!projectPlanId When I pass a test (i.e projectPlanId = 82) the interface works like I want it to. But when t is passed through the related record action, and test it through the site, the error persists.  is there a typo I missed or am I missing something more complicated here. Isn't the interface supposed to take in the rv!identifier, which I know is a number. Or am I messing up somewhere else? If anyone likes to see snippets of code, I'd be happy to provide some. Appreciate all the help!

Hi. I am having issues creating a new recordType with the below code in a editable grid. Things of note 1. mouId is a foreign key in the record. 2.The primary key id is set to autogenerate. addRowlink: a!dynamicLink( label: "Add Risk", saveInto: { a!save(local!data, append(local!data, 'recordType!{3575b740-8740-41f7-83b5-1f1ed66f6a1a}DSC01_Risk'(mouId:ri!mouId,updatedOn:today(), updatedBy:loggedInUser()))) } ), Error code: "Interface Definition: Expression evaluation error [evaluation ID = 8DQ5R] : An error occurred while executing a save: Expression evaluation error at function 'append' parameter 2 [line 116]: Keys must be record field references or record relationship references"

hi  in the abov out put only role tasks were diffrent  so  my requrement here is i want the out put -------  group by comment_id ORDER by created_on DESC.

Hi all,We are using export to excel default functionality for exporting data from record. We are using priority column as initial sorting field. While exporting to excel, for some users its getting sorted with priority and for some users, its getting sorted with id. What could be the reason for this behaviour? The only difference is for user whose excel is having id as sorting, they can see all cases, while for others, they can see only particular cases due to record level security.TIA

a!columnChartField( label: "2012 Tempo Usage Trends", categories: {"2012", "Qt 2", "Qt 3", "Qt 4"}, series: { a!chartSeries(label: "IT", data: {9, 4, 3, 2}), a!chartSeries(label: "Human Services", data: {8, 3, 2, 1}), a!chartSeries(label: "Sales", data: {12, 6, 4, 2}), a!chartSeries(label: "Marketing", data: {15, 7, 3, 5}) }, colorScheme: "SUNSET", xAxisTitle: "Quarter", yAxisTitle: "% Active", showLegend: true) Can we get this column graph with record centric feature

We have a requirement to see the cases on dashboard based on some criteria.  This criteria is defined in a table called user access details. Details of all the cases are present in one record. How can we apply these user access details values as filters inside another record to get the values?? Note: For a single user, there can be multiple user access details, so there will be multiple rows. Each row need to be applied as filter to the record. Screenshots have been added for reference. First image refers to user access details, second one refers to data table When User A logs into Appian, they should see only caseid 1001, when user B logs in they should see only case 1003. How can we achieve this using Records?? We already tried using record level security, but here we can define only static values. But, in our scenario we need to define dynamic values which will be varied on logged in user.

Hi there, I wanted to understand what the differences between these 2 are. Data fabric seems to be relying on record object for what it does (from self-service analytics to AI Copilot, please add if I missed on any other offering), and hence would share the same limitations too? As for unifying data across different systems, that's something record has been doing for some time. So, what exactly does DF offers besides SSA and Co-pilot that wasn't already offered/done through Record object?  [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] [mention:b8ea18cfbb2e4f6d841cf3c1d4d7420b:e9ed411860ed4f2ba0265705b8793d05] [mention:f5e81b8502fa4e77ad12697686a4fc56:e9ed411860ed4f2ba0265705b8793d05] [mention:dea33493db6342c9a73dc108d45120c0:e9ed411860ed4f2ba0265705b8793d05] [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05] 

Hi All, I recently came across this issue while using the write records smart service to update a single specific column(eg: textCol} for an existing record. I'm using the recordType constructor to specify the primary key value and using a pv value for the other column. So my input to the write records looks something like this:  {recIdPk = 1, textCol: "newvalue"} Instead of updating the column (textCol) with the given value for the existing row I get the below error (screen-shot attached). So from my understanding this error should not be coming becoming as this not null column already has a value both in the db table and the record object and I'm not looking to update that field hence not specfying it in my above recordType constructor. I have a total of 15 columns in my table of which two columns have a not null constraint and are already populated from a separate location (using write records itself). I'm only looking to update one specifi

Configure node as mentioned in HERE  for Execute Stored Procedure Smart Service but getting following error. I have created SP in SQL server and tested successfuly but couldn't call from processmodel. Error: No procedure found with name  procUpdateDWAZipCodeParameter. TIA !

I have 3 different Records and respective tables where SYNC is enabled. Now, i want to create a view on top of these 3 tables and export to excel or use it any other workflow. I am not planning to query view using queryentity or queryrecord etc but i use SQL Statement to get required data and populate on excel in PM. If not view, I am left with stored procedure which is the least option in the list. Question: Can i create view on top of synced records/tables in first place? All the resources says that i cant (if i query on it using queryentity or queryrecord) or in general etc.. If not what is the work around?

Hello, I am troubleshooting an issue I have with a GRID where there is no data populating the GRID when I load the page but after clicking one of the custom pagination arrows we have, the data populates but then we can't click the arrow to go to the next page of data. There are quite a few files involved in this screen but I suspect the issue has to do with paging? On page load: After clicking custom pagination arrow: GRID code:a!localVariables( local!pagingInfo, { rule!TB_SEC_customPaginationComponent( startIndex: ri!pagingInfo.startIndex, batchSize: cons!TB_INT_TRADE_BATCH_SIZE, totalCount: ri!totalCount, saveExpression: { a!save( local!pagingInfo, a!pagingInfo( startIndex: if( a!isNullOrEmpty(ri!pagingInfo.startIndex), 0, ri!pagingInfo.startIndex ), batchSize: cons!TB_INT_TRADE_BATCH_SIZE, sort: ri!pagingInfo.sort )

Hi, I am trying to use syncRecords() to sync a service backed record. But it is every time returning error The error is  Dictionary errorMessage: "An error occurred while syncing record type [name=PS Complaint Service]. Details: Unable to sync due to an error in the sync expression. (APNX-1-4521-040)". In the Identifers I have tointeger as well but didn't work

Hi , I'm trying to perform action through the interface using a!recordActionFiled(). The record contains few related actions and I'm displaying that as action dropdowns on the intreface. When I click on those actions. it's throwing me the below error.  "The specified related action does not exist or you do not have permission to view it." I'm the administrator who has created all components, but still I'm not able to action. Can you please help me here?

Hi, I have to update a status value after a related record action but it is not getting updated until unless I refresh the screen manually. I have used a!refreshvariable() for the local variable where we fetch the status, have given activity chaining in the Process Model and also tried Records sync Smart service. But none of them works. Can someone help if missing something or is there any other option that causing this.

Hi Team,  When I am filtering the record data, I am Geeting error. Pls find below screen shot.   

I have a scenario where I use exportEntityToExcel smart service to export a VIEW data (script below) in an excel file. There is one filed which has datatime (CREATED_ON) in it. I want to display/export to excel the timezone along with datetime in this field. Existing Format: 11/27/23 02:43  Expected Format: 11/27/23 02:43 AM/PM PST/CST/MST/EST  .CREATE VIEW `DUMMY_VW` AS SELECT `b`.`CITY` AS `CITY`, `i`.`CREATED_ON` AS `CREATED_ON`, `i`.`CREATED_MONTH` AS `CREATED_MONTH`, `i`.`CREATED_YEAR` AS `CREATED_YEAR`, FROM (`DUMMY_STATUS` `i` left join `DUMMY_PROFILE` `b` on(`i`.`ID` = `b`.`D_ID`)) ;

Hi, I'm trying to update the DB whenever there is an user interaction in the record action but it is creating new row instead of updating the existing one. Please let me now if I'm missing something to configure. Below are screenshots of the Write record 

Hii, I am trying to concat multiple strings a!localVariables( local!data:{ a!map(id:1,visitorId:11,name:"John",comment:"hii john"), a!map(id:2,visitorId:12,name:"Jacob",comment:"hii jacob"), a!map(id:3,visitorId:13,name:"David",comment:"hii david"), a!map(id:2,visitorId:14,name:"Bobby",comment:"hii bobby"), a!map(id:3,visitorId:15,name:"Mark",comment:"hii mark"), }, local!distinctIds:{1,2,3}, a!forEach( local!distinctIds, { Id:fv!item, comment:concat(index(local!data,where(index(local!data,"id",null)=fv!item),"name",null)," - ",index(local!data,where(index(local!data,"id",null)=fv!item),"comment",null)) } )) Above code gives me the output as: Id: 1 comment: "John - hii john" Id: 2 comment: "JacobBobby - hii jacobhii bobby" Id: 3 comment: "DavidMark - hii davidhii mark" But I

Hi All I have a requirement where I have to query the data from database for a particular column of type varchar(max) which has data more than 1 MB . While fetching the data from query entity, I am getting memory threshold error. Please recommend me some way of how can we fetch more than 1 mb data. Many thanks in Advance!

How to get all records using a!queryRecordType() since batch size -1 is not applicable here therefor any hard coding the batch size might fail in some scenarios. Help will be appreciated..

Hi all, we have a record based on a view, so no sync options is possible. The view is quite complex, it takes 10 second from db side and 20 seconds on Appian side to be executed, The record list works correctly, we have inserted the record in a site and we show only 50 rows per page, but when the user click on the record link in the list that should redirect him to the summary view the APNX appear Substituting the record link with an a start process link where we call the same interface of the summary view it works, but for another reason we cannot use this strategy We are in cloud, appian versione 24.1 2024-04-25 15:39:15,835 [ajp-nio-0.0.0.0-8009-exec-481] ERROR com.appiancorp.rest.record.data.RecordRestService - Unable to retrieve record summary for record w/ type RecordType [id=836, uuid=bdd54fd9-3928-41bc-876e-5bf67f3cf465, name=All Events Incidents, sourceTypeStr={http://www.appian.com/ae/types/2009}DataStoreEntity, sourceUuidStr=0d398e47-7f8b-45ee-9075-b62c963b4b72@_a-0000