<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi<div class=""><br class=""></div><div class=""><br class=""></div><div class=""><div><br class=""><blockquote type="cite" class=""><div class="">On 12 Nov 2019, at 08:10, Alexander Bruy <<a href="mailto:alexander.bruy@gmail.com" class="">alexander.bruy@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">Hi Tim,<div class=""><br class=""></div><div class="">if I'm not mistaken, these inputs only available inside expression editor when</div><div class="">it opened from a modeler algorithm. And they are added as top-level items,</div><div class="">and don't belong to any group.</div></div></div></blockquote><div><br class=""></div><div><br class=""></div><div>Ah thanks you are right! Adding the Field Calculator algorithm for example lets me see it:</div><div><br class=""></div><div><br class=""></div></div><img apple-inline="yes" id="06280948-46F4-4FC4-9CC7-FAC343EFD090" width="213" height="295" src="cid:2FCA694B-73F1-4EE0-A85A-0CD4B5F04227" class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">But I got other issues now:</div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">I can’t get my expression to validate:</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><div class="">attribute(</div><div class="">get_feature( @datatable , 'id', @foreignkeycolumn), 'uuid’)</div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">It validates when I substitute @datatable instead of a hard coded string, but not when I substitute @foreignkeycolumn instead of a hard coded string.</div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Trying to run it anyway (unsurprisingly) gives:</div><div class=""><br class=""></div><div class=""><div style="margin: 0px;" class=""><!--StartFragment--><span style=" color:#777777;" class="">QGIS version: 3.10.0-A Coruña</span></div><div style="margin: 0px;" class=""><span style=" color:#777777;" class="">QGIS code revision: 6c816b4204</span></div><div style="margin: 0px;" class=""><span style=" color:#777777;" class="">Qt version: 5.12.3</span></div><div style="margin: 0px;" class=""><span style=" color:#777777;" class="">GDAL version: 2.4.1</span></div><div style="margin: 0px;" class=""><span style=" color:#777777;" class="">GEOS version: 3.7.2-CAPI-1.11.2 b55d2125</span></div><div style="margin: 0px;" class=""><span style=" color:#777777;" class="">PROJ version: Rel. 5.2.0, September 15th, 2018</span></div><div style="margin: 0px;" class="">Processing algorithm…</div><div style="margin: 0px;" class=""><span style=" font-weight:600;" class="">Algorithm 'Convert Lookup To UUID' starting…</span></div><div style="margin: 0px;" class="">Input parameters:</div><div style="margin: 0px;" class=""><span style=" font-family:'.SF NS Mono';" class="">{ 'datatable' : '/Users/timlinux/gisdata/MaceiraMergin/Maceira/smallholding.gpkg|layername=structures', 'foreignkeycolumn' : 'wall_type_id', 'lookuptable' : '/Users/timlinux/gisdata/MaceiraMergin/Maceira/smallholding.gpkg|layername=wall_type' }</span></div><div style="margin: 0px;" class=""><br class=""></div><div style="margin: 0px;" class=""><span style=" color:#777777;" class="">Prepare algorithm: qgis:fieldcalculator_1</span></div><div style="margin: 0px;" class="">Running Field calculator [1/1]</div><div style="margin: 0px;" class="">Input Parameters:</div><div style="margin: 0px;" class=""><span style=" font-family:'.SF NS Mono';" class="">{ FIELD_LENGTH: 99, FIELD_NAME: '_uuid', FIELD_PRECISION: 3, FIELD_TYPE: 2, FORMULA: 'attribute(\nget_feature( @datatable , \'id\', @foreignkeycolumn), \'uuid’)', INPUT: '/Users/timlinux/gisdata/MaceiraMergin/Maceira/smallholding.gpkg|layername=structures', NEW_FIELD: True, OUTPUT: 'memory:Calculated' }</span></div><div style="margin: 0px;" class=""><span style=" color:#ff0000;" class="">No root node! Parsing failed?</span></div><div style="margin: 0px;" class=""><span style=" color:#ff0000;" class="">No root node! Parsing failed?</span></div><div style="margin: 0px;" class=""><span style=" color:#ff0000;" class="">No root node! Parsing failed?</span></div><div style="margin: 0px;" class=""><span style=" color:#ff0000;" class="">No root node! Parsing failed?</span></div><div style="margin: 0px;" class=""><span style=" color:#ff0000;" class="">No root node! Parsing failed?</span></div><div style="margin: 0px;" class=""><span style=" color:#ff0000;" class="">No root node! Parsing failed?</span></div><div style="margin: 0px;" class=""><span style=" color:#ff0000;" class="">No root node! Parsing failed?</span></div><div style="margin: 0px;" class=""><span style=" color:#ff0000;" class="">No root node! Parsing failed?</span></div><div style="margin: 0px;" class=""><span style=" color:#ff0000;" class="">No root node! Parsing failed?</span></div><div style="margin: 0px;" class=""><span style=" color:#ff0000;" class="">No root node! Parsing failed?</span></div><div style="margin: 0px;" class=""><span style=" color:#ff0000;" class="">No root node! Parsing failed?</span></div><div style="margin: 0px;" class=""><span style=" color:#ff0000;" class="">No root node! Parsing failed?</span></div><div style="margin: 0px;" class=""><span style=" color:#ff0000;" class="">No root node! Parsing failed?</span></div><div style="margin: 0px;" class=""><span style=" color:#ff0000;" class="">No root node! Parsing failed?</span></div><div style="margin: 0px;" class=""><span style=" color:#ff0000;" class="">No root node! Parsing failed?</span></div><div style="margin: 0px;" class="">OK. Execution took 0.413 s (1 outputs).</div><div style="margin: 0px;" class=""><span style=" color:#777777;" class="">Model processed OK. Executed 1 algorithms total in 0.514 s.</span></div><div style="margin: 0px;" class="">Execution completed in 0.58 seconds</div><div style="margin: 0px;" class="">Results:</div><div style="margin: 0px;" class=""><span style=" font-family:'.SF NS Mono';" class="">{}</span></div><div style="margin: 0px;" class=""><br class=""></div><div style="margin: 0px;" class="">Loading resulting layers</div><div style="margin: 0px;" class="">Algorithm 'Convert Lookup To UUID’ finished<!--EndFragment--></div><div style="margin: 0px;" class=""><br class=""></div><div class=""><br class="webkit-block-placeholder"></div><div class="">Regards</div><div class=""><br class=""></div><div class="">Tim</div><div class="">
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-position: normal; font-variant-caps: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-weight: normal; letter-spacing: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; line-height: normal; text-align: center;" class=""><span>—</span></div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-position: normal; font-variant-caps: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; letter-spacing: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; line-height: normal; text-align: center;" class=""><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0); min-height: 14px;" class=""><br class=""></div><br class="Apple-interchange-newline" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none;"><span style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none;"><span><span><span><span><span><span><span><span><span><span><span><img apple-inline="yes" id="F265D33A-6517-4725-8656-55A6D85BA0F6" src="cid:1A5DF6DE-E302-4C28-BFBD-29663CBF1351" class=""></span><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0); min-height: 14px;" class=""><br class="Apple-interchange-newline"><br class="Apple-interchange-newline"><br class="Apple-interchange-newline"><br class="Apple-interchange-newline"><br class=""></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0); min-height: 14px;" class=""><br class=""></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0);" class=""><b class="">Tim Sutton</b></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0); min-height: 14px;" class=""><br class=""></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0);" class=""><b class="">Co-founder:</b><span class="Apple-converted-space"> </span>Kartoza</div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0);" class=""><b class="">Ex Project chair:</b><span style="font-weight: normal;" class=""><span class="Apple-converted-space"> </span><a href="http://QGIS.org" class="">QGIS.org</a></span></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0); min-height: 14px;" class=""><br class=""></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0);" class="">Visit <a href="http://kartoza.com/" class=""><span style="-webkit-text-stroke-color: rgb(71, 135, 255);" class="">http://kartoza.com</span></a> to find out about open source:</div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0); min-height: 14px;" class=""><br class=""></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0);" class="">Desktop GIS programming services</div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0);" class="">Geospatial web development</div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0);" class="">GIS Training</div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0);" class="">Consulting Services</div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0); min-height: 14px;" class=""><br class=""></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0);" class=""><b class="">Skype</b>: timlinux </div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0);" class=""><b class="">IRC:</b><span class="Apple-converted-space"> </span>timlinux on #qgis at <a href="http://freenode.net" class="">freenode.net</a></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0);" class=""><br class=""></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: initial; text-decoration: none; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; margin: 0px; line-height: normal; -webkit-text-stroke-color: rgb(0, 0, 0);" class=""><span style="caret-color: rgb(102, 106, 115); color: rgb(102, 106, 115); font-family: "Proxima Nova", sans-serif; font-size: 14px; text-align: left; background-color: rgb(255, 255, 255);" class="">I'd love to connect. </span><a target="_blank" class="t-quick-start-share-link" href="https://calendly.com/timlinux" style="color: rgb(0, 162, 255); text-decoration: none; cursor: pointer; font-family: "Proxima Nova", sans-serif; font-size: 14px; text-align: left;">Here's my calendar link</a><span style="caret-color: rgb(102, 106, 115); color: rgb(102, 106, 115); font-family: "Proxima Nova", sans-serif; font-size: 14px; text-align: left; background-color: rgb(255, 255, 255);" class=""> to make finding time easy.</span></div>
</span></span></span></span></span></span></span></span></span></span></span></div>
</div><br class=""></div></body></html>