Hide Server Connect data results based on another SC result

Then I suppose you could use Array List for that and:

  • create an ArrayList id=newProducts...
    (Define the schema like the products schema)
  • Then add a new/extra field prd_Sold(boolean) on the newProduct ArrayList (you see why at the next step)
  • Create a repeat on the one products API and compare to the orders(products ordered from client).
  • Add a condition step and if the product_id exists in the orders api then set the prd_Sold(boolean)==true otherwise false.

This way, you have a query with all the produts and on your page you can filter by prd_Sold==false to show only the products that have not been ordered by the client

Something like that...

*More about Array Lists in this great tutorial from Hyberbytes: