Re: charset; logical OR on filtering; list of dates

On Wed, May 12, 2021 at 12:04:36AM +0200, Nagy Gabor wrote:
> 2. Can I do logical OR operation on database filtering, concerning
> different properties?
> For example, I want to list issues with "assignedto=15 OR actor=15".
> Do we have a built-in query for this, or shall I utilize filter_sql, or
> any other custom solution?

As John has already written, this is currently not possible using the
roundup API. What you *can* do is an explicit SQL query using
db.sql(...).

> 3. This one is a little more general. I know that relational databases
> are not designed to store lists/arrays. But I have to implement somehow
> a property (let's call it "important_dates") which stores a LIST of
> dates. What is the best practice to implement this?

I would put that in a separate class with a Link property to the class
where you need that list of dates. Lets call that class 'issue' (but it
doesn't need to be the issue class for this example). If you need to
navigate from a node of the issue class to the list of dates you can
produce an automagic multilink property in the issue class using
'rev_multilink' parameter in the important_date class in the Link
definition.

Ralf
-- 
Dr. Ralf Schlatterbeck                  Tel:   +43/2243/26465-16
Open Source Consulting                  www:   www.runtux.com
Reichergasse 131, A-3411 Weidling       email: [email protected]