[ckan-dev] Additional Filter Abilities

[Matthew Fullerton]

I think I will do it that way but add a checkbox "allow numeric comparisons" for the slim possibility that the text e.g. ">5" exists in the data.

-Matt

Projekt SMARTLANE

matthew at smartlane.de
T +49.89.289.28575
F +49.89.289.22333
www.smartlane.de

EXIST-Gründungsvorhaben „Tapestry“
c/o Lehrstuhl für Verkehrstechnik
Technische Universität München
Arcisstraße 21
80333 München

________________________________________
Von: ckan-dev <ckan-dev-bounces at lists.okfn.org> im Auftrag von Gerace, Christian [ITSUS] <cgerace at ITS.JNJ.com>
Gesendet: Montag, 23. Februar 2015 14:51
An: CKAN Development Discussions
Betreff: Re: [ckan-dev] Additional Filter Abilities

Hey Matt,

Thanks for the insight, sound like possibly good news. To answer your question, my preference would be just adding the syntax in the filter input, but either would be suitable.

Thanks,
Christian

-----Original Message-----
From: ckan-dev [mailto:ckan-dev-bounces at lists.okfn.org] On Behalf Of Matthew Fullerton
Sent: Monday, February 23, 2015 5:50 AM
To: ckan-dev at lists.okfn.org
Subject: [ckan-dev] Additional Filter Abilities

Dear Christian,
By incredible coincidence we did a demo involving the preview feature on Friday where we tried to do this and it of course did not work. I will be trying to add it in the coming days as an extension or improvement to CKAN generally, as it is something we really need. The question is, do we just want a syntax inside the filter input (as in >5) or do we want a UI where you select 'between', 'greater than', 'less than' etc. Suggestions welcome.

-Matt

On 20 February 2015 at 20:15, Gerace, Christian [ITSUS] <cgerace at its.jnj.com> wrote:

    Hey Community,



    I've been searching around but  I can't find an answer, so I was hoping someone here might know. Is there a way, or an extension, that allows a user to filter within the preview interface on fields using different comparisons (rather than just equal to)? For example, if a user wanted to find rows in which field 1 is not equal to "certain value"? Or even to compare a date, say filter rows which field 2 is greater than "2/20/15"? I know that this is possible via the SQL search in the API, but I was hoping there was a way to do this on the resource preview page.



    Thanks,

    Christian Gerace
    Associate Analyst - Enterprise Architect
    +1.908.655.4147 | cgerace at its.jnj.com



    _______________________________________________
    ckan-dev mailing list
    ckan-dev at lists.okfn.org
    https://lists.okfn.org/mailman/listinfo/ckan-dev
    Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev


Projekt SMARTLANE

matthew at smartlane.de
T +49.89.289.28575
F +49.89.289.22333
www.smartlane.de

EXIST-Gründungsvorhaben "Tapestry"
c/o Lehrstuhl für Verkehrstechnik
Technische Universität München
Arcisstraße 21
80333 München
_______________________________________________
ckan-dev mailing list
ckan-dev at lists.okfn.org
https://lists.okfn.org/mailman/listinfo/ckan-dev
Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
_______________________________________________
ckan-dev mailing list
ckan-dev at lists.okfn.org
https://lists.okfn.org/mailman/listinfo/ckan-dev
Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev