For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
See Announcement
Please post subscription issues here
We have resolved the issue with the J! updater and this will be fixed in the next release.
I see that with a databasejoin… I can choose value from the procesos table…Good morning
How could you get that in the "tabla riesgos"
It will store the data in the "ficha proceso" table
And it will also store the data from the "weakness" table and the "threat" table
thank you
I attach an image ...
ok ...Configuring the list to have the right database joins should create a single table that presents values from your various tables and stores them in the correct tables. I don't think you have any need to duplicate the values of one table into another table.
Good morningThere is a database join element, but what you are looking for is the join options inside the list configuration. After clicking a list name, click data on the left-side menu then joins from the tabs that appear.
Good againIt's not clear to me what you want to achieve at all.
As I said:
You can add two databasejoin elements to your riesgos list, one pointing to procesos with Value=id[recommended], Label = risks (or some Concat label),
- a database table used in Fabrik must have a primary key column, integer, autoincrement (if the table was created via Fabrik this is the "id" element, Fabrik element type = "internalid")
- in a list join in Fabrik one "leg" must be a primary key. So the join must go from table1.id to table2.some-foreign-key or it must go from table1.some-foreign-key to table2.id
- So no, you can't join from risks to threads, your join "screenshot" is impossible, in list riesgos you can only join from riesgos
- In your list riesgos you can e.g. add two joins: from riesgos.risks to procesos.id and from riesgos.threat to amenaza.id
one pointing to amenaza with Value=id[recommended], Label = thread (or some Concat label)
The databasejoins are foreign keys.
But these are only "technical" advises, it depends totally on what you want.
Maybe have a look at
https://fabrikar.com/forums/index.php?wiki/design-strategy/
https://fabrikar.com/forums/index.php?wiki/joining-list-and-form-data/
https://fabrikar.com/forums/index.php?wiki/list-joins/
https://fabrikar.com/forums/index.php?wiki/autofill-form-plugin/
NO!!Primary key = foreign key?
Ok primary key is not foreign key (intuition)NO!!