Where is the link between jos_content and jos_sppagebuilder in der database? - Forum | JoomShaper
Staff replied SP Page Builder

Where is the link between jos_content and jos_sppagebuilder in der database?

Asked by stor71 3 years ago Last activity 3 years ago

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

5 replies

Toufiq Senior Staff

Hi there,

I appreciate you reaching out. I sincerely apologize for this oversight. Database table name is prefix_content.

-Thanks

stor71 Asked this

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

stor71 Asked this

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

Toufiq Senior Staff

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

Log in to reply.