Send netdisco-users mailing list submissions to
netdisco-users@lists.sourceforge.net
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
netdisco-users-requ...@lists.sourceforge.net
You can reach the person managing the list at
netdisco-users-ow...@lists.sourceforge.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Re: Cisco IMEI tracker report for cellular services
(Oliver Gorwits)
--- Begin Message ---
Thanks Christian, this makes me think carefully about ACL feature on
custom_fields, much appreciated.
oliver.
On Tue, 17 Sept 2024 at 23:35, Christian Ramseyer <ramse...@netnea.com>
wrote:
>
>
> On 17.09.2024 19:14, Oliver Gorwits wrote:
> >
> > I have no idea how to fix this, sorry. I guess it could be worked around
> > by refactoring the query not to use the PostgreSQL jsonb operator "?".
> >
> > WHERE____
> >
> > (custom_fields \? 'c3gGsmNetwork' AND
> > json_array_length((custom_fields ->> 'c3gGsmNetwork')::json) > 0)____
> >
> > OR____
> >
> > (custom_fields \? 'c3gImei' AND json_array_length((custom_fields
> > ->> 'c3gImei')::json) > 0)____
> >
>
> Which should be easy here, you can just leave out the part before the
> AND and still get the same result (untested)
>
> Cheers
> Christian
>
>
> _______________________________________________
> Netdisco mailing list
> netdisco-users@lists.sourceforge.net
> https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users
