Where is The Link Between Jos_content And Jos_sppagebuilder In Der Database? - Question | JoomShaper
Black Friday sale is live with flat 50% OFF. Sale ends soon! Grab your deal now!

Where is The Link Between Jos_content And Jos_sppagebuilder In Der Database?

S

stor71

SP Page Builder 2 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

0
5 Answers
Toufiq
Toufiq
Accepted Answer
Senior Staff 2 years ago #106657

Hi there,

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

-Thanks

0
S
stor71
Accepted Answer
2 years ago #106862

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

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 2 years ago #106877
0
S
stor71
Accepted Answer
2 years ago #106930

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

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 2 years ago #107006

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

0