Forums / Reporting Questions and Feedback / Using PITs in a Static query to pull interrogations in a second query

Using PITs in a Static query to pull interrogations in a second query

2 posts, 0 answered
  • Cindy Fitzgerald
    cfitzgerald avatar
    7 posts
    Registered:
    15 Feb 2013
    16 Apr 2014
    I created a static query of a list of PITs based on certain query criteria.  That static query list of PITs is then used in a second query to pull interrogation data for those PITs.  My question is, when I run the second query, does it also rerun/refresh the first static query data?  Or is the list of tags from the static query unchanged from the last time I generated the static query data?
    Link to this post
  • Nicole Tancreto
    NTancreto@psmfc.org avatar
    64 posts
    Registered:
    21 Feb 2012
    17 Apr 2014 in reply to cfitzgerald
    The static query is updated every time you run the report in which it is used as a filter. The 'static' refers only to the report objects which cannot be changed, not to the results set, which is updated whenever it is run.
    Link to this post