Data Fabric

I have an issue I'm stuck on. We have this value writing to the DB for this column: And here it is after the Write to Records node: Does -2137483649 mean anything in the crazy world of data? I tried searching it but didn't return anything useful.

hello I'm on 25.1 and I have the below Use Case: I need to display on a read-only grid a short list (5 or 10 items at least) of last opened Record of a given Record Type. basically I need to store on a table the interactions over a Record List (every time a user clicks on a Record Link) in order to display the "last opened records" as a table I was thinking on replacing the Record Link with a startProcessLink which stores this transaction on a table (recordId, user, timestamp) and then open the Record Summary as a task, but this has several disadvantages: - the record page has several tabs (summary, attachments, other related data ....) which might requires additional effort to refactor - transforming the record interaction into processes might have performance issues any thoughts/suggestion about how to deal with this? thanks

Hi , We have a requirement of Loading Data into a new Table / View from 4 different tables (These 4 tables don't have Record , those are old tables They have CDT) .  In terms of Performance and New features of Records which approach will be better ? 1. Use Store Proc ( Creating a new table > Select required columns from 4 different tables > Insert into new table )  But in this case , everytime if our 4 tables get updated in Prod, We have to run this Store Proc        2. Create a materiliazed view .  but I guess in this case also , we have to update our view if there are entries in those 4 tables       3. Create a normal view from 4 tables  But Record Sync and other data fabric features won't work here I guess Can anyone please help here ? Thank You in Advance

I have create a record type using a view, Which has more than a million data.But in performance im getting the below error "Expression evaluation error [evaluation ID = a8853:4ed82] at function a!recordList_ui_design: An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit.. (APNX-1-4198-000)"

Hi, We have a custom email notification configured for a task and this is done using the tp!id parameter. the Task URL that gets generated looks like: /suite/tempo/tasks/task/<task-id>. When the user gets the task assigned and opens it from the tasks tab, it works fine. The URL for this contains the opaque task id. But when the user open the task via the custom email (tp!id), the task throws the error: The Requested Task Is Not Available The task may not exist or you may not have permission to view it. The same code works in one of our Appian environments - version 25.1.286.0 and it doesn't work in the environment - version : 25.1.236.0. Any idea if this has got anything to do with the Appian version? Thanks

I have an interface where a user is able to click on several choices in a checkbox. Each selection is stored as a separate row in a data table that is linked to their user data.  Adding new choices is easy as you just write a new row for that box. Removing them is a bit more tricky. Is there a standard best practice for this row addition/subtraction process? 

Hi All I am working on version 24.3. I have started exploring Appian AI capabilities and to start of with I find a!recordsChatField() a great component to provide to the user. So as a use case; I have a record which has user filters available. I want to use a!recordsChatField() so that we can provide better experience to the users so that they can use natural language to get filtered records rather than using user filters of records. I have gone through the forum but didn't find any handy tutorial which provides practical example of using the a!recordsChatField(). The only thing i was able to find is the document for the component: https://docs.appian.com/suite/help/24.3/Records_Chat_Component.html Can anyone please guide how can I use this field. Any link to academy online for the same will also be useful.  Thanks in advance!!

I replaced all the cdt to interact with the data using records. for some reason it is not saving the values in the database, nor in the process history fields. But if I check the variables, the values are correctly populated. Is there something I'm missing?

I can't tell if this is an appian problem or a DB problem and am not sure where to begin looking for the problem. When writing to a record I get this error: I wasn't getting this error last week, which is frustrating, but I am now. As far as I can tell, I haven't changed anything that I am aware of that might cause it. The table exists in the db and the table permissions seem to be fine. Doesn't seem to be happening with other tables and I don't have access to appian's error logs. Any ideas as to what I should do next? 

Hi Team, Whether it is possible to add sensitivity level of the document in the excel document generated from Appian

Hi,  I'm trying to find the root cause to why I can't see any records in the "Data Preview" screen of a Synced Record Type. The application works normally and I'm able to push a full sync without any issues. Other records stored in the same database are available in "Data Preview". Context: The data is stored in company hosted SQL Server. Error message: Preview currently unavailable due to an error on the source   Any recommendation to logiles, or actions I can take to understand why the data isn't displaying is appricated.  Thanks for your help  

I'm currently practising in  appian community environment. Is there a way that I can do some hands on on CDT's and Plug Ins.

Hi team,    I have written a expression rule to update a particular row of a record. The Expression rule is working as expected while unit testing but does not work when called in Script task.Could someone please help?

Hi Appian Community, we have one application for which development is completed and planning to migrate it to new UAT instances,  Already have created many records configuring data source in admin console by name like "jdbc/ApnDev001" have plan to create new data source with the name of "jdbc/Appname" in new UAT instance,  while doing to observed that we need to change data source for existing records causing field UUID get changed, and this leads to huge changes at application level wherever we have used these records. Is there any way we could fix this issue (rename or create new data source) without major changes. any form of guidance would be welcomed, Please help.     Thanks,  Shree Krishna tiwari    

Hi Team, I have written query record type with filters to get the records which are reviewed one year back. Filtering based on field "reviewedOn".Currently when i am testing this rule, getting records those have "reviewedOn" is null. How to eliminate these records which have "reviewedOn" is null.Attached Query and output for your reference:Please suggest if any solution available to fix this.a!localVariables( local!lastOneYearReviewedAttestations: index( a!queryRecordType( recordType: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestation', filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestation.fields.{9cc9f1c8-8b6c-4200-94d0-b992949d4303}reviewedOn', operator: "not null" ), a!queryFilter( field: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestatio

Hi All,We have an application which will receive various details from an external system including primary keys for documents which are used for retrieving documents from another system. We receive these details via an API and a task is created for the user to process the same. When the task is being processed by the user, the external system might update the data again which includes adding or removing documents. Since the task is opened by the user, he will never know whether some update has happened to the task or not. We thought of using some refresh variable but it does not seem to be a viable solution. Also it might lead to performance issues since the number of users and number of tasks will be high. Is there any way to handle real time updates and show them in UI?? Any suggestions would be helpful 

I'm currently exploring all the possible ways to insert record in a record type (for e.g. StudentDetails is my Record Type) but I have String fields as process variables. one way I know is (i) Gave Input Variable of StudentDetails type and in Script task Output  mapped the values from process variables  and used write records.

Hi Appian Community I am using a web service to fetch the records I have synced all the records successfully but, in the list, there are less records available.  Sync successfully for 10046 records but only 6549 available in the list

Hi everyone, I'm having this issue and trying to find some help/ recommendation.  I'm having this process report that contain 1 row of data. But when I run the expression rule to query it with 2 different user account, I get different results, even though the 2 accounts are in same All Users group and that group has Viewer level security in my report.  With my main user account, when I run the query I get that 1 row of data back as output - expected With my test account, I get null value as output - Even though when I open the report I can still see data displayed.  Is there any other areas apart from security level that I should look at?  This is my code snippet, I just input in the context process model and report if( ri!isMissingMinimumInputs, if( ri!doReturnData, {}, a!dataSubset() ), a!localVariables( local!columnConfigs: if( not(rule!GBL_isEmpty(ri!columnConfigs)), ri!columnConfigs, a!queryProcessAnalytics(

From the Grid Layout list i need to add to the other Selected List which is Related Record Data. So when calling this grid interface i am facing issue in the Parent Interface that. When I am selecting more that one item from the list it throwing me the below error. Please let me know how to rectify it Interface Definition: Expression evaluation error [evaluation ID = 033a4:c74b3] : An error occurred while executing a save: Expression evaluation error: Cannot update List of DIL Product User Trans; length of assign value list (2) does not match length of the list to update (1) 1. No Error while selecting 1 item from the list 2. If select more that on item from the list it throwing the below error

Hi, How we can create dropdown using record data?

Hello, I'm creating a process model to synchronize a database with a record type.In the process, I created a node that uses the "Sync Records" smart service.According to the documentation, synchronizing more than 1,000 records requires a loop.I've followed the steps, but the "Sync Records" smart service doesn't return anything inthe "ac!RecordsUpdated" variable, which should be used to avoid an infinite loop.Here are some screenshots of the configuration and docs link. docs.appian.com/.../Sync_Records_Smart_Service.html The import to the database is successful, but the record type is not synchronized.

Hi everyone, We have configured a process report to retrieve all active processes. Additionally, we have a query to obtain the active process ID for each case based on the Case ID. However, we are encountering an issue where multiple values are appearing in the column of the process report (mapped pv value for column in process report). As a result, some of the active process IDs are not being queried correctly. Could someone please help us understand why multiple values are appearing in the process report? Is it because the process report contains the value changes from the process history?

Hi,What trying to create a sample data for a Record Type but is throwing the below error. Even tried suggestion given on the error but again throwing the same. Kindly let me know what else can be done. 

Hi Team I am using an environment specific date constant. This is an array of dates constant .. I want to deploy to higher environment but in such a manner that the constant should be null ( because I will be appending values in it via process model as part of logic later ) While deploying I am passing nothing in the custom properties file  eg :   content._a-0000ed12-853e-8000-9c18-011c48011c48_2772176.VALUE= But when seen in higher environment it comes like this :  I wanted it to be blank ( i.e. nothing in the constant ) .. somewhat like this :  Is there any way we can achieve this via custom properties ?