Book a Demo

Author Topic: Query for TaggedValue  (Read 2997 times)

Gokcen Guner

  • EA User
  • **
  • Posts: 24
  • Karma: +0/-0
    • View Profile
Query for TaggedValue
« on: October 31, 2013, 06:00:22 am »
Hello,
I need to query elements that has certain taggedvalue names like eventDefinition or activityType. Can I query for elements like 'elements that have activityType=Task'?

Thank you.

KP

  • EA Administrator
  • EA Expert
  • *****
  • Posts: 2919
  • Karma: +55/-3
    • View Profile
Re: Query for TaggedValue
« Reply #1 on: October 31, 2013, 08:58:44 am »
You could start with something like this:

Code: [Select]
SELECT * FROM t_object, t_objectproperties
WHERE t_object.Object_ID=t_objectproperties.Object_ID
AND t_objectproperties.Property='activityType'
AND t_objectproperties.Value='Task'
The Sparx Team
[email protected]

Gokcen Guner

  • EA User
  • **
  • Posts: 24
  • Karma: +0/-0
    • View Profile
Re: Query for TaggedValue
« Reply #2 on: October 31, 2013, 10:03:22 am »
Thank you so much.