Data Fabric

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

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