5 Replies Latest reply on Nov 22, 2010 5:04 AM by David.Briggs

    I want to use an attribute filter more than once

    Rookie

      I have a Location category consisting of building, floor, room. This is linked to the End User and Incident objects to provide a default location for the user and a location of the incident (I use copy settings to set the incident location to the user location by default).

       

      One of the building is not currently in use (for the medium term) and therefore I have added a new filter on the Incident location attribute to hide building X (and therefore it's floor and rooms) and called this "location building filter".

       

      I would like to reuse this same "location building filter" filter on the End User location attribute, but there are no available filters shown and there is only an offer to create a new filter.

       

      It seem a bit silly that I would have to create a second filter that does exactly the same as the first filter, call it "location building filter2" and then have to update two filter instead of one when the building comes back into use.

       

      (ITBM 7.3.1)

        • 1. Re: I want to use an attribute filter more than once
          gramsay Specialist

          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.

          • 2. Re: I want to use an attribute filter more than once
            Rookie

            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.

            • 3. Re: I want to use an attribute filter more than once
              gramsay Specialist

              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.

              • 4. Re: I want to use an attribute filter more than once
                Stu McNeill Employee

                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!

                • 5. Re: I want to use an attribute filter more than once
                  Rookie

                  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?