Skip to main content
15-Moonstone
Jul 28, 2016 5:30 AM UTC
Solved

IBA table and WTPart table relationship

Hi All,

IBA's for WTPart are stored in tables like StringDefinition, BooleanDefinition etc.

Then how do we relate these IBA's with WTPart table ?

Can you please let me know ?

Like if I have a demo as an IBA for WTPart and if I run a sql query like select * from stringdefinition I guess I can see that IBA name in that table.

Now for that IBA name which particular column in that table is related to WTPart table ?

so keeping stringdefinition table for IBA's and WTPart table beside which columns are related ?

Best Regards,

Aditya Achanta

20-Turquoise
Jul 28, 2016 4:39 PM UTC

Aditya Achanta wrote:

Hi All,

IBA's for WTPart are stored in tables like StringDefinition, BooleanDefinition etc.

Then how do we relate these IBA's with WTPart table ?

Can you please let me know ?

Like if I have a demo as an IBA for WTPart and if I run a sql query like select * from stringdefinition I guess I can see that IBA name in that table.

Now for that IBA name which particular column in that table is related to WTPart table ?

so keeping stringdefinition table for IBA's and WTPart table beside which columns are related ?

Best Regards,

Aditya Achanta

The values of the ibas are actually stored in the <type>value tables. ie stringvalue, booleanvalue, etc. The epmdocument or wtpart, that is the owner of the value, is defined in the classnamekeya4 and ida3a4 columns of these value tables.

2 replies

MarcoTosin
21-Topaz II
Jul 28, 2016 6:30 AM UTC

Aditya,

in this document Resource for reporting there are a couple of query builder report you can watch to have your answer.

Translate
Marco
20-Turquoise
Jul 28, 2016 4:39 PM UTC

Aditya Achanta wrote:

Hi All,

IBA's for WTPart are stored in tables like StringDefinition, BooleanDefinition etc.

Then how do we relate these IBA's with WTPart table ?

Can you please let me know ?

Like if I have a demo as an IBA for WTPart and if I run a sql query like select * from stringdefinition I guess I can see that IBA name in that table.

Now for that IBA name which particular column in that table is related to WTPart table ?

so keeping stringdefinition table for IBA's and WTPart table beside which columns are related ?

Best Regards,

Aditya Achanta

The values of the ibas are actually stored in the <type>value tables. ie stringvalue, booleanvalue, etc. The epmdocument or wtpart, that is the owner of the value, is defined in the classnamekeya4 and ida3a4 columns of these value tables.

Translate