Records

In version 21.4,   Export To Excel button is exporting only 1000 records from data base view where we have more records in DB view.  And also the number of records data shown in the grid is not same as the data exported into excel. what could be the issue ? How can we resolve this issue ?

Need help to design & create records for below requirement, Each day 1 parent file and 8 child files will be loaded into DB table. Each child file will be having separate columns except foreign keys. Consider fileReferenceId and dataId are foreign keys. I have to display parent file data on landing page and provide link on dataId. Once user clicked on any of the data Id, user will be redirected to new page where records from child table needs to be fetched & displayed using dataId and fileReferenceId. My Approach:  Create entity backed record using parent table. Whenever user click on dataId  , using 'fileReferenceId ' decide which child table needs to be called from 8 tables. Using 'fileReferenceId and DataId' display returned data on interface. Could you please suggest another approach to avoid so many DB calls. Is it possible to create separate record for each child table and link in the parent record. Thanks, Hemant.

I am new in Appian application development. Can any one please help me to know how can I get and use the Import CSV to Database smart service? Should I use any Plug-ins? If yes where from I can get it? I searched for it but did not get it.

Hi, I made changes to the View (added a column to the view with datatype = text). Added the same definition to the CDT by adding new column with datatype=text. When i try to verify the datastore, it is giving me the below error The data source schema does not match the type mappings: Wrong column type in Appian.p_my_view for column fs_structure. Found: text, expected: VARCHAR(341) (APNX-2-4056-000). see below for CDT definition and view definition. There are other column exists in the view with text and it doesnt complain. any help is appreciated.

We have a solution based on record centric approach, hence all the database tables are mapped to Records, which have relationships too that vary from 3-4 per record to 10-11 on some of the records. All the interfaces are using records to display the data, recently an issue has been occurring while retrieving the data from records has become dead slow, causing time-out errors, or sometimes the interface takes forever to load. I have looked into the performance logs and server logs for any related cause and made certain performance improvement changes too but the issue still persists. The issue occurs intermittently, hence it is hard to figure out the exact cause of the issue. I'm looking out for what could be causing this and the best solution for this problem. Thanks in advance, your help is highly appreciated.

I have implemented service backed record with daily sync enabled. But the data at the source(service) gets added frequently(in minutes) and the customer want to see the updated data in Appian once its get added at the source. I have gone through documentation where I saw "Sync Changed Data". Could someone help in achieving "Sync Changed Data"? Additional Information: 1) Identifiers of the data being returned by the service are not sequential but random in ascending. (Identifier's are unknown if I need to use "Sync Record" smart service) 2) Full Data Sync takes around seven minutes. (for now there are around 180K records being returned by service, in prod it will be around 490k and will increase)

Hi Team, During our performance testing, we are getting below error . when manual testing we are unable to reproduce it ,  Expression evaluation error [evaluation ID = c5310:d3811] in rule 'dsm_getslariskcasescount' (called by rules 'dsm_d_dashboardreport' > 'dsm_recordsyncbasedhomepagemain') at function a!queryRecordType: APNX-3-0000-002: The real-time store is not up to date to the requested tx 102138493; latest tx is 102138487 (APNX-1-4198-000)

Trying out record centric design for the first time and I have a multiple dropdown field on the interface. Using the recordType (no data yet, just structure) as a rule input does not allow for me to specify a field as an array (like can be done with a CDT). Is there a way around this or is it as simple as 'if a multiDropdown is involved a CDT must be ctreated?

Hi Everyone, Created a webservice record without sync option, thinking getting records on demand would be best way to deal. created query rule , used as "Record Data Source" which has integration required inputs. when i tested record output  integration inputs showing it as user filters in records. i would like to show the record output in SAIL grid form and  should only get next set of records from integration when clicked  on next page button , how do i pass start index, batachsize parameters to Record Data Source query rule. any help would be appreciated , Thanks in advance.

Hi, we are trying to refresh local variable value on var change but it is not working. PFB Code a!localVariables( local!refreshOnVarChange: false, local!allMessages: a!refreshVariable( value: rule!DS_QRY_getMessageThread( returnDatasubset: false, filters: a!queryFilter( field: "clientInboxId", operator: "in", value: {15,16} ) ), refreshOnVarChange: local!refreshOnVarChange /*refreshAlways: true, even in this case data is also not get refresh*/ ), local!textBox, a!sectionLayout( contents: { a!textField( value: local!textBox, saveInto: { local!textBox, a!save(local!refreshOnVarChange, not(local!refreshOnVarChange)) } ), a!textField( value: length(wherecontains(true,index(local!allMessages, "isRead", ""))), readOnly: true ) } ))

Hi, We have a requirement to write over 50 000 rows daily to our MariaDB database. I want to know what is the best way to get this done. We tried using a Record Type but the data was too large for it to handle and a breaker cancelled the synchronisation. I have seen that creating Multiple node instances is not recommended as we will create an excessive connexion pool with the DB. The only solution that comes to mind is to have a subprocess that gets fed smaller batches (100 or 1000 rows) looping through the data for insertion (sequential).

How to publish data storage

Hello, me and a colleague are trying to make a database where we have a table called "students" and one called "subjects", meaning many students can take many subjects. We've been researching for a bit and the way explained in the Appian Documentation is the one explained here, it says create both the parents and child CDTs, then create a third table where you have: a primary key, a foreign key that corresponds to the first table, a foreign key that corresponds to the second table, and an index. The problem is that by doing so, you can add duplicates of each, meaning that the same student can be assigned to the same subject twice (this screenshot is the Intermediary record type): (I made 3 record types, Subjects, Students and Intermediary). That's why I wanted to ask all of you for any suggestions so that this table does not take duplicates, or if there's anything that we are doing wrong. Thank you!

Hello Community, Trying to sort a query field that is currently text but hold dates.  Was wondering if in the query it might be possible to cast as type date. Currently attempting to sort the C2 column, however due to it being text it's not correct. query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1000, sort: a!sortInfo(field: "c2", ascending: true) ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "c4", operator: "includes", value: local!activityFilter, applyWhen: not(isnull(local!activityFilter)) ), a!queryFilter( field: "c1", operator: "in", value: local!statusFilter, applyWhen: a!isNotNullOrEmpty(local!statusFilter) ), }, logicalExpressions: a!queryLogicalExpression( operator: "OR",

Hi All, So here, i using related action for Return form the manager, based on return status i make a visibility condition to display the Related action,  problem:when shopkeeper accidentally  click and submit the form , the manager will get two Tasks in Same Instance. related action form.

I am getting two recordtypes with the same name. Pls suggest why and how to make it a single one. Each of the two 'Product Recordtype' is referenced in different locations. Pls suggest how to make them into one and all referencing objects should refer to a single one.

Hi, Recently I have deployed a new application to Production environment. But facing DB connectivity issue. But there is no problem regarding DB connection at lower environment. I have created the Data Source at Admin Console and here it shows Test Successful. The Screenshot: But when I am trying to verify the Data Store, it is not able to connect to DB. The Screenshot: Can anyone please help me regarding this DB connectivity issue? Pertinently I like to inform you the a few days ago the connection was successful and in-between nothing was changed related to configuration or not any further deployment was done in production. Thanks, Surajit Sen

I'd like the employee ID to auto increment and populate automatically whenever a new employee is being added to the record.

Hi, Recently we deployed a new application to Production environment. It's working fine. The screenshot But facing DB connectivity issue every 37 minutes we are getting this error. Can anyone please help me regarding this DB connectivity issue?

Hello, when a record type has a (1,n) relation, Appian supports some aggration for those related records ( 'Create Custom Record Field' --> 'AGGREGATE RELATED RECORD FIELDS'). The avaible aggregation functions seem to be dependend on the data type of the 'AGGREGATE RELATED RECORD FIELDS' - in any case, I'm looking for something like FIRST_OF (LAST_OF) so that I can get the first record field(s) of related data records (which are string based). Maybe a small example: (Author)  <-- (Books) (an author can have many books) Should be presented in a list author number of books book title (first) book release year (first) Scott Lynch 6 The Lies of Locke Lamora 2006 ... What would be a good way to achieve this? Thank you in advance Thomas

How can I apply an order or sort to the values shown in a picker field? I am using a a!pickerFieldsRecord on a single record type Employees (ID, First Name, Last Name) but would like to sort it by first name.

Hi, I want to know how to create " Functions" & "Procedures" section in custom Database not the in-built APPIAN one. We have created our own custom DB for our APP  Using Appian 22.3 Regards Bihitak

Hey Guys, i just want to write a rule expression. wrting(create) data to the database using record type. the record type is already synced with the database. I can not figure it out. i also tried using Write to record smart serice but  i keep getiing error that i can not use record type.  how is something so easy so difficult to find solution. please help. i just need a a expression structure for writing data to the database using record type

I am currently having issues while working with a one-to-one nested cdt design (without reference data).  I have simplified this problem by creating the following 2 tables: CREATE TABLE TEST_PARENT(parentId INT PRIMARY KEY AUTO_INCREMENT,parentName VARCHAR(50)); CREATE TABLE TEST_CHILD(childId INT PRIMARY KEY AUTO_INCREMENT,parentId INT,childName VARCHAR(50)); ALTER TABLE TEST_CHILD ADD CONSTRAINT FOREIGN KEY(parentId) references TEST_PARENT(parentId); While trying to publish the nested CDT TEST_PARENT with the following configurations: I am receiving the following error: The repeated column error does not make sense to me as the columnName defined in the second screenshot is the foreign key column on the child table which is pointing to the parent.  I am struggling to get this to map properly and get around this error and would appreciate any assistance.

HI I have a requirement to export more than one lakh records into excel sheet. challenges:      -> Data is coming from a view having multiple joins.( Facing performance issue at production)     -> So we followed appian records approach, but export to excel button is getting disabled when record count is more than one lakh.     -> As the records count is high, we are not interested to go stored pro and staging table approach Any advice is helpful