I meant to say > Because QGIS from 3.x has **NOT** handled JSON or array columns well from PostGIS layers
https://issues.qgis.org/issues/20872 https://issues.qgis.org/issues/21460 https://issues.qgis.org/issues/21542 https://issues.qgis.org/issues/22127 On Thu, Jun 15, 2023 at 10:22 PM Cory Albrecht <[email protected]> wrote: > 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 <[email protected]> > 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 <[email protected]> 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 < >>> [email protected]> 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 >>>> [email protected] >>>> 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 >>> [email protected] / 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> >>> >>>
_______________________________________________ QGIS-User mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
