Hallo
we had to migrite some categories and now, i need to get all Objects, which still use this old category.
The category is yet removed from most of objects, but it's still available and joined in the llattrdata - Table
see attached screen:
Yello: the object
light green: the correct, new Category (5896653)
dark green: other correct Category (947430) - not involved in this issue
red: the old, removed Category (3343111), it's not anymore attached to the object
i need to filter out this objects and i need all the objects, wich still uses this old Category 3343111
The oly idffernce i see is the Value 50 in DefVerN. Redarding the Documentation this should be:
Table 2-104: LLAttrData Table Columns
| Name | Type | Size | Null Status | Primary Key | Foreign Key | Description |
| DefVerN | Number | 10 | Not Null | | X | The version
number of the
definition ob
ject (foreign
key to DVers-
Data.Version) |
First i do not see the relation by regarding this mentiond Table DVersData, i can not finde the Foreign Key values there in
Second i do not see how to find out, that this Category is not used anymore on this document.
Any hint?
Thomas
