Hi all,
the Page Builder is great. We use it on different sites. We access the Joomla and Page Builder via ODBC and we've activated the "Joomla Article Integration". We planned to duplicate some Articles and needed to duplicate to Page Builder Site of these Joomla Articles too. Now my question:
What is the link between the database tables "jos_content" and "jos_sppagebuilder"? I thought it will use the ID from jos_content, but I found nothing. Can you please help me?
Thanks,
Rolf
Where is the link between jos_content and jos_sppagebuilder in der database?
5 replies
Hi there,
I appreciate you reaching out. I sincerely apologize for this oversight. Database table name is prefix_content.
-Thanks
Hi,
thanks for you answer, but i know the table prefix_content. Ok, again:
When in SP Page Builder the function "Joomla Article Integration" is activated, after the creation of an article there is a new enty in the table prefix_content and also in prefix_sppagebuilder. But what field or whereever is the link between these two entries? That's what i needed.
Please help!
Thanks
Thanks, but I may have asked the question incorrectly. Sorry, new try:
The following example: When I create a new post in Joomla, a record with ID 124 is created in the table jos_content. And a new record with the ID 132 is automatically created in the table jos_sppagebuilder.
As soon as I click on "Edit with SP Page Builder" in the article and add add-ons in the Page Builder and save this, this content is in the field "text" of the table jos_sppagebuilder.
In this case, the content of the "text" field begins with [{"id":1677589710955
Now to my question:
In my query I have in this case the record in the table jos_content with the ID 124. How do I now find the corresponding record in the table jos_sppagebuilder that contains the SP Page Builder content for this article? In this case, the record with the ID 132. How are these two records linked?
Hopefully you'll understand now...
Thanks
Earlier I shared a screenshot. We just used the extension & Extension_view columns to connect with the Joomla content to Page Builder. Joomla item id and Page Builder item id won't be the same. Thanks