SI_CHILDREN Property

building reports crystal reports
1

Does anyone know how to view the actual names of the SI_CHILDREN property in the business objects query builder?

rwiggins (BOB member since 2010-12-30)

2

Probably the easiest way is to run a query like this:

select si_id, si_name from ci_infoobjects, ci_systemobjects, ci_appobjects where si_parent_id = <ID of the object with the si_children entries>

BoB LoblaW :us: (BOB member since 2007-10-23)

3

I think that is a start in the right direction, but I then get all of the folders that have an ID less than that one. The problem with that is the folders that are listed are not necessarily children of the particular folder I am wanting. Thank you, I will try to work with that.

rwiggins (BOB member since 2010-12-30)

4

Do not use a less than sign. Substitue this:

<ID of the object with the si_children entries>

With the ID of the object that contains the si_children property. So if you ran a query on a folder with ID 12345, your query for the child names would be:

select si_id, si_name from ci_infoobjects, ci_systemobjects, ci_appobjects where si_parent_id = 12345

BoB LoblaW :us: (BOB member since 2007-10-23)

5

Well that worked! I did make one change though - instead of si_parent_id I wrote as si_parentid. Not sure if that was what did it, but got what I needed. Thank you!!

rwiggins (BOB member since 2010-12-30)

6

Oops, that was a typo on my part. Glad it worked for you :mrgreen:

BoB LoblaW :us: (BOB member since 2007-10-23)