Skip to main content
A
aachanta15-Moonstone
15-Moonstone
July 28, 2016
Solved

IBA table and WTPart table relationship

  • July 28, 2016
  • 2 replies
  • 2610 views

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

Best answer by RandyJones

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
MarcoTosin21-Topaz I
21-Topaz I
July 28, 2016

Aditya,

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

Marco
    R
    RandyJones20-TurquoiseAnswer
    20-Turquoise
    July 28, 2016

    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.

    Terms & ConditionsAccessibility statement