[Qgis-user] Project relation - sci. notation

[Nyall Dawson]

On 6 June 2016 at 20:28, Chris Berens <chris at mapland.co.za> wrote:
> Hi there,
>
> I have a layer of homes (roofs) and a list of residents who are linked to a
> home by the roof number.  The homes are attributed via a re-blocking
> exercise running 1-31 and A-J, eg. 18G is a block. Within each block there
> may be up to 100 homes, eg. 18G-47.
>
> So under Project Properties I set up a relation called 'households' and
> using the Identify Features tool I can view the members of a household by
> clicking on the roof. Works great, most of the time.
>
> When I click on an E block roof (eg 18E-23) it returns all 291 XXE-XX
> residents on the list.  It appears to me as if the relation is reading the
> values as scientific notation numeric values instead of the declared text
> status in both files.
>
> I have an Attribute table in the a Composer window in the same project that
> references the same relation perfectly, ie it only returns the residents
> particular to eg 18E23.  So is the Identify Features tool using a different
> select rule set or parameters?
>
> I have tried to search for a previous thread on this topic without success.
> The pain would appear to be for me alone, but can anyone suggest a way of
> defining a relation to avoid this?
>
> FWIW I'm using 2.14.3-64bit on Win7, this behaviour is true for sqlite and
> shp formats.

I've tried to reproduce this locally but cannot. Can you share a
sample project + test data which demonstrates this issue?

Thanks!
Nyall

>
> Thank you for your attention,
> Chris
>
> Chris Berens, GISc
> www.mapland.co.za
> +27 (0)82 567 9322
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user