Issue updated
Workflow: Open => Closed
Fixed in changeset: 0 => 3850
Advanced storage filtering
Currently JAS uses the Data field values to build up the WHERE clause in the SQL query (and Storage::_filterDataset) in a straightforward but limited way. It should be possible to get data via a more flexible method that allows for advanced nesting.
Example:
SELECT *
FROM blog_entries
LEFT JOIN blog_tagsmapping ON
blog_entries.nr=
blog_tagsmapping.blog_entries --automagically determined based on where clause
LEFT JOIN blog_tags ON
blog_tagsmapping.blog_tags=blog_tags.nr --same here
WHERE
(
blog_entries.
date > date.0
AND
blog_entries.
date <
date.1
AND
(
blog_tagsmapping.blog_tags
IN (tags.0) OR (blog_tags.tag = "Update" AND
blog_entries.subject START LIKE "Update")
)
)
Note that should probably wait until JAS15DEC002 is implemented. Also this should preferably be ported to other storage objects like API and XML.