APIv4 - how do I interact with option values???
In apiv3 I can filter on an option value by passing in the name. So
civicrm_api3('Contribution', 'get', ['contribution_status_id' => 'Pending'])
will retrieve me Pending contributions. By the same token the v3 api returns me the status of the contributions.
In the api explorer I don't see a way to do that. I DO see a way to JOIN the optionValue table in - but that literally joins the table in from the looks of so I would wind up with an unindexed join in my query
@colemanw I know you hate the apiv3 double loading but what is the apiv4 expectation here? I really don't want to have to do endless CRM_Core_PseudoConstant::getKey() calls on every line....