Skip to main content
J
JensN.1-Visitor
1-Visitor
April 24, 2014
Question

[IM] query-question: how to filtering for siproject-fields?

  • April 24, 2014
  • 2 replies
  • 2609 views

Hi @all,

it seems that i cannot use siproject-fields in the query-builder. Is there any other way to filter over such fields?

thanks, Jens

    2 replies

    K
    KaelLizak16-Pearl
    16-Pearl
    May 1, 2014

    Hello Jens,

    What kind of query, exactly, are you trying to build?

    Regards,
    Kael

    J
    JensN.1-VisitorAuthor
    1-Visitor
    May 2, 2014

    Hi Kael,

    we want to see two things:

    1. is an item in integrity connected to a checkpoint in source via siproject (we know changepackages, but thats not what we want) or not.

    2. if an item is connected, than we want to know the exact entry in this siproject-field.

    Both isnt possible with queries (or any other ootb-functionality) or not?

    regards, Jens

    M
    mrump16-Pearl
    16-Pearl
    May 5, 2014

    Hi Jens,

    I totally agree that there is something missing in the PTC query framework when it comes to source .

    Nevertheless, there might be a workaround using Computed Expressions:

    At least in Reports I verified that you can use something like this:

    Length("SI Project") > 0?true:false

    to identify issues that have any SI project link.

    OR

    Locate(text("myProjectName"), "SI Project") > 0?true:false

    to identify issues that have a SI project link to a specific project.

    I am quite sure you can use these as dynamically computated fields in your item setup as well.

    Than it should be possible to query these fields.

    HTH

    Matthias

      T
      tketz1-Visitor
      1-Visitor
      May 28, 2014

      Hello Jens,

      i totally agree with you and Matthias too, that here is something missing.

      We have another work around with a Trigger.

      When we use a SI project field, we also have fields like "SourceProject" and "Checkpoint". These fields are not editable and filled from a trigger, every time the SI Project Field was changed.

      Hope that helps.

        Terms & ConditionsAccessibility statement