Can you add an attribute to your building category for In Use/Not In Use?
You can then construct your filters to take this into account and then when buildings move between In Use/Out of Use all you have to do is check/uncheck this attribute in the one place.
Thanks Graham, but that would just mean filtering on attribute X instead of attribute Y. I would still to build separate filters each time.
I would like to create (and manage) one filter and reuse it multiple times.
You'll have to build a new filter rule each time but yes the queries themselves should be available whenever you need to build a filter rule on a specific attribute. I actually thought they were but I've just checked our test system and created a new query for a related attribute on an object. Checking the same attribute on another object reveals the previously created query is not available for selection.
Note that if you create a filter query via the query/report designer you have to specify the object you're filtering against which seems odd but there you go.
I thinik this is one of those that is on the borderline between bug and enhancement.
Hi David, Graham,
All filters are based on an object (ie. Location in your case) and have another object to filter against specified on them (ie. Incident). This is to allow runtime values to be used in the filter criteria. When you create a filter on the fly from Object Designer the object and filtered by object are set automatically for you, when you create a filter from Query and Report Designer you must specify these yourself.
A good example is on the assignment windows you have a filter on the User relationship. In the criteria it checks against the Group specified on the assignment to only show users that belong to the selected group. This filter is therefore tied to both the User object and the Assignment object. It can't be used anywhere else that has a link to User because the object its related to is not the Assignment object.
I hope that clarifies it. If I've just muddied the waters let me know!
Thanks for the explaination Stu, so filters are based on the relationship between object not on either of the objects themselves.
(I created a filter based on Location and filtered by Location, but this did not appear in the available filters)
Can you think of any way I can achieve what I want to do?
Can I filter the core list so all linked objects get a prefiltered list?