[mapserver-dev] mapsde : qualified names vs non qualified names

[Yewondwossen Assefa]

Howard Butler wrote:
> 
> On Feb 20, 2008, at 5:55 PM, Yewondwossen Assefa wrote:
> 
>> Hi There,
>>
>> Working with mapserver/sde layers, we came across an issue  where the 
>> attribute names used (ex for a querybyattributes) must be qualified if 
>> there is a Join done on the layer and non-qualified if there is no 
>> join. Note that this is documented.
>> Do you see any advantage/problem to always be able to use qualified 
>> names either there is a join or not? At least be able for those who 
>> want it, to be able to have a setting so that qualified names are 
>> always used. (this would preserve the way it works now if there is 
>> nothing set)
> 
> Assefa,
> 
> If I remember correctly, I had a lot of trouble with qualified names and 
> joins with SDE.  I settled with what we have now to attempt to preserve 
> existing behavior for folks while still allowing in-database joins to 
> happen.  I would support adding some sort of PROCESSING item to switch 
> on fully qualified names, or if there is enough support for 5.2, just 
> moving to always returning and using qualified names (this would require 
> mapfile changes for folks, however).
> 
> Howard
> 

  Thanks Howard. I have create a enhancement bug on it 
http://trac.osgeo.org/mapserver/ticket/2523 and put a patch that can be 
used to always use qualified names with a processing setting.  It can be 
reviewed and applied if make sense.

Best Regards,

> _______________________________________________
> mapserver-dev mailing list
> mapserver-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
> 
> 


-- 
----------------------------------------------------------------
Assefa Yewondwossen
Software Analyst

Email: assefa at dmsolutions.ca
http://www.dmsolutions.ca/

Phone: (613) 565-5056 (ext 14)
Fax:   (613) 565-0925
----------------------------------------------------------------