[Qgis-user] Project relation - sci. notation

[Nyall Dawson]

On 8 Jun 2016 5:28 PM, "Chris Berens" <chris at mapland.co.za> wrote:
>
> Hi Nyall,
>
> I have posted a zipped project with sqlite database here:
>
> http://www.mapland.co.za/home/qgis_idfeaturetool_issue
>
> Hoping I am missing something obvious.

Thanks - it was an issue, now fixed in master. I'll backport to 2.14 too.

Nyall

>
> Regards,
> Chris
>
> Chris Berens, GISc
> www.mapland.co.za
> +27 (0)82 567 9322
>
> On 8 June 2016 at 00:47, Nyall Dawson <nyall.dawson at gmail.com> wrote:
>>
>> 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
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160609/5f0fbdf3/attachment.html>