P
Peter Jacobsen
Hi,
we want to set up a query, which shows us all projects stored in the
database with some enterprise fields. So we query the MSP_PROJECTS table and
extract some enterprise files form i.e. MSP_TEXT_FIELDS. We now have a
problem with the field 188744733, which is a Enterprise Project field. It's
not unique for a project, there are several records with the same
TEXT_FIELD_ID and PROJ_ID, they have different TEXT_REF_UIs. But this only
makes sence for me if the field is for a task, not for a project.
Any idea?
Peter
we want to set up a query, which shows us all projects stored in the
database with some enterprise fields. So we query the MSP_PROJECTS table and
extract some enterprise files form i.e. MSP_TEXT_FIELDS. We now have a
problem with the field 188744733, which is a Enterprise Project field. It's
not unique for a project, there are several records with the same
TEXT_FIELD_ID and PROJ_ID, they have different TEXT_REF_UIs. But this only
makes sence for me if the field is for a task, not for a project.
Any idea?
Peter