How to center a column title.

Hi @francisbalcaen,

Thanks for the post!

Could you send us the direct page where we can see your table?

Are you using the new App Builder or are you still using the legacy data tables?

We’ll wait for your response!

Hello, The page where you can see this result is: https://www.dx-adventure.com/vu4x-sponsors/ I have created 5 custom queries using the “Table Builder”.
This is the query :
SELECT
Callsign
FROM (
SELECT
entry_id,
MAX(CASE WHEN meta_key = ‘name-1’ THEN meta_value END) AS Callsign,
MAX(CASE WHEN meta_key = ‘currency-1’ THEN CAST(meta_value AS UNSIGNED) END) AS Amount
FROM wpdxadventure_xxxxxxxxxxxxxxxxxxx
WHERE meta_key IN (‘name-1’, ‘currency-1’)
GROUP BY entry_id
) AS subquery
WHERE Amount BETWEEN 5 AND 9
Maybe this is not the best approach but I am new to using this plugin.

Thx for the support.

Hi @francisbalcaen,

Thanks for the response and the link!

We just saw your table! You’re currently using a legacy tool that is soon going to be replaced in the summer of 2025.

At the moment, you can target the title and content via CSS and add alignment through there. Please try the following code:

.wpda_publication_container th, .wpda_publication_container td {
text-align: center !important;
}

Please note that the above code will affect all the WP Data Access tables on your site. If you want to target specific tables, just add the table IDs.

If the tables are new, we suggest recreating them using our new tool, the App Builder. We have a basic guide here: Creating a Data Table App

The App Builder is faster and has more options than the old tool. You can also align the header and content easily using the app table builder. See here: Layout and Behaviour | WP Data Access

To learn more about the App Builder, you can start reading from here: What is the App Builder? | WP Data Access

Hope that helps! Let us know if you have other questions. ??

Hi Kim,

The CSS code will do the trick for me. Thx for the support.

Just a last question in the New App builder is it possible to insert a custom query?
Kr,

Francis

Hi @francisbalcaen,

We’re glad that worked for you! ??

Just a last question in the New App builder is it possible to insert a custom query?

In a sense, yes! We suggest creating a view of your custom query and then use the view as a table source for your table app.

Hope that helps!