hi, I am trying to runa report containing data from the MSP database (Oracle) and our finance database (Sybase)
our projects contatin severel text fields which are stored int he MSP_TEXT_FIELDS table.
that table has a field titled: TEXT_REF_UID
I am getting lots of duplicate records in my results, which I have discovered is due to the TEXT_REF_UID field.
each project has a main task name which then expands into other tasks.
Can anyone tell me if the top level task name is always TEXT_REF_UID = 0?
I want to be able to filter out the other results, and this is the only way I can to do it.
For some reason some of the text fields are not repeated wth a new TEXT_REF_UID number - but I have yet to learn how it all works!
our projects contatin severel text fields which are stored int he MSP_TEXT_FIELDS table.
that table has a field titled: TEXT_REF_UID
I am getting lots of duplicate records in my results, which I have discovered is due to the TEXT_REF_UID field.
each project has a main task name which then expands into other tasks.
Can anyone tell me if the top level task name is always TEXT_REF_UID = 0?
I want to be able to filter out the other results, and this is the only way I can to do it.
For some reason some of the text fields are not repeated wth a new TEXT_REF_UID number - but I have yet to learn how it all works!