So you need to take all the row based on these two scenarios “Interface to EBS” and “Cancelled”. In other case you don’t get the rows, right? For example, if you have a value like “Pending” you want to ignore it and take only the first two cases, right?
If that’s the case you will need to work with the OR operator because your row will never have the “Interface to EBS” and “Cancelled” inside of it.
Your query need to be created thinking in a row to row scenario. Or your Queue will have the value “Interface to EBS” or “Cancelled” or “AnotherString”
So the approach with Or that I mention earlier will solve your case
Your first row from your column Queue will never have “Cancelled” and "Interface to EBS” inside of it. Your row will have “Cancelled” or "Interface to EBS” inside of it.
So the query will read the value from your Queue column based on the first row of your table. If it has “Cancelled” or "Interface to EBS” all the row will be stored.
Then the query will check the second row from your table and if the value in the Queue column has a string “Cancelled” OR "Interface to EBS” all the row will be stored in your datatable variable. If the value from your Queue isn’t what you expect, the row will be disconsidered.
The asenumerable will loop for every row of your table, checking the value that you passed based on your column name