EPrints Technical Mailing List Archive

Message: #03740

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[EP-tech] Re: problem with DB query for view

It should. Unfortunately a single filter with both meta_fields makes no difference, and two filters (one for each field) correctly drops every record that doesn’t have both.

 

The filter is redundant anyway, isn’t it? Since the view is keyed on those fields, and allow_null=>0

 

--

Matthew Kerwin  |  QUT Library eServices  |  matthew.kerwin@qut.edu.au

 

From: eprints-tech-bounces@ecs.soton.ac.uk [mailto:eprints-tech-bounces@ecs.soton.ac.uk] On Behalf Of sf2
Sent: Tuesday, 23 December 2014 23:03
To: eprints-tech@ecs.soton.ac.uk
Subject: [EP-tech] Re: problem with DB query for view

 

See if you can add a filter to your view - with match="SET" which should filter out NULL values.

On 23.12.2014 00:04, Matthew Kerwin wrote:

I did try that, and it didn’t make a difference; by inspecting the menu object directly I could see that it defaulted that way anyway.

 

The problem here seems to be some inherent complication resulting from a menu with two multiple fields, generating the wrong ‘distinctby’ query.

--

Matthew Kerwin  |  QUT Library eServices  |  matthew.kerwin@qut.edu.au

 

 

Attachment: smime.p7s
Description: S/MIME cryptographic signature