2 Replies Latest reply on Feb 23, 2021 2:28 AM by Andreas Bühler

    Joining Party and ArticleRevision table

    Mohsin Asif Active Member

      Hi,

       

      We have manufacturer information in Party table in pim db and items information in ArticleRevision table. How do we join these two tables to get all items by a particular manufacturer? Thanks.

        • 1. Re: Joining Party and ArticleRevision table
          Lokesh Kumar Guru

          Hi

           

          If the field being referred here is Article.ManufacturerName then the value should be stored under ArticleDetail table and so you can join with ArticleRevision table where Manufacturer is stored here:

           

          select Identifier from [PIM10_MASTER].[dbo].[ArticleRevision] where ID in (select ArticleRevisionID from [PIM10_MASTER].[dbo].[ArticleDetail] where ManufacturerName='Manufacturer1')

           

          Else if it is a different datamodel where the column stores the ID then you might have to join with MAIN schema Party table along with ArticleRevision and ArticleDetail (depends on data model).

           

          - Lokesh Kumar

          • 2. Re: Joining Party and ArticleRevision table
            Andreas Bühler Guru

            Hi Mohsin,

            what is the use case for this?

            Direct access to the database tables is not supported in Product 360 and can lead to

            performance or stability issues.

            If you need access to data you should use the REST based Service API to do that.

            You can also execute search queries there which should fulfill all your requirements.

             

            Greetings

            Andreas