Comment 21 for bug 971989

The column name was a mistake when typing up the response in Launchpad, I meant current_copy. Likely due to me looking at other parts of the system while waiting on queries. If I had been running the actual queries with the wrong column names I would have gotten errors back pretty much right away.

As for my test queries, the overall goal was to see what would happen if one attempted to use the ahopl IDL view to generate a pull list. To do so you would need to either:

1 - Link to the asset.copy to get the circ library of the copy and filter on that

or

2 - Get *all* "pull list" holds from everywhere so that you could do said filtering client side (requesting copy information as you go along, or fleshing copy information and filtering as you get results back).

I am not sure which method the flattener stuff uses. The first method was tested with my first couple of queries with the join to asset.copy and limit the circ library, the second was tested with the last couple of queries before the explain analyse where I ran the query without any wrappers or limits.