Developer forum

Hi,

You can do this with a product(list) template extender. The information from the discount can be found in table EcomSalesDiscount; the Extranet group from column SalesDiscountCustomersAndGroups. Par this with the the current logged in users group relations.

Hope it makes sense - otherwise feel free to write back (I'll try to be more swift!)  :-)

Regards /Snedker

It makes sense and it is the same solution as I thought myself, but I I was hoping on a solution through the API. Because of the name convention it almost impossible to do it in one SQL. In AccessUser the AccessUserGroups is @256@ and in table  EcomSalesDiscount - SalesDiscountCustomersAndGroups the same groups is named as GRP_256

If I bypass the API and make the solution with a System.Data.IDataReader DR = Database.getDataReader("SELECT * FROM EcomSalesDiscount", "EcomSalesDiscount.mdb"); and then doing some compare of @256@ in the AccessUser table and the value GRP_256 In EcomSalesDiscount is it going to work in DW 8?

I believe it will.

You need a recompile and maybe update some namespace references, but data and format are the same.