Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
the question is has anyone found a fix for getting QField to to read and write directly to the database whilst SSL is being forced or how i can get QField to submit credentials to the database for the login
I am once again using this expression to do the same thing however it is no longer increasing the count by 1 each time for the ID of the items any ideas why this may be? My current expression is as follows: '' || array_first ( overlay_within( 'distribution_area', "name")) || '-MST12-' || to_string (array_find (array_agg (array_first (overlay_within ('distribution_area', $id))||''||-$id,array_first (overlay_within ('disdtribution_area', $id))),array_first (overlay_within ('distribution_area', $id))||''||-$id)+1)
ive managed to get a merge of line 1 and lines 2.1 2.2 and 2.3 but they are all seperate items and i have a lot of them to do this for so was hoping it could be automated in someway
I will also need a similar thing in the future to create a list of points that a line intersects with i assume this is also achieveable with a similar overlay_intersects command
apologies for the lateness in my reply. I got kicked out the office and then the weekend happened. so I have tried putting the expression you gave me into the field calculator but it only returns NULL. Picture 1 is the layer with the endpoint ID i need to set with the name field of pictures 2 and 3 depending on which layer A intersects (it will be either a chamber or a pole) there is roughly 180 items in layer A if this matters at all Pic 1: imgur.com/vOf8Ai3 Pic 2: imgur.com/nhHNE4r Pic 3 : imgur.com/gwTqJkV
i did attempt to use overlay intersects as ive used overlay within for a similar issue with generating ids based on the poly they were in but had no luck due to me not really understanding what im doing. so if im right : aggregate(layer:='point B',aggregate:='array_agg',expression:="name",filter:=intersects($geometry,geometry))[0] will that make the name now my endpoint id ?
That's absolutely fantastic thank you so much. The only thing I need to do now is work out how to have this in an actual field as opposed to just in the labels but thanks so much I wasn't even aware that the overlay within part was an option
points. sorry my use of terminology might be a little off due to me being pretty new at all this. I cant really share screenshots or anything due to the somewhat sensitive nature of the project