MySQL request to sort articles in a readable way (SQL 2 XLS)

More
14 years 3 weeks ago #10930 by tcherno
Hello!

I would like to export the flexicontent articles in an easy way. For this, we can use the component "SQL 2 EXCEL" ( joomla-r-us.com ).

I would need an SQL query that make the content readable:

- title
- description
- fields

Everything we see on the website frontend.
On the same sheet, fields in columns and rows.

As I am not an SQL export (faaar from that), I don't know how to sort this, what SQL query to use.

Now, I use the "jos_flexicontent_items_ext" table, as the whole article is printed, but the result is not optimal, as all the content is in the same cell.

Thank you very much! :)

The request I use to display the table:

SELECT type_id,language,search_index
FROM `jos_flexicontent_items_ext`
WHERE `language` = 'fr-FR'
ORDER BY `jos_flexicontent_items_ext`.`type_id` ASC

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.256 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline