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

mldet · June 11, 2025, 12:28pm

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.

jfortun · June 11, 2025, 1:04pm

@tjerman ,do you have any ideas?

tjerman · June 11, 2025, 2:45pm

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

mldet · June 11, 2025, 3:14pm

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

mldet · June 13, 2025, 1:44pm

@tjerman Did you need something different from me?

tjerman · June 13, 2025, 2:29pm

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

mldet · June 13, 2025, 4:16pm

@tjerman Here you are.

mldet · July 2, 2025, 11:30am

@tjerman and @jfortun Any advice here?

tjerman · July 25, 2025, 1:18pm

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.

emmanuel · July 30, 2025, 3:01pm

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
}
]
}