<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hello Dennis,<br>
</p>
<p>I don't know I understood your problem, but a GeoPackage is
internally a SQlite-Database with SpataLite-extension and without
native field-types GUID or UUID.</p>
<p>The SpatiaLite-provided function CreateUUID "returns a Version 4
(random) UUID (Universally unique identifier)"
(<a class="moz-txt-link-freetext" href="https://www.gaia-gis.it/gaia-sins/spatialite-sql-5.0.1.html">https://www.gaia-gis.it/gaia-sins/spatialite-sql-5.0.1.html</a>).
These values can be stored in text or blob-columns, perhaps as
default-value and primary key, which then are usable in QGis as
any other text/blob-column.</p>
<p>I don't know a QGis-JOIN-function (?), but I successfully tested
the *SQL*-JOIN-Syntax in QGis DB-Manager and as source for a
virtual layer joining two tables via two columns type "text"
containing common CreateUUID-generated UUIDs (QGis 3.40.3 under
Linux).</p>
<p>hth</p>
<p>Ludwig<br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">Am 02.02.25 um 01:36 schrieb dennis
mckay via QGIS-User:<br>
</div>
<blockquote type="cite"
cite="mid:956082084.6199527.1738456569787@mail.yahoo.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div class="yahoo-style-wrap"
style="font-family:verdana, helvetica, sans-serif;font-size:13px;">
<div dir="ltr" data-setdir="false">I am building several
interconnected geopackage tables. I am using the JOIN
function in QGIS (3.40.2, <span>OSGeo4W, Windows 10</span>)
where I noticed that the GUID fields do not appear as
possibilities, nor do they appear under Properties >
Fields. All my JOINS are with GUID fields.<br>
<br>
With tables without geometries, the GUID fields appear and
will join together nicely. In Spatiallite.exe, looking at the
same geopackage file, these GUID fields appear. QGIS also
recognizes these GUIDs in identical tables in PostGIS, where
they are joined together nicely.<br>
<br>
I would like help understanding how to get QGIS to recognize
these GUID fields, or is this behavior a "feature"?<br>
<br>
Dennis K. McKay<br>
Retired Federal Cadastral Surveyor</div>
<div><br>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre wrap="" class="moz-quote-pre">_______________________________________________
QGIS-User mailing list
<a class="moz-txt-link-abbreviated" href="mailto:QGIS-User@lists.osgeo.org">QGIS-User@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
</body>
</html>