Data Fabric

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.   

Hi everyone,  I'm having a grid field that shows data from a process model based report by using a!queryProcessAnalytics() query. I set up a manual refresh button that updates a reference local variable's value (local!refreshCounter), so that whenever user clicks the refresh button, the report value will be updated if there is any new active process task.  However, the process was not refresh unless I refresh the whole page (F5). I'm I doing it wrong? a!localVariables( local!refreshCounter: 1, local!datasubset: a!refreshVariable(value: a!queryProcessAnalytics( report: , contextProcessModels: , query: a!query( pagingInfo: a!defaultValue(ri!pagingInfo,a!pagingInfo(1,-1)), logicalExpression: a!queryLogicalExpression( operator: "AND", logicalexpressions: { a!queryLogicalExpression( operator: "AND", ignorefilterswithemptyvalues: true, filters: /*Status */

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

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  

I can generate a dynamic pdf using html template and html template from doc service followed by PDF from HTML smart service. But cant display image. In html template i am using image src and in src i make it as pv and pass the image field/rich text image with document image having document id from appian. Image is displayed as image icon but no image displayed. Any idea on how to get these done dynamically? Thanks in advance

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.