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

    Joining Party and ArticleRevision table

    Mohsin Asif Active Member
    Mohsin Asif Feb 22, 2021 8:06 AM

      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.

      • 31 Views
      • Tags:
        • 1. Re: Joining Party and ArticleRevision table
          Lokesh Kumar Guru
          Lokesh Kumar Feb 22, 2021 12:38 PM (in response to Mohsin Asif)

          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
            Andreas Bühler Feb 23, 2021 2:28 AM (in response to Mohsin Asif)

            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