Data Fabric

Anyone send me links for performance of record type and how many types? and how to do it?

I am looking for suggestions on the best and fastest way to query data that has about 50,000 rows of data.  My use case is data collection for inventory purposes where an operator will use a handheld device and scan and item_id barcode, the application retrieve a description and then they can scan a qty.  The reason for the retrieval is to verify a good part number, also to occasionally verify the barcode to the product.  The data currently resides in a SQL database.  We are on Appian 22.3 Cloud.

Hi everyone, How to check all of the document if exist. I query all of the data have Document Id and I want to check all of that using in the single query

So basically in site I'm getting all the data from db whre as i have only one field where use input task is req. And that is a date field I need to input the date from site can anyone help me with this?

When I'm trying to create a datatype from dB I'm getting the following error, "Your data type could not be created.please consult the logs for more information" Can anyone please help me with this??

I am  facing problem  in developing project. I made relation in two table in appian cloud database. But when i insert data foreign key id is not inserted in second table. see the below screenshot when document data inserted , request_id (2nd column) will be null. 

Hi, I have a grid in an interface (a list of records from a RecordType), and each row linked to a "Modify" related action. When I click on "modify", a process is launched, and a start form is displayed, then the user can update a field value and submit the form. When the process ends, the list of records appears back, but the old value is still displayed in the grid. How would you do to update this grid ? - I've set the [refreshAfter: "RECORD_ACTION"] attribute, but the grid is not updated. - We do not use a RecordSync, so we can not use the new Smart Service "Sync Records". - When I refresh manually the grid, the data are ok.

Hi, Any one knows from where the Schema value will be pulled when we select Data Source value. No where I have given the Schema value during Data Store setup.

Here is my code  I understand that error i how can i use the same nested if without error?

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