Author Topic: Accessing cross reference information on an elemen  (Read 4386 times)

david.bowman

  • EA Novice
  • *
  • Posts: 11
  • Karma: +0/-0
    • View Profile
Accessing cross reference information on an elemen
« on: January 11, 2006, 03:23:45 pm »
I've been trying to get a list of the diagrams that an element cross references.

I can find direct relationships in the object model, but not the cross referenced ones.

Anyone achieved this via the automation interface?

thomaskilian

  • Guest
Re: Accessing cross reference information on an el
« Reply #1 on: January 13, 2006, 02:07:02 pm »
You might be able to do this with a SQL statement. Sorry that I have not time to look in more detail at this, but it's not too hard to test...

david.bowman

  • EA Novice
  • *
  • Posts: 11
  • Karma: +0/-0
    • View Profile
Re: Accessing cross reference information on an el
« Reply #2 on: January 29, 2006, 01:22:06 pm »
Quote
You might be able to do this with a SQL statement. Sorry that I have not time to look in more detail at this, but it's not too hard to test...


Thanks, I've been looking at this today, and to be honest can't even find where this information might be in the database.

Anyone got any ideas where this type of cross reference information is stored in the DB?

D.

Bruno.Cossi

  • EA User
  • **
  • Posts: 803
  • Karma: +0/-0
    • View Profile
Re: Accessing cross reference information on an el
« Reply #3 on: January 29, 2006, 02:43:57 pm »
Hi,

not quite sure what do you mean by "a diagram that an element cross-references". Do you mean diagrams that the element appears on? If so, look at t_diagramobjects.

Hope this helps!
Bruno

Quote

Thanks, I've been looking at this today, and to be honest can't even find where this information might be in the database.

Anyone got any ideas where this type of cross reference information is stored in the DB?

D.


david.bowman

  • EA Novice
  • *
  • Posts: 11
  • Karma: +0/-0
    • View Profile
Re: Accessing cross reference information on an el
« Reply #4 on: January 30, 2006, 01:30:33 am »
Quote
Hi,

not quite sure what do you mean by "a diagram that an element cross-references". Do you mean diagrams that the element appears on? If so, look at t_diagramobjects.

Hope this helps!
Bruno



Hi,

There is an option in EA to 'Add a diagram as a reference' you find it by looking at an element and then selecting 'See Also...' from the context menu of that element.

So I found where EA is holding this reference data in the t_xref table, which seems to hold custom properties, swimlanes and this particular type of reference. What I can't find is how to get at this information. If I look at the custom properties of an element I don't see the particular references I'm looking for (arrrgh).

So Sparx people or EA gurus - what's a guy to do to get these ???

Thanks,

D.