Problem:

I aim to pass a value from a custom field "product id" on a custom post type template "brands" to another view displaying fields from a different custom post type "products." However, I am uncertain about creating a custom shortcode to achieve this.

Solution:

You're on the right track. Utilize code similar to the example provided in the Toolset forum (https://toolset.com/forums/topic/how-to-pass-a-variable-to-a-view/#post-380479) as a starting point. Additionally, refer to Toolset documentation for adding custom code (https://toolset.com/documentation/programmer-reference/adding-custom-code/using-toolset-to-add-custom-code) and passing arguments to views via shortcodes (https://toolset.com/documentation/legacy-features/views-plugin/passing-arguments-to-views/).

Relevant Documentation:

Toolset forum example: https://toolset.com/forums/topic/how-to-pass-a-variable-to-a-view/#post-380479
Toolset documentation:

Adding custom code: https://toolset.com/documentation/programmer-reference/adding-custom-code/using-toolset-to-add-custom-code
Passing arguments to views: https://toolset.com/documentation/legacy-features/views-plugin/passing-arguments-to-views/

Problem:
Search for posts with custom post status in views not working
Solution:
I checked it and the issue was with the third filter: Filter by post relationship or repeatable fields group owner.

With it disabled, the filter by status was working fine.

I checked it and it seems like the Owner participates of two different relationships. By selecting the only one relationship, it somehow was impacting with the status filter.

I changed it slightly, updating it to check if the current item in the loop has any relationship with the current owner.

And that seems to have fixed the issue.
Relevant Documentation:
https://developer.wordpress.org/reference/functions/get_post_statuses/
https://developer.wordpress.org/reference/functions/update_post_meta/