Create a record for non primary key based table
I have a table X which does not have a primary key. the format of data is something like this,
| Indentifier for Request | Emails [non Unique] | Column A |
| ABC123 | useremail@email.com | A |
| ABC123 | useremail@email.com | V |
| XYZ582 | User2@email.com | D |
I have to create a record to view this data.
Notes:
- there is no primary key to this table.
- Indentifier column is currently marked as primary key in table.
- this table is not handled by Appian and is only referenced for data.
- the table has more than 800 thousand rows at one time on average. the custom plugin breaks if user tries to export all data at once. [Business req. on export from Appian]
The record list breaks with following error: Expression evaluation error at function a!gridField [line 27]: A grid component [label=“”] has an invalid value for “totalCount”. “totalCount” must not be null or less than the number of items in any of the “data” arrays, but “totalCount” was XX and the largest column data array had XXXXX items.
Why record: I would like to leverage the filters and export functionality from records for this table. I know this can be achieved using query entity and export to excel plugin however I would like to know If this can be achieved in records which has all these functionalities inbuilt.