Data Fabric

I am currently having an issue with one of my record types not appearing to sync correctly. We have a Process Model set up to schedule a set of tasks for users and write all of these details into a table to hold these scheduled task details. We also have two separate record types set up to display different task types. Both of the record types have source filters set for A) their task type number and B) anything scheduled for yesterday and today's date. The Process Model is set to run daily at a given time, and every time after, it appears as though one of the record types is out of sync. There will be extra items in the record type list, and one of the columns will contain a null value. However, if we go in and do a manual full sync, all of the data will display correctly immediately after that.My question is about whether or not the date value in the source filter is messing up with the syncing of the data. The way the source fields are displayed, it has the text "Define whi

I am using a grid to show record list where i have added pagination, when the list is loading first time and i am clicking on arrow button to go to next page in not working but when i am clicking the same button next time then it is working fine Here i am using the refresh variable and using the refreshAlways set to true, when i am changing it to false is working fine, below code i am using in list page. a!localVariables( local!jobId:null, local!localeDetails:rule!SDL_getLoggedInUserLocale(), local!labels: rule!JT_getTranslation( locale: local!localeDetails, labelId: { "jobId1", cons!JT_LABEL_JOB_NAME2, cons!JT_LABEL_EXTERNAL_JOB_ID, cons!JT_LABEL_CLIENT_DIVISION, cons!JT_LABEL_CLIENT_NAME, "createdOn1", "initiatingPm1", "status2", "phase2" } ),{ a!gridField( label: "Jobs", labelPosition: "ABOVE", data: a!recordData( recordType: 'recordType!{d495f140-8079-4d18-a9ff-667d19dacd59}Job', filters: a!queryLogicalEx

I am using a grid to show record list where i have added pagination, when the list is loading first time and i am clicking on arrow button to go to next page in not working but when i am clicking the same button next time then it is working fine Here i am using the refresh variable and using the refreshAlways set to true, when i am changing it to false is working fine, 

I have a grid where i added pagination, when the grid is loading for the first time and i am clicking first time on the arrow button to go to the next page is not working but if i click in the arrow button again is working fine. I used RefreshAlways set to true, if i set it as false and testing the interface is working fine, below code i am using. a!localVariables( local!jobId:null, local!localeDetails:rule!SDL_getLoggedInUserLocale(), local!labels: rule!JT_getTranslation( locale: local!localeDetails, labelId: { "jobId1", cons!JT_LABEL_JOB_NAME2, cons!JT_LABEL_EXTERNAL_JOB_ID, cons!JT_LABEL_CLIENT_DIVISION, cons!JT_LABEL_CLIENT_NAME, "createdOn1", "initiatingPm1", "status2", "phase2" } ),{ a!gridField( label: "Jobs", labelPosition: "ABOVE", data: a!recordData( recordType: 'recordType!{d495f140-8079-4d18-a9ff-667d19dacd59}Job', filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFil

I am getting this error when performing an related action .can any one help me in this? 

Whenever If i click on the firstname it have to link to the interface already i have , which link tag i have to use and where to use here. Finally i want to use thoese in sites . In Cadidate first name The link should link to interface The expression  Need to display in that site

Hello! My issue is as follows: The app serves the purpose of office desks' management, where desks can be booked by users for periods of time. For this case we have two recordTypes: "Desk" and "Booking", and a foreign key that connects them. The "Book this Desk" record action saves the "bookingNumber" to the Desk recordType, but the data for the booking itself is stored in the "Booking" recordType. One of the requirements is that a priviliged user shall be able to book multiple desks for a group of users. We figured that these priviliged users will create groups through the Create Group Smart Service and therefore the Booking will be assigned to a group. That should work fine for assigning multiple users to one Desk, but is there a way to take action on multiple recordsTypes? In this case, to assign one group of users to multiple "Booking" recordTypes, each of which will in turn be assigned to multiple desks (one "B

Hi, To get a value from a memory CDT list (not a table) on a single field condition, I use Index(CDT, whereContains(value, CDT.field2)). In SQL : SELECT * FROM table WHERE field2 = value Is there any way to do the same thing with Appian fonctions when we need to make a lookup with an AND condition ? Ex : SELECT field1 FROM table WHERE field2 = value AND field3 = value  Otherwise, I would do it with a simple foreach(). (PS : My question, is "not" about how to query a table with multiple logical conditions of queryEntity [emoticon:bfea11b94cc048458ee2c01f963db38d] )

Hi there, I have database table, one field "matnr" configured as varchar, can be NULL, but when setting it to null or NULL in the process model, then writing to database (pic 1), the field value is not NULL, while kind like empty (pic 2) . I am trying to create a expression rule searching the information with this field "matnr" without value, set "matnr is null" is not working. what's the way to do this? why Appian condition "is null" in Query editor does not work for empty field as other languages? regards,Lin

I deleted some rows in DB and the data in record type was not updated accordingly.  I've checked the tab Sync Options in record type and there is a button Start Full Sync. I'm wondering if it will affect the DB when I click that button to sync data manually, as this record type is scheduled for full sync at another time, and I want my record type data to be updated immediately.  Thanks for any advise!

Hello, I'm not quite sure if  I'm working with this pickerFieldRecord correctly (it is not saving any value in the rule input) and I don't understand why it says that "idSkill" is type Text because it isn't...  a!localVariables( local!Skill, (...) a!pickerFieldRecords( label: "Competências", labelPosition: "ABOVE", placeholder: "-- selecione uma ou mais competências --", maxSelections: 3, recordType: 'recordType!{b10f5f28-725c-4c8b-a211-776386be5222}RM_ref_Skill', value: ri!recordCandidateSkills.idSkill, saveInto: {local!Skill, a!save( ri!recordCandidateSkills.idSkill, if( a!isNullOrEmpty(local!Skill), {}, a!forEach( local

Hello,  The following error appears when I try to excecute the function fn!executestoredprocedure() LOG TomCat:  ERROR com.appiancorp.ps.function.ExecuteStoredProcedureFunction - Error executing What can be happening?

Hi All, I am new to Appian programming, and here I need your help; I have CDT, and based on the below screenshot, I need to remove the 5th record based on the following conditions. The Person id duplicates, and ChildCustodialTypeId is NULL. In this scenario 5 the record I want to get rid of when I call the CDT, so please let me know how I could do this successfully.

Hi, Does Appian have the functionality to store when a user logs in, what are the reports he downloads, how much time he spends on a particular tab? Does Appian maintain an Audit trail of users? If yes, how can we get access to that?

Hi All, I have created a task report where my initial sort is task_id in descending and configured in Site .Whenever I load the task report, it shows me the grid in a correct manner with task_id in descending order. I am also showing a link where I am calling the record action to create a new task. The task consists of 5 milestone with active chaining and all has back button except the 1st milestone. When the user clicks the "next" button in 1st milestone then we generate task id by writing in DB. Not working Scenario :  From task report, the user clicks the link(create new task link),he completes 1st milestone data & click next ,goes to 2nd milestone. Then from 2nd milestone if the user goes back and comes to 1st milestone, then user tries to navigate, so they just click the task report tab . Issues : 1. Now the current task id is not visible in the task report grid 2. The sorting of task_id in task report is totally collapsed. Until this sorting was working p

Hi guys, why when I try to create a rule input in expression rules editor, it told me  could not find the variable? 

Hello Appian Comunity, Can you pls let me know and explain which is the proper expression rule when configuring the visibility field for the " only show when " option on the record type object? What I´d like to do is to show the image of the car when available. As I have it right now it doesn´t show the image on the record list. also, can you pls help me understand why if I have the following configuration on the display value, and on the visibility, field selected " always show " I get the error?  Thanks a lot.

I Have a Form in wich I upload documents. It works well.When using Update action, I need to see what documents have been uploaded, keeping the possibility to add more documents.How to? 

Hi everyone, I'm filtering this record to only query cases with completed date within nearest 5 days. My query code is as below: a!queryFilter( field: recordType!Record.completedDateTime, operator: ">", value: datetime( year(now()), month(now()), day(now()) - 5, 00, 00, 00, 00 ) ) The code worked well last week, but this morning it suddenly showed this error:  The Requested Record Type Is Not Available The default filters expression for record type failed to evaluate. Details: [Expression evaluation error at function a!queryFilter [line 4]: Date out of range: Invalid day]. (APNX-1-4205-018) I've checked the DB and data for this column was the same structure as last week:  datetime /* mariadb-5.3 */ . For example: 2022-08-01 04:14:49.  Any one has faced the same error code? Please give me some suggestion if possible...  Thank you!

unexpected end of json  input while trying to view summary view from record list can anyone explain why it has occured

Hello We have recently upgraded to 22.3 on-premise installation and using SQL server as data source. In the new release of 22.3 its mentioned you can create New Data Model in Record page and design the columns within the Record itself. However, this option isn't available in our environment (link below). see attachment/resized-image/__size/320x240/__key/communityserver-discussions-components-files/16/Screenshot-2022_2D00_08_2D00_29-105432.jpg My question is, is such feature is available only for Cloud customers or there additional configuration is required to see such option. Best regards, Khaled

How to save a value of local variable to rule input.

How to implement while or do while logic in expression rule?

I am trying to display a read only grid by using expression rule which is basically a query. But I am getting some error when I'm trying to do.This is the error."Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridField [line 5]: A grid component [label="Read-only Grid"] has an invalid value for "columns". A grid column [label="A Id"] has encountered an error. Expression evaluation error: RTA Customer Data can only be indexed into using square brackets or the index function"Can someone please help me how to solve this?