Ticket #2523 (closed enhancement: fixed)
pssibility to always used qualifed names for attributes
|Reported by:||assefa||Owned by:||assefa|
|Component:||Input - Native SDE Support||Version:||unspecified|
This is en e-mail conversation between Assefa and Howard:
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)
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).