Data Fabric

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.

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)?