I need to show all the commerce products which lies in same catalog, have same type and have same vendor user irrespective of their statuses. To do this, I’ve written the following java code to query elastic. However, I’m only able to fetch the approved products.

I’ve created a custom field at Liferay commerce product Level. Everytime a product is created, I’m storing the user’s organization ID in that custom field. Now, I’ve a requirement to display user specific products in the search results and other related facets.