<div dir="ltr"><div class="gmail_default" style="font-family:monospace">I found the problem.<br></div><div class="gmail_default" style="font-family:monospace"><br></div><div class="gmail_default" style="font-family:monospace">Because QGIS from 3.x has handled JSON or array columns well from PostGIS layers, I finally converted most of those columns to text fields. Because of that I had very few features lasted edited years ago which had had anything in the full_name::JSON column, most were NULL, so the data driven code</div><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div class="gmail_default" style="font-family:monospace"><br></div></blockquote></blockquote><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><span style="font-family:monospace">if(</span><br></blockquote><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div class="gmail_default" style="font-family:monospace"> map_get("full_name", 'en') IS NULL,<br></div><div class="gmail_default" style="font-family:monospace"> "name",</div><div class="gmail_default" style="font-family:monospace"> map_get("full_name", 'en')[0]</div><div class="gmail_default" style="font-family:monospace">) +</div><div class="gmail_default" style="font-family:monospace">'\nFrom: ' +</div><div class="gmail_default" style="font-family:monospace">format_date("start_date", 'yyyy-MM-dd') +</div><div class="gmail_default" style="font-family:monospace">'\nTo: ' +</div><div class="gmail_default" style="font-family:monospace">format_date("end_date", 'yyyy-MM-dd')</div></blockquote><div class="gmail_default" style="font-family:monospace"><br></div><div class="gmail_default" style="font-family:monospace">did not work, as after "full_name" was converted from full_name::JSON to full_name::TEXT, the map() function of course no longer worked and the creation of the label text just errored out and produced nothing.</div><div class="gmail_default" style="font-family:monospace"><br></div><div class="gmail_default" style="font-family:monospace">I had only made that column change on one PostgreSQL server, not on the other, which was why it seems to happen on copy. The style that worked referenced a different column, name::TEXT, that has never changed since the layer was created years ago.</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jun 15, 2023 at 9:48 PM Cory Albrecht <<a href="mailto:maps@hanfastolfe.com">maps@hanfastolfe.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:monospace">Hello Emma,<br></div><div class="gmail_default" style="font-family:monospace"><br></div><div class="gmail_default" style="font-family:monospace">Thanks for taking the time to help, but unfortunately that did not work. :-(</div><div class="gmail_default" style="font-family:monospace"><br></div><div class="gmail_default" style="font-family:monospace">I've attached the exported styles in case that helps you or anybody else.</div><div class="gmail_default" style="font-family:monospace"><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jun 15, 2023 at 8:39 PM Emma Hain <<a href="mailto:emma@north-road.com" target="_blank">emma@north-road.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div>Hi Cory</div><div>This is the manual way to do it - someone may have a cooler of way of doing it. <br></div><ol><li>In the Layer Styling panel, click on Label panel. </li><li>Under Placement, you will see that that the X/Y will be coloured yellow. </li><li>Click on each of these and select 'Clear'</li><li><div style="text-align:left">N.B. Other parameters may still be affected as well - they will be coloured in yellow - just clear them as well.</div></li></ol><div style="text-align:left"><img src="cid:ii_lixu7z0g0" alt="image.png" width="426" height="578"><br></div></div><div><br></div><div>If you need to do this for individual labels, select the features and click on the Label Properties and reset/clear out the parameters <br><img src="cid:ii_lixuan2a1" alt="image.png" width="81" height="68"><br></div><div><br></div><div>I hope this helps, and keen to hear other ways. <br></div><div><br></div><div>Cheers</div><div>Em<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, 16 Jun 2023 at 05:54, Cory Albrecht via QGIS-User <<a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:monospace">Hello,<br></div><div class="gmail_default" style="font-family:monospace"><br></div><div class="gmail_default" style="font-family:monospace">I was cutting and pasting between different layers and different PostGIS servers, and the features that were cut and masted in no longer have visible labels and I cannot get them to reappear.</div><div class="gmail_default" style="font-family:monospace"><br></div><div class="gmail_default" style="font-family:monospace">The auxiliary storage columns `auxiliary_storage_labeling_positionx` and `…_positiony` were created a while back when I was toying with moving labels around, but even when the layer is set to editable, those columns were not editable. I also couldn't use the field calculator to change them.</div><div class="gmail_default" style="font-family:monospace"><br></div><div class="gmail_default" style="font-family:monospace">How do I reset all labelling for a layer and get the missing labels back?</div><div class="gmail_default" style="font-family:monospace"><br></div></div>
_______________________________________________<br>
QGIS-User mailing list<br>
<a href="mailto:QGIS-User@lists.osgeo.org" target="_blank">QGIS-User@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote></div><br clear="all"><br><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div style="margin-bottom:20px;font-family:verdana,sans-serif;color:rgb(68,68,68)">Emma Hain — Product Manager/Senior GIS Analyst<br>
<a href="mailto:emma@north-road.com" style="color:rgb(78,141,175);text-decoration:none" target="_blank">emma@north-road.com</a> / 0414 512 782</div>
<div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><table>
<tbody>
<tr>
<td><img alt="https://north-road.com" src="https://ci3.googleusercontent.com/mail-sig/AIorK4z-QyPD9kQRyEtpg0YHp_bVoq466HfPMkJXDWxnwTf1qCIBS8c19W29po6b7akLq2btEedEMKg"><br></td>
<td><font color="#444444"><font face="verdana, sans-serif"><b>North Road</b><br>Cartography • Development • Spatial Analysis</font><br><hr style="height:1px;background-color:rgb(219,210,143);color:rgb(219,210,143);border:medium none">
<span><font face="verdana, sans-serif"><a href="http://north-road.com" style="color:rgb(78,141,175);text-decoration:none" target="_blank"><b>north-road.com</b></a><span></span><br><a href="https://twitter.com/northroadgeo" target="_blank"><img src="https://ci3.googleusercontent.com/mail-sig/AIorK4xbsQ72BNIM2cWMZcuEKVer1Bwaq_gqYkdbtrjK2ifrqv-4o7aWjcvilgYXtNGpXLNgD00xgmQ"></a></font></span></font><a href="https://www.linkedin.com/company/north-road-studios" target="_blank"><img src="https://ci3.googleusercontent.com/mail-sig/AIorK4zEBWGJKio8gqmFT0h_51t4ZnmoGgbmV7SeL-4FKvwWApFWDWyK7p-c0-cSskUe7pjQzjEZj9Q"></a><a href="https://www.facebook.com/North-Road-997236690392419/home" target="_blank"><img src="https://ci3.googleusercontent.com/mail-sig/AIorK4wlMciFPm8hqQZB_Qi57PUCv1dJqUC1A2i9qEMzWRFLcJ7Jil30YnULdJLxT6-qMfI6J4kcac4"></a><font color="#444444"><span><font face="verdana, sans-serif"><br><img src="https://womenindigital.org/wp-content/uploads/2023/03/WID-Membership-Badge.jpg" width="96" height="48"><br></font></span></font></td> </tr></tbody></table></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
</blockquote></div>
</blockquote></div>