Modify ↓

Opened 8 years ago

Last modified 3 years ago

#1247 new Erweiterung

Tabelle newsletter_recipients Spalte gender fehlt

Reported by: Volker Strähle Owned by:
Priority: normal Milestone:
Component: Module Version: 2.0.2.2
Keywords: Cc:
Blocked By: Blocking:

Description (last modified by Torsten Riemer)

Es ist schwierig personalisierte Newsletter zu erstellen, wenn die Tabelle Newsletter kein Feld für das Geschlecht vorsieht.

Analog zu Tabelle customers sollte customers_gender ergänzt werden.

Attachments (0)

Change History (4)

comment:1 by Torsten Riemer, 8 years ago

Description: modified (diff)
Milestone: modified-shop-2.0.3.0 → modified-shop-2.0.3.1
Version: 2.0.0.0 → 2.0.2.2

comment:2 by Torsten Riemer, 8 years ago

Milestone: modified-shop-2.0.4.0

comment:3 by Torsten Riemer, 3 years ago

Das wurde in Ticket #2438 nochmal gemeldet.

comment:4 by oneQ, 3 years ago

Man könnte hier auf die customers Tabelle joinen um zumindest von den registrierten Kunden diese Information zu erhalten. In etwa

SELECT nr.*, c.customers_gender, MD5(nr.customers_email_address)
FROM newsletter_recipients nr
         LEFT JOIN customers c ON c.customers_id = nr.customers_id
WHERE nr.mail_status = '1'

Die where-clause entsprechend dem Filter.

Modify Ticket

Action
as new The ticket will remain with no owner.

Add Comment
E-mail address and name can be saved in the Preferences .
Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.