Join review
join_reviewQuestion a join on the map, add one it missed, or report counts on a review: what you and your human found testing the map. It changes no system; a person decides on Business map › Glossary, but agreeing counts on a review Maplith opened, from a key that may act, mark that join tested. op flag opens a join review and a join_review signal whose task context says what to count in your human's own systems: name the two objects as the map spells them and a reason (wrong_key, wrong_direction with cardinality read from → to, not_related, works_like_this with how in note, or missed with the key or a note); for a join on the map pass its key exactly as route or get_object gave it. Maplith answers with its own evidence first: if it contradicts the claim nothing is opened and the outcome is contradicted, with the evidence to show your human; only if they still say it is wrong call again with confirm: true. Other outcomes: opened (with review_id and then, the report call), exists, on_map. op report records the counts as the evidence on a review that exists (review_id from the signal's task context or from flag): left_distinct, right_distinct and matched_distinct with sampled are required; a fraction, a negative, counts that cannot all be true or a note over 300 characters refuses the whole report. Never send a value, a row, a name or an id from the data. Show your human the numbers first.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| op | Yes | flag: open a review of a join (from, to, reason, key?, cardinality?, note?, confirm?). report: add measured counts to a review (review_id, measurement). | |
| to | No | flag: the other object. | |
| key | No | flag: the key; for a join on the map, its join_spec exactly as route or get_object gave it; for a missed join, from's file and column on the left, to's on the right. | |
| from | No | flag: one object, as the map spells it. | |
| note | No | flag: how it works, in your human’s words. Required for works_like_this, and for missed without a key. No values from the data. | |
| reason | No | flag: wrong_key, they do not join on this key; wrong_direction, direction or count is wrong (give cardinality); not_related, no join at all; works_like_this, it works differently (say how in note); missed, a join the map lacks (give key or note). | |
| confirm | No | flag: true to open the review although Maplith’s evidence contradicts it, only after your human has seen the evidence. | |
| review_id | No | report: the review, from get_task_context (join_review.review_id) or from the flag answer. | |
| cardinality | No | flag, wrong_direction (required) and missed: the right shape, read from → to: 1:1, 1:N, N:1 or N:M. | |
| measurement | No | report: counts from your own measurement, never a value. |