mygrove

So, I can create a query and I have named and saved it. It can be run and produces the expected output.

How does it become a view because it does not appear in the Data Explorer page. I have also tried importing the SQL statement into the Data Explorer. It gives a confirmation message saying it has been imported but is still not visible.

Thanks, that’s all fine. How do I incorporate my query into WP Data Access – into the Project? Or directly on my site?

OK, I have a database of people which can be searched, some records will have a relationship to other people in the same list e.g. parents, father and mother. I want to be able to select any of the three detail records. So if two of my fields had urls to the details page it would achive that. Yes, the record_id works but it is messy as I have to set all those links up manually because I don’t know the record_id in advance. Ideally I would use my regular id field with something like this. Where the page “single-detail” contains a [pdb_single] shortcode.

/database-detail/?term=id&value=910001
or
/single-detail/?term=id&value=910001

The issue there seems to be that I don’t know that record_id is from my data as it only gets assigned after the record has been added. The ‘term’ attribute seems to suggest it can be used as an alternative but I cannot get the syntax correct.

@andreearadacina21

<<Due to the implementation of the provided code, I no longer have visibility into the initial issue.?>> !!?

You will see from my previous comment the error is in Neve’s CSS. I have been through disbaling the other plugins and checked the page inspector.

By trial and error I have found that inserting the following in Neve’s Additional CSS removes the markers and spacing. I just don’t know if it has any undesirable effects elsewhere. The original CSS is from neve/style-main-new.min.css.

code {
    border: 0px;
    padding: 0 0px;
}

Not a lot to see, but here it is (I don’t know why but the image block will not accept online images in this editor, so I have used embed instead):

As a matter of interest, how would you do it with straight CSS?

So it seems the solution is to create your own template and comment out two lines that are not required.

Create a copy of tempate pdb-single-default.php:

<?php // $this->group->print_title( '<h2 class="pdb-group-title">', '</h2>' ) ?>

<?php // $this->group->print_description() ?>

Perfect. Thanks.

Thanks.

How do you set the gallery thumbnail (cover) image?

That’s a Pro feature!

You were correct. It was not being used, so I have deleted the Classic Editor plugin which solves the issue.

[osm_map_v3 map_center=”autolat,autolon” zoom=”autozoom” width=”100%” height=”450″ file_list=”../../../../wp-content/uploads/KML/chapels.kml” file_color_list=”blue” control=”fullscreen,overview” map_border=”thin solid green” file_title=”Northampton Chapels”]

nth_chapels.kml

<?xml version=”1.0″ encoding=”UTF-8″?>
<kml xmlns=”https://earth.google.com/kml/2.1″&gt;
<Document>
<name>Northampton Chapels</name>

<Style id=”a”>
<IconStyle>
<Icon>
<href>https://maps.google.com/mapfiles/ms/icons/red-dot.png</href&gt;
</Icon>
</IconStyle>
</Style>
<Placemark>
<name>St. Andrews, Harlestone Road</name>
<styleUrl>#a</styleUrl> <Point>
<coordinates>-0.931, 52.2512,0</coordinates>
</Point>
<description><![CDATA[Methodist, from: ?? until: Open]]></description>
</Placemark>
<Placemark>
<name>Kings Heath</name>
<styleUrl>#a</styleUrl> <Point>
<coordinates>-0.9167, 52.2562,0</coordinates>
</Point>
<description><![CDATA[Baptist, from: 1956 until: Open]]></description>
</Placemark>
<Placemark>
<name>Harlestone Road</name>
<styleUrl>#a</styleUrl> <Point>
<coordinates>-0.9164, 52.2404,0</coordinates>
</Point>
<description><![CDATA[Primitive Methodist, from: 1899 until: Closed]]></description>
</Placemark>
<Placemark>
<name>Sandhill Road</name>
<styleUrl>#a</styleUrl> <Point>
<coordinates>-0.9156, 52.2404,0</coordinates>
</Point>
<description><![CDATA[Primitive Methodist, from: 1887 until: Closed]]></description>
</Placemark>
<Placemark>
<name>Abbey Centre</name>
<styleUrl>#a</styleUrl> <Point>
<coordinates>-0.9153, 52.2156,0</coordinates>
</Point>
<description><![CDATA[Baptist, from: 1987 until: Open]]></description>
</Placemark>
<Placemark>
<name>Doddridge Memorial</name>
<styleUrl>#a</styleUrl> <Point>
<coordinates>-0.9127, 52.2378,0</coordinates>
</Point>
<description><![CDATA[Congregational, from: 1855 until: Open]]></description>
</Placemark>
<Placemark>
<name>Alma Street</name>
<styleUrl>#a</styleUrl> <Point>
<coordinates>-0.908, 52.2275,0</coordinates>
</Point>
<description><![CDATA[Baptist, from: 1860 until: 1893]]></description>
</Placemark>
<Placemark>
<name>Henley Street</name>
<styleUrl>#a</styleUrl> <Point>
<coordinates>-0.9072, 52.2273,0</coordinates>
</Point>
<description><![CDATA[Primitive Methodist, from: 1863 until: 1924]]></description>
</Placemark>
<Placemark>
<name>Henley Street</name>
<styleUrl>#a</styleUrl> <Point>
<coordinates>-0.9072, 52.2273,0</coordinates>
</Point>
<description><![CDATA[Salvation Army, from: ?? until: ??]]></description>
</Placemark>
<Placemark>
<name>Abbey Road</name>
<styleUrl>#a</styleUrl> <Point>
<coordinates>-0.907, 52.2264,0</coordinates>
</Point>
<description><![CDATA[Baptist, from: 1893 until: 1987]]></description>
</Placemark>
</Document>
</kml>

@arnaudbroes I can confirm that disabling “Run Shortcodes” eliminates the conflict.

Thanks.