Developer forum

Forum » Development » Missing VariantGroupProductRelationSorting

Missing VariantGroupProductRelationSorting

E-mail notifications
Anders Ebdrup
Anders Ebdrup
Reply
Posted on 29/10/2020 16:10:26

Dear Dynamicweb,

 

Vi have an issue with "wrong" variant group sorting (please find this image: https://www.screencast.com/t/mLrKO3eNzp), but the sort order is correct in the database.

Can you please add this section: "ORDER BY VariantGroupProductRelationSorting" to the line marked with red

 

        Public Overridable Function GetAllVariantGroupProductRelations() As IEnumerable(Of VariantGroupProductRelation)
            Dim sqlBuilder As New CommandBuilder()
            sqlBuilder.Add("SELECT * FROM EcomVariantgroupProductRelation ")

            Dim result As New List(Of VariantGroupProductRelation)()
            Using dataReader As IDataReader = Database.CreateDataReader(sqlBuilder)
                While dataReader.Read()
                    Dim relation As VariantGroupProductRelation = FillVariantGroupProductRelation(dataReader)
                    result.Add(relation)
                End While
            End Using

            Return result
        End Function

 

Best regards, Anders

 


Replies

 
Olga Shedko Dynamicweb Employee
Olga Shedko
Posted on 30/10/2020 02:21:30
Reply

Hello Anders,

New tfs #86990 has been added for fixing that one to the next hot-fix release. Thank you.

Best regards,

Olga | QA

 

 
Nicolai Pedersen
Posted on 30/10/2020 08:31:26
Reply

Hi Anders

We are just looking at the implications of this change - it is not a simple fix as it would have bad consequences for those solutions which happens to not have a sort value. Which is everyone.

We might be able to enable the sorting. But there is so much logic related to this that it would a very high risk change that needs a lot of testing. I agree that the lack of an order by statement particular on this table is a problem wether it be the sortorder or the order of which the records are created (which is how it works now).

As a workaround in the meantime could be to add a clustered index on the productid/sort columns.

BR Nicolai

 
Stanislav Smetanin Dynamicweb Employee
Stanislav Smetanin
Posted on 30/10/2020 09:29:25
Reply

Hi Anders,

Looks like the error which you found in Ecommerce product list is not related with wrong sort order. I think that some variant option from Settings -> Ecommerce -> Product catalog -> Variants was removed, but was not removed from the [EcomVariantOptionsProductRelation] table. 

So "wrong order" is because EcomVariantOptionsProductRelation table has variant-product combination pair, but this variant option is not exist (if this is the reason of problem).

So you can check it by next sql query:

 SELECT DISTINCT VariantOptionsProductRelationProductId FROM  [EcomVariantOptionsProductRelation]

 WHERE VariantOptionsProductRelationVariantId NOT IN 
 (
SELECT VariantOptionsProductRelationVariantId FROM [EcomVariantOptionsProductRelation]
  INNER JOIN EcomVariantsOptions ON EcomVariantsOptions.VariantOptionId = [EcomVariantOptionsProductRelation].VariantOptionsProductRelationVariantId
 ) AND VariantOptionsProductRelationProductId = 'YourProductId'

 

Could you please run it and say if your product in this returned list?

 

Kind regards.

 
Anders Ebdrup
Anders Ebdrup
Posted on 30/10/2020 09:42:23
Reply

Dear Stanislav,

 

Nicolai suggestion solves the issue for now, and your query returns our product id.

 

Best regards, Anders

 

You must be logged in to post in the forum