Collect specific orders within order type in Demand history collections
Our client has a requirement to collect specific orders in some order types in the sales orders in OM. I see that Demantra has 'Collect Shipment and Booking History - ERP - V3' under that parameter 'Type Selection Method' with value 'Enter SQL query name from Table MSD_DEM_ENTITY_QUERIES'. User guide says that the user has to enter the query name stored in Table MSD_DEM_ENTITY_QUERIES in the " Include Order Types" or "Exclude Order Types" parameter fields which will return valid order type ids.
My doubt is, can we add an SQL query which will pull specific orders based on conditions in the order type in this option? Will it be able to filter other orders which we don't want to collect in this shipment and booking history collections? Can someone clarify?