kanmanimonad mainnet · 143

Claims

One row per evidence document carrying a URI. Ordered newest first by the block the feedback was recorded in. There is no score and no ranking here, because a list of other people's documents sorted by an opinion of ours would be exactly the thing this site argues against.

re-derive this
SELECT f.id, f.agent_id, f."clientAddress", f."feedbackIndex", f.value, f."valueDecimals",
       f.tag1, f.tag2, f.endpoint, f."feedbackUri", f."feedbackHash", f.revoked,
       f."responseUri", f.responder, f."blockNumber", f.timestamp, f."txHash",
       a."agentId" AS agent_number, a.name AS agent_name,
       v.outcome, v.rung, v.reason, v.declared_network, v.declared_tx, v.mapping,
       v.hash_matches, v.computed_hash, v.found_chain, v.found_chain_id, v.found_block,
       v.checked_at, v.checked_at_block
FROM "Feedback" f
JOIN "Agent" a ON a.id = f.agent_id
LEFT JOIN fovea.verdict_latest v ON v.feedback_id = f.id
WHERE f."chainId" = $1 AND f."feedbackUri" <> '' AND v.outcome = $2 AND v.mapping = $3
ORDER BY f."blockNumber" DESC, f.id
LIMIT $4 OFFSET $5