On Tue, Jul 25, 2023 at 12:27:21PM -0400, Benneth Obilor wrote:
> Thank you Mark.
Don't thank me too soon: I forgot to filter out other types of
objects. Try this instead:
SELECT v.dspace_object_id AS "Collection number",
v.text_value AS "Collection Name"
FROM metadatavalue AS
Thank you Mark.
On Tue, Jul 25, 2023 at 11:49 AM Mark H. Wood wrote:
> On Tue, Jul 25, 2023 at 05:48:38AM -0700, Benneth wrote:
> > Please which table in dspace postgreqsl can i find the mapping of all
> > collection names and their numbers.
> >
> > ie Collection number Collection Name
> >
On Tue, Jul 25, 2023 at 05:48:38AM -0700, Benneth wrote:
> Please which table in dspace postgreqsl can i find the mapping of all
> collection names and their numbers.
>
> ie Collection number Collection Name
> - -
>-
Please which table in dspace postgreqsl can i find the mapping of all
collection names and their numbers.
ie Collection number Collection Name
- -
- -
- -
--
All