counting current loans by item type and home site
I am trying to produce a report of items currently on loan. I have tried using the total current loans measure but when I add in the item barcode dimension to check the results I am finding that the report is including items that are not currently on loan.
I am using query filters
items types and homes sites = in list
result objects
home site, item type, item barcode and total current loans
the total current loans count is the same whether I include the item barcode in the results or not so I don't think that including this in the results is causing the problem.
I have tried a similar query using the limit to current issues option from the loans folder ( I think this seems to insert the same SQL dbo_LOAN1.CURRENT_LOAN='T' into the query anyway) and the results are as you might expect exactly the same.
Is there a problem with the data in the CURRENT_LOAN field? or with my query?
thanks for any help
Lin
Hello Lin I think you need
Hello Lin
I think you need to use the Limit to Current Issues object.
What are you trying to get out of the query? The list of Items barcodes currently on loan? If so then you do not need to include Total current Loans in the query results.
Iain
Hi Iain thanks for the
Hi Iain
thanks for the reply, I put the barcode details in so that I could check the results against Alto, I do just need the totals really ...but....
I am yet again a numpty, our dump2disk on MIS has been failing so I was running the query against old data and checking on live
if I live a long time I might learn
or maybe it's the heat?
cheers
Lin