Insert article directly in database? Topic is solved

[henri_007]

I'm programming small app that connect to joomla database and I want to put article directly in database. In which table(s) I should put article? I put in _content, but I don't see it in backend? I guess that I need to insert data in another table, but I don't know in which?

[AMurray]

There's more than one table that makes up the article in Joomla.

https://docs.joomla.org/Tables/content explains it.

To me it's a foreign language, to a developer it makes sense.

[ceford]

I think you need to read through the code of getListQuery function in administrator/components/com_content/src/Model/ArticlesModel.php especially the joins to tables other than #__content. I think you need an entry in #__workflow_associations

You could also turn on debugging and look down the list of queries to find the one used to fetch the articles list. That should give you a clue to what you have not set.

[henri_007]

There's more than one table that makes up the article in Joomla.

https://docs.joomla.org/Tables/content explains it.

To me it's a foreign language, to a developer it makes sense.

Thank you! According that documentation, only foreign key is asset_id, and according this url https://www.itoctopus.com/creating-new- ... sets-table it is not necessary

I think you need to read through the code of getListQuery function in administrator/components/com_content/src/Model/ArticlesModel.php especially the joins to tables other than #__content. I think you need an entry in #__workflow_associations

You could also turn on debugging and look down the list of queries to find the one used to fetch the articles list. That should give you a clue to what you have not set.

Thanks, I will try this....

[gws]

Thank you! According that documentation, only foreign key is asset_id, and according this url https://www.itoctopus.com/creating-new- ... sets-table it is not necessary

I don't see that this link has any relevance to your original question?
Have a look at https://www.[youtube].com/watch?v=YCs6YD_H14c

[pe7er]

I think you need an entry in #__workflow_associations

Create a new article in the back-end. You will see that new article in the Articles overview.
And #__workflow_associations will have a new record for that article.

To see the imported articles, you'll need to create records for those articles in #__workflow_associations as well.

[ceford]

Have a look at https://www.[[youtube]].com/watch?v=YCs6YD_H14c

I watched this video and found it fascinating! I used to teach something on databases and normalisation so the content was familiar to me, except for the WP comparison. Those who need to persuade a boss to choose Joomla rather than WP should take a look.

[henri_007]

Thank you guys! It's need to add record to #__workflow_associations!