Dynamic attributes query
Reported by Gaspard Bucher | September 3rd, 2008 @ 12:47 PM | in public beta
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. Fixes #43 and #44.
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.
2007-08-17 09:03:41 changed by gaspard
(In [HEAD]) Finished rewriting relations/links. Fixes #1 and #39.
status changed from assigned to closed.
resolution set to fixed.
(In [HEAD]) Finished rewriting relations/links. Fixes #1 and #39.
status changed from assigned to closed.
resolution set to fixed.
Comments and changes to this ticket
-
Gaspard Bucher September 3rd, 2008 @ 02:58 PM
- Milestone set to public beta
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
Anyone knows how to use formatting here ?
Git repository: http://github.com/zena
Official website: http://zenadmin.org
People watching this ticket
Tags
Referenced by
- 1 Rewrite of relations (In [HEAD]) Finished rewriting relations/links. Fixes #1 ...
- 39 Dynamic attributes query (In [699]) More work on relations. Implemented dynamic at...
- 39 Dynamic attributes query (In [701]) More work on relations. Need to write the prox...
- 39 Dynamic attributes query (In [HEAD]) Finished rewriting relations/links. Fixes #1 ...
- 39 Dynamic attributes query (In [HEAD]) Finished rewriting relations/links. Fixes #1 ...
- 41 dynamic attributes finder not implemented for content tables Reference: #39
- 42 On errors in dynamic attributes, display message in template Reference: #39
- 43 Add functions for scoping date queries in pseudo sql Ref: #39
- 43 Add functions for scoping date queries in pseudo sql (In [699]) More work on relations. Implemented dynamic at...
- 43 Add functions for scoping date queries in pseudo sql (In [699]) More work on relations. Implemented dynamic at...
- 44 Parameters in pseudo sql query Ref: #39
- 44 Parameters in pseudo sql query (In [699]) More work on relations. Implemented dynamic at...
- 44 Parameters in pseudo sql query (In [699]) More work on relations. Implemented dynamic at...
- 190 dynamic attributes in where clause are a mess... Refs #131, #39.