Record lists of modules pointed at db views don't page correctly

I have a module pointed at a database view. The record list loads the data correctly, but the paging never works. Hovering over the page arrows results in the red crossed out circle.

@tjerman ,do you have any ideas?

Can you share your module field and data store definition please?

I’m not entirely certain what you’re asking for. Is this it?

@tjerman Did you need something different from me?

That is the screen I was looking for. There are a few more fields below if you could share those also please

@tjerman Here you are.

1 Like

@tjerman and @jfortun Any advice here?

1 Like

hm hm hm… can you verify that the id and created_at columns have values?
Could you also send over the HTTP response from your browser development console? I’m curious about the meta part of it.

When this happens, this is generally due to ID values not being set correctly.

I’ve been helping @mldet here. This is the response from the browser development console – the createdAt fields seem populated. Let me know if you need anything else:

request: https://hrdpathways.detroitmi.gov/api/compose/namespace/417307227982921729/module/447161390264745985/record/?query=&deleted=0&limit=14&incTotal=false&incPageNavigation=false&sort=createdAt+DESC

response:
{
“filter”: {
“moduleID”: “447161390264745985”,
“namespaceID”: “417307227982921729”,
“query”: “”,
“deleted”: 0,
“sort”: “createdAt DESC, ID DESC”,
“limit”: 14
},
“set”: [
{
“recordID”: “9222557697517381632”,
“moduleID”: “447161390264745985”,
“values”: [
{
“name”: “legacy_case_id”,
“value”: “C3186”
},
{
“name”: “contact_status”,
“value”: “Contact Made”
}
],
“namespaceID”: “417307227982921729”,
“ownedBy”: “0”,
“createdAt”: “2025-07-30T14:51:43Z”,
“createdBy”: “0”,
“valueErrors”: null,
“canManageOwnerOnRecord”: true,
“canUpdateRecord”: true,
“canReadRecord”: true,
“canDeleteRecord”: true,
“canUndeleteRecord”: true,
“canSearchRevisions”: true,
“canGrant”: true
},
{
“recordID”: “9222388950703984640”,
“moduleID”: “447161390264745985”,
“values”: [
{
“name”: “legacy_case_id”,
“value”: “C4482”
},
{
“name”: “contact_status”,
“value”: “Contact Made”
}
],
“namespaceID”: “417307227982921729”,
“ownedBy”: “0”,
“createdAt”: “2025-07-30T14:51:43Z”,
“createdBy”: “0”,
“valueErrors”: null,
“canManageOwnerOnRecord”: true,
“canUpdateRecord”: true,
“canReadRecord”: true,
“canDeleteRecord”: true,
“canUndeleteRecord”: true,
“canSearchRevisions”: true,
“canGrant”: true
},
{
“recordID”: “9217299801813991424”,
“moduleID”: “447161390264745985”,
“values”: [
{
“name”: “legacy_case_id”,
“value”: “C3479”
},
{
“name”: “contact_status”,
“value”: “Contact Made”
}
],
“namespaceID”: “417307227982921729”,
“ownedBy”: “0”,
“createdAt”: “2025-07-30T14:51:43Z”,
“createdBy”: “0”,
“valueErrors”: null,
“canManageOwnerOnRecord”: true,
“canUpdateRecord”: true,
“canReadRecord”: true,
“canDeleteRecord”: true,
“canUndeleteRecord”: true,
“canSearchRevisions”: true,
“canGrant”: true
},
{
“recordID”: “9216114296250073088”,
“moduleID”: “447161390264745985”,
“values”: [
{
“name”: “legacy_case_id”,
“value”: “C1360”
},
{
“name”: “contact_status”,
“value”: “Contact Made”
}
],
“namespaceID”: “417307227982921729”,
“ownedBy”: “0”,
“createdAt”: “2025-07-30T14:51:43Z”,
“createdBy”: “0”,
“valueErrors”: null,
“canManageOwnerOnRecord”: true,
“canUpdateRecord”: true,
“canReadRecord”: true,
“canDeleteRecord”: true,
“canUndeleteRecord”: true,
“canSearchRevisions”: true,
“canGrant”: true
},
{
“recordID”: “9211129994220019712”,
“moduleID”: “447161390264745985”,
“values”: [
{
“name”: “legacy_case_id”,
“value”: “C1290”
},
{
“name”: “contact_status”,
“value”: “Contact Made”
}
],
“namespaceID”: “417307227982921729”,
“ownedBy”: “0”,
“createdAt”: “2025-07-30T14:51:43Z”,
“createdBy”: “0”,
“valueErrors”: null,
“canManageOwnerOnRecord”: true,
“canUpdateRecord”: true,
“canReadRecord”: true,
“canDeleteRecord”: true,
“canUndeleteRecord”: true,
“canSearchRevisions”: true,
“canGrant”: true
},
{
“recordID”: “9210440946410838016”,
“moduleID”: “447161390264745985”,
“values”: [
{
“name”: “legacy_case_id”,
“value”: “C6099”
},
{
“name”: “contact_status”,
“value”: “Pending Contact”
}
],
“namespaceID”: “417307227982921729”,
“ownedBy”: “0”,
“createdAt”: “2025-07-30T14:51:43Z”,
“createdBy”: “0”,
“valueErrors”: null,
“canManageOwnerOnRecord”: true,
“canUpdateRecord”: true,
“canReadRecord”: true,
“canDeleteRecord”: true,
“canUndeleteRecord”: true,
“canSearchRevisions”: true,
“canGrant”: true
},
{
“recordID”: “9209761587945355264”,
“moduleID”: “447161390264745985”,
“values”: [
{
“name”: “legacy_case_id”,
“value”: “c3121”
},
{
“name”: “contact_status”,
“value”: “Contact Made”
}
],
“namespaceID”: “417307227982921729”,
“ownedBy”: “0”,
“createdAt”: “2025-07-30T14:51:43Z”,
“createdBy”: “0”,
“valueErrors”: null,
“canManageOwnerOnRecord”: true,
“canUpdateRecord”: true,
“canReadRecord”: true,
“canDeleteRecord”: true,
“canUndeleteRecord”: true,
“canSearchRevisions”: true,
“canGrant”: true
},
{
“recordID”: “9209511410422251520”,
“moduleID”: “447161390264745985”,
“values”: [
{
“name”: “legacy_case_id”,
“value”: “C5295”
},
{
“name”: “contact_status”
}
],
“namespaceID”: “417307227982921729”,
“ownedBy”: “0”,
“createdAt”: “2025-07-30T14:51:43Z”,
“createdBy”: “0”,
“valueErrors”: null,
“canManageOwnerOnRecord”: true,
“canUpdateRecord”: true,
“canReadRecord”: true,
“canDeleteRecord”: true,
“canUndeleteRecord”: true,
“canSearchRevisions”: true,
“canGrant”: true
},
{
“recordID”: “9209113992295587840”,
“moduleID”: “447161390264745985”,
“values”: [
{
“name”: “legacy_case_id”,
“value”: “c3046”
},
{
“name”: “contact_status”,
“value”: “Contact Made”
}
],
“namespaceID”: “417307227982921729”,
“ownedBy”: “0”,
“createdAt”: “2025-07-30T14:51:43Z”,
“createdBy”: “0”,
“valueErrors”: null,
“canManageOwnerOnRecord”: true,
“canUpdateRecord”: true,
“canReadRecord”: true,
“canDeleteRecord”: true,
“canUndeleteRecord”: true,
“canSearchRevisions”: true,
“canGrant”: true
},
{
“recordID”: “9206208807768793088”,
“moduleID”: “447161390264745985”,
“values”: [
{
“name”: “legacy_case_id”,
“value”: “C2012”
},
{
“name”: “contact_status”,
“value”: “Contact Made”
}
],
“namespaceID”: “417307227982921729”,
“ownedBy”: “0”,
“createdAt”: “2025-07-30T14:51:43Z”,
“createdBy”: “0”,
“valueErrors”: null,
“canManageOwnerOnRecord”: true,
“canUpdateRecord”: true,
“canReadRecord”: true,
“canDeleteRecord”: true,
“canUndeleteRecord”: true,
“canSearchRevisions”: true,
“canGrant”: true
},
{
“recordID”: “9204516199356995584”,
“moduleID”: “447161390264745985”,
“values”: [
{
“name”: “legacy_case_id”,
“value”: “C3475”
},
{
“name”: “contact_status”,
“value”: “Contact Made”
}
],
“namespaceID”: “417307227982921729”,
“ownedBy”: “0”,
“createdAt”: “2025-07-30T14:51:43Z”,
“createdBy”: “0”,
“valueErrors”: null,
“canManageOwnerOnRecord”: true,
“canUpdateRecord”: true,
“canReadRecord”: true,
“canDeleteRecord”: true,
“canUndeleteRecord”: true,
“canSearchRevisions”: true,
“canGrant”: true
},
{
“recordID”: “9204338621119412224”,
“moduleID”: “447161390264745985”,
“values”: [
{
“name”: “legacy_case_id”,
“value”: “C6269”
},
{
“name”: “contact_status”
}
],
“namespaceID”: “417307227982921729”,
“ownedBy”: “0”,
“createdAt”: “2025-07-30T14:51:43Z”,
“createdBy”: “0”,
“valueErrors”: null,
“canManageOwnerOnRecord”: true,
“canUpdateRecord”: true,
“canReadRecord”: true,
“canDeleteRecord”: true,
“canUndeleteRecord”: true,
“canSearchRevisions”: true,
“canGrant”: true
},
{
“recordID”: “9201852455427110912”,
“moduleID”: “447161390264745985”,
“values”: [
{
“name”: “legacy_case_id”,
“value”: “C6594”
},
{
“name”: “contact_status”,
“value”: “Contact Made”
}
],
“namespaceID”: “417307227982921729”,
“ownedBy”: “0”,
“createdAt”: “2025-07-30T14:51:43Z”,
“createdBy”: “0”,
“valueErrors”: null,
“canManageOwnerOnRecord”: true,
“canUpdateRecord”: true,
“canReadRecord”: true,
“canDeleteRecord”: true,
“canUndeleteRecord”: true,
“canSearchRevisions”: true,
“canGrant”: true
},
{
“recordID”: “9200549652254918656”,
“moduleID”: “447161390264745985”,
“values”: [
{
“name”: “legacy_case_id”,
“value”: “C1494”
},
{
“name”: “contact_status”,
“value”: “Contact Made”
}
],
“namespaceID”: “417307227982921729”,
“ownedBy”: “0”,
“createdAt”: “2025-07-30T14:51:43Z”,
“createdBy”: “0”,
“valueErrors”: null,
“canManageOwnerOnRecord”: true,
“canUpdateRecord”: true,
“canReadRecord”: true,
“canDeleteRecord”: true,
“canUndeleteRecord”: true,
“canSearchRevisions”: true,
“canGrant”: true
}
]
}