Sounds like you need to query the posts by custom field, as explained at https://developer.wordpress.org/reference/classes/wp_query/#custom-field-post-meta-parameters (and do a separate query for posts NOT containing the custom field value, or whatever).
