Hi Andrew,
I think your files could be very helpful! 😊 Can you please use the contact form on the plugin website to send me a message? I’ll reply to your message which allows you to reply and send your files in private. I’m interested in a table export including your create table script.
Thanks,
Peter
Thread Starter
mlapl1
(@mlapl1)
OK. Will do Peter. Thank you
Andrew
Thread Starter
mlapl1
(@mlapl1)
Hello Peter
I think I may have solved the puzzle a bit (but not enough). The problem occurs at the first level of the data explorer. The mess occurs because the system tries to fit my 79 columns into the width of a single page of the backend. It does not create a horizontally scrollable page. So it crams everything in the width available. If I go to page settings and reduce the number of columns to display to, say, 10 then the display is ok although it is still too narrow as I have a lot of text fields and it tries to display the entire text field. If the column is narrow, it goes downwards.
I would like to be able to display all fields as does phpmyadmin etc, even if the field were to be truncated. Is there some way of fixing the issue?
Thanks as ever for your great help.
Andrew
Thread Starter
mlapl1
(@mlapl1)
In a practical perspective, I can just reduce the columns to what is enough to make the contents recognisable as I would do normally anyway with a listing. So… myabe there is nothing you need to do, Peter.
I think I will mark this solved. If you have any other suggestions that would be fine but I think it has all been solved for me now.
Thanks again
Andrew
Hi Andrew,
You could use CSS to restyle your table. If you set the table with to max-content for example, you will be able to horizontally scroll. But it doesn’t look very nice in the back-end. I think it is better to create a Data Project and limit the number of columns shown on a page.
Hope this helps,
Peter