I am using version 220.127.116.1126. I have a query set up which should give me a list of all assets that have been installed but where the asset didn't replace an existing asset, ie it was a new computer that was installed for a new member of staff, not a new computer that was installed to replace an old one as part of our 'refresh' program. The query should list all assets that have been taken from stock (the status of our assets starts off as 'new - unassigned') and where the asset has been installed for a new member of staff (the status of which will have then been changed to 'live'). The query contains the following criteria:
When I run the query though, although most of the assets listed do not have any data in the Replaced by BBC Asset attribute, there are a few that do and I don't understand why it has included these in the results. Does anyone know why it includes some assets in the results when the attribute is not empty?