DDC-2791: Constant value in JoinColumn #3540

Open
doctrinebot opened this Issue Nov 13, 2013 · 0 comments

2 participants

@doctrinebot

Jira issue originally created by user pahhan:

My situation:
I have realty entities (flat, house, ...) they have hundreds parameters, wich title places in REFERENCE table. For example House has a few floor materials (stone, wood, etc.) and I want to get them. But each parameter type defined by type_id field in REFERENCE table, for example for floor material is's 115. My raw SQL:
SELECT h.id,... FROM HOUSE h
LEFT JOIN objectdetail mf /material_floor/ ON mf.realty_id = h.id AND mf.data_class = h.data_class AND mf.typeid = 115
LEFT JOIN Reference mfr ON mfr.cityid = h.city_id AND mfr.id = mf.detailid

And its not possible to set type_id directly in join table

@beberlei beberlei was assigned by doctrinebot Dec 6, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment