Charles,
i've downloaded and installed the beta1. I got the 1st part working now, a
view from my nonspatial table, working in a Postgres Store.
I just published my shapefile when the 1st problem showed: the shapefile
layer and the view are in separated stores. The 2nd one come when i tried to
make a query on a layer: i cant create a query on a layer, just in the
database, so, back to square one.
Anyone got some new ideas of how can i make this work? Or this is a feature
not present in the current geoserver?
Thanks again.
Regards,
Flavio Carmo
On Mon, Nov 22, 2010 at 12:18, Charles Galpin <[email protected]> wrote:
> Yes. Give it a try Flavio. You can write *ANY* sql query and publish the
> results. If you can write sql to produce the output you want, you can
> publish it as a layer.
>
> charles
>
> On Nov 22, 2010, at 10:12 AM, Flavio Carmo wrote:
>
> Hi Charles,
>
> The "SQL View" allows a join to be made between two layers? Because, like i
> said, the shapefiles will become a layer like the non-spatial table, then i
> need to join these layers in a new one, to publish this joined result to my
> client by WMS.
>
> Can be done?
>
> Regards,
>
> Flavio Carmo
>
>
> On Mon, Nov 22, 2010 at 11:55, Charles Galpin <[email protected]> wrote:
>
>> Hi Flavio
>>
>> You can use the "sql view" feature in 2.1 to expose the sql join as a
>> view.
>>
>>
>> http://gridlock.openplans.org/geoserver/trunk/doc/en/user/data/sqlview.html
>>
>> hth
>> charles
>>
>> On Nov 22, 2010, at 7:38 AM, Flavio Carmo wrote:
>>
>>
>> A. Can i publish a non-spatial table on Geoserver, then with the shapefile
>> published too, make a JOIN using the code column, creating a WMS service?
>> B. If not, there is another way to fulfill my client request?
>>
>> Thanks in advance,
>>
>> Regards,
>>
>> Flavio Carmo
>>
>>
>>
>
>
------------------------------------------------------------------------------
Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel(R) Graphics Technology. Get started today with the
Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
