1 Reply Latest reply on Sep 20, 2015 8:31 PM by jross

    Question regarding Query Criteria

    Apprentice

      Hi all,

       

      I am attempting to create a query in LANDesk that will do the following:

      List all jobs logged between certain dates AND:

      1. Logged by a Specific Person OR Group
      2. Updated by above defined person or Group
      3. Resolved by above defined person or Group

       

      Is it possible to reference one criteria within another?

      I.E I have defined all jobs logged by a specific user between two dates, but also need to know which jobs were updated/resolved by that user.

       

      Is it possible to set as:

      Creation Date Is Between Dates Prompt User

      AND

      Created By.Title is Equal to Prompt User

      OR

      Created By.Create Group is Equal to Prompt User

      OR

      Notes.Created By.Title is equal to Created By.Title (Is this possible, or another method available to reference a previous criteria?)

        • 1. Re: Question regarding Query Criteria
          Apprentice

          Updated, because of the way OR statements work, I am using advanced Criteria for this query

          So it's set out similar to (1 AND 2 AND 4) OR (1 AND 3 AND 4)

           

          Consider two separate queries one regarding a specific user, another regarding a specific group. But need to know if the criteria can be set to the results of a previous criteria