Re: Model the Query Bindings
Re: Model the Query Bindings
- Subject: Re: Model the Query Bindings
- From: Ramsey Gurley <email@hidden>
- Date: Fri, 05 Dec 2014 13:33:16 -0700
I don’t think anything exists. I always wanted to redo saved queries as a stored qualifier. query min max match is always just a big flat AND qualifier and requires a displayGroup.
I’d rather have something that let me store (a = 1 and b not like ‘*parrot') or (c > current_date and d is true) directly as a qualifier. To that end, I’d also want to create a custom date qualifier that let me say something like c > current_date. With a properly modeled qualifier table, it might even be reasonable to store those qualifier segments individually and allow them to be recombined in different ways or shared between different qualifiers.
Basically, it would be fun to build a custom query editor in D2W. Never got around to it though. Of course, you’ll need some way to validate the qualifiers once they were pulled out of the DB since the model may change between the insert and select, but you’ll need that anyway with query min max match too.
On Dec 5, 2014, at 12:22 PM, James Cicenia <email@hidden> wrote:
> The last time I did this I stored it as a custom mutable dictionary.
> However, this is fraught with issues as I discovered the hard way.
>
> Is there a framework or such or example out there of modeling
> a QueryPage/List in the database?
>
> I am thinking:
>
> Template
> Entity
> QueryEntity
> —>> displayKeys
> — >> key/value for query properties
> ListEntity
> — >>displayKeys
> —>> key/value for display properties
>
> Thoughts?
> James
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden