[Qgis-user] Disappearing labels and how to get them back

[Cory Albrecht]

I found the problem.

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


if(

  map_get("full_name", 'en') IS NULL,
  "name",
  map_get("full_name", 'en')[0]
) +
'\nFrom: ' +
format_date("start_date", 'yyyy-MM-dd') +
'\nTo: ' +
format_date("end_date", 'yyyy-MM-dd')


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.

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.

On Thu, Jun 15, 2023 at 9:48 PM Cory Albrecht <maps at hanfastolfe.com> wrote:

> Hello Emma,
>
> Thanks for taking the time to help, but unfortunately that did not work.
> :-(
>
> I've attached the exported styles in case that helps you or anybody else.
>
>
> On Thu, Jun 15, 2023 at 8:39 PM Emma Hain <emma at north-road.com> wrote:
>
>> Hi Cory
>> This is the manual way to do it - someone may have a cooler of way of
>> doing it.
>>
>>    1. In the Layer Styling panel, click on Label panel.
>>    2. Under Placement, you will see that that the X/Y will be coloured
>>    yellow.
>>    3. Click on each of these and select 'Clear'
>>    4. N.B. Other parameters may still be affected as well - they will be
>>    coloured in yellow - just clear them as well.
>>
>> [image: image.png]
>>
>> If you need to do this for individual labels, select the features and
>> click on the Label Properties and reset/clear out the parameters
>> [image: image.png]
>>
>> I hope this helps, and keen to hear other ways.
>>
>> Cheers
>> Em
>>
>> On Fri, 16 Jun 2023 at 05:54, Cory Albrecht via QGIS-User <
>> qgis-user at lists.osgeo.org> wrote:
>>
>>> Hello,
>>>
>>> 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.
>>>
>>> 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.
>>>
>>> How do I reset all labelling for a layer and get the missing labels back?
>>>
>>> _______________________________________________
>>> QGIS-User mailing list
>>> QGIS-User at lists.osgeo.org
>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>
>>
>>
>> --
>> Emma Hain — Product Manager/Senior GIS Analyst
>> emma at north-road.com / 0414 512 782
>> [image: https://north-road.com]
>> *North Road*
>> Cartography • Development • Spatial Analysis
>> ------------------------------
>> *north-road.com* <http://north-road.com>
>> <https://twitter.com/northroadgeo>
>> <https://www.linkedin.com/company/north-road-studios>
>> <https://www.facebook.com/North-Road-997236690392419/home>
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230615/3e0adedb/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 45851 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230615/3e0adedb/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 2994 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230615/3e0adedb/attachment-0003.png>