Book a Demo

Author Topic: Accessing EA_Requirement::priority with SQL  (Read 6353 times)

philipp.k

  • EA Novice
  • *
  • Posts: 10
  • Karma: +0/-0
    • View Profile
Accessing EA_Requirement::priority with SQL
« on: March 21, 2024, 07:32:34 pm »
Hi together!

For my collection of (SysML) requirements, I use "SysML 1.5::functionalRequirement" as Stereotype.
In the Properties window of elements from that type, there is a "Priority" attribute under the "Requirement" section, which can be set to "Low", "Medium" or "High".

Now I am writing an SQL search which shall give me all requirements which are set to "Low" for example.
The tagged values from "FunctionalRequirement (from SysML 1.5)" I can access with the t_objectproperties table, but there is no tagged value for "priority"?

Does anybody know in which table this priority attribute is stored?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Accessing EA_Requirement::priority with SQL
« Reply #1 on: March 21, 2024, 08:37:32 pm »
Probably in t_object.PDATA2 or t_object.PDATA3

Geert

philipp.k

  • EA Novice
  • *
  • Posts: 10
  • Karma: +0/-0
    • View Profile
Re: Accessing EA_Requirement::priority with SQL
« Reply #2 on: March 21, 2024, 08:50:25 pm »
Geert, you are the hero!

I can confirm, "Priority" is stored in t_object.PDATA2.

Thx, Philipp