Ha, good news.
I will have deeper look at time activation, maybe I can find a solution
which requires some modifications in the SQL dialect only. The advantage is
that you need not to bother about "date_from" an "date_to" sql attributes,
only formulate the "from" clause with a date or a date range. Of course, it
is necessary to check the db version and to check if a table support
business time.
I will do some investigations.
Cheers
On Thu, Nov 21, 2013 at 10:38 AM, Andrea Aime
<andrea.a...@geo-solutions.it>wrote:
> On Thu, Nov 21, 2013 at 10:31 AM, Christian Mueller <
> christian.muel...@os-solutions.at> wrote:
>
>> I will give you an example:
>>
>> Given a normal select
>>
>> select * from table mytable where ....
>>
>> If this table has business time support it would be
>>
>> select * from table mytable as of business_time of '2011-01-01' where ....
>>
>> The syntax extension is in the "from" clause. The above query returns
>> only records valid at '2011-01-01'. A simple
>>
>> select * from table mytable where ...
>>
>> would return all historical versions, this is unwanted in most scenarios.
>> If the date is missing it should be
>>
>> select * from table mytable as of business_time of current time where ...
>>
>> This select returns all actual versions.
>>
>
> Hmm... seems pretty close to what GeoServer is doing when time is
> activated on vector data, without need for
> any special database support:
> * if you specify a date range in TIME, it will add that as a search clause
> * if you don't specify any, it will use the most current time in the
> database... the only thing is that it will take time to extract it, which
> is likely suboptimal
>
> Cheers
> Andrea
>
> --
> ==
> Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
> information.
> ==
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054 Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob: +39 339 8844549
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> -------------------------------------------------------
>
--
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
