A list of products are to be made inactive in the system.
The requirement here is how to remove these products from the flexible search. For example,
select * from Products;====>{A,B,C}
Now product B has been made inactive. So the solution that I require is how to display as follows:-
select * from Products;====>{A,C}
As per my knowledge , this can be achieved by adding a flag to the products to be deactivated and them filter out them.
But is there some other optimal way to accomplish this, without the addition of this new flag?