I need to filter out the rows where TranType is like “STK-SHP” and Priority = 5. The 10.1 retrieved the data on load, now we are on 10.2 and Epicor added the Retrieve button. The fun fact is that the filter added to the MaterialQueueEntryForm_Load event handler still works when the retrieve button is pressed. So when:
private void MaterialQueueEntryForm_Load(object sender, EventArgs args)
{
EpiDataView edvUnselected = ((EpiDataView)(this.oTrans.EpiDataViews[“Unselected”]));
edvUnselected.AdditionalFilter = “Priority = 5 AND TranType LIKE ‘%STK-SHP%’”;
}
the only row which appear is STK-SHP with priority 5. When I change it to “Priority < 5 AND TranType NOT LIKE ‘%STK-SHP%’” the filter does not work, SIC!
Could you advise me on the best method to filter the data view, please?
Brings back nothing. This is one reason I asked for help. The behaviour is inconsistent. I tired NOT LIKE as well
The other question I have is why the on load works after pressing retrive button?