Originally posted on Trac by gaspard Original Trac Ticket
Description
Make it possible to use DynamicAttributes? when opening contexts
in zafu :
...
To do this we would have to make a join with versions and
dyn_attributes :
nodes --- versions --- dyn_attributes
Here is an SQL example on how this could work:
SELECT * FROM nodes INNER JOIN versions ON versions.node_id =
nodes.id INNER JOIN dyn_attributes AS da1 ON da1.owner_id =
versions.id AND da1.owner_table = 'versions' INNER JOIN
dyn_attributes AS da2 ON da2.owner_id = versions.id AND
da2.owner_table = 'versions' WHERE da1.key = 'assigned' AND
da1.value = 'gaspard' AND da2.key = 'priority' AND da2.value =
'major'
Remarks:
we have to make an inner join for each dynamic attribute in the
query ==> reason for using content tables: max 2 joins.
Trac Attachments
Trac Comments
2007-08-13 12:51:02 changed by gaspard
status changed from new to assigned.
milestone changed from 1.0 to 0.8.
status changed from new to assigned.
milestone changed from 1.0 to 0.8.
2007-08-14 16:07:22 changed by gaspard
(In [699]) More work on relations. Implemented
dynamic attributes query with parameters. Refs #39 Dynamic attributes query. Fixes
#43 Add functions for scoping date queries in pseudo sql and
#44 Parameters in pseudo sql query.
2007-08-14 17:25:54 changed by gaspard
(In [701]) More work on relations. Need to write
the proxy, link edit stuff and it will be nearly done. Refs
#39 Dynamic attributes query.
2007-08-17 09:03:41 changed by gaspard
(In [HEAD]) Finished rewriting relations/links. Fixes #1 Rewrite of relations and #39 Dynamic attributes query.
status changed from assigned to closed.
resolution set to fixed.
(In [HEAD]) Finished rewriting relations/links. Fixes #1 Rewrite of relations and #39 Dynamic attributes query.
status changed from assigned to closed.
resolution set to fixed.
Gaspard Bucher