Select specifc row from database

I need to show all the orders that are with an "A" in my database database

this is the if-statement I have right now

this.order = JSON.parse(localStorage.getItem("order"));
    if(this.order.estadocompra == "A"){
      this.searchOrders();
    }else{
      if(this.order.estadocompra != "A"){
        location.href = "/";  }
      } 
    this.searchOrders();
  }

So at the end I want to show just the row that has the "A"