xproperty not showing on the database
- 5 years ago
hello
i have a better understanding of what is happening,
i think because i imported the component engineering package too many times because of mis understanding of an aror message,
this actually imported a big number of xproperty and i have now 21 tables of xpropertyvalues and the new one am creating are on the 21st table thus separated from the first ones i created before all those imports.
i'm actually requesting xproperty values in an action and i use apply sql, i know its not recomended but i'm first trying to make it work through sql and later i will pass it to iom
my sql request looks somthing like this
SELECT xcl.[NAME], mnfp.KEYED_NAME
FROM [InnovatorSolutions].[innovator].[MANUFACTURER_PART] as mnfp
inner join [xp].[XPROPERTYVALUES] as xp on xp.[item_id] = mnfp.ID
inner join [innovator].[MANUFACTURER_PART_XCLASS] as mnfXc on mnfp.ID =mnfXc.SOURCE_ID
inner join [innovator].[XCLASS] as xcl on mnfXc.RELATED_ID = xcl.ID
WHERE [xp-tolerance] <'-5'and xcl.[NAME] ='resistor'i make a join with the xpropertyvalues but since my props are separated on two tables i either need to join the two tables or move all the properties to one of them. i'm still not sure which way is best and if u have a better solution i would love to hear about it.
thanks
lucas