8 years ago
4
Topic

Hi,

I have in my database an existing (non Joomla) table of ~ 100K rows

So, I "Create Blank" a New Form & Content Type.
in which, I create Standard Free fields that link to the table,
(Parameters on the table MYTABLE, I choose the column COMPANY)

Please note that there is a bug here :
when I clcked first on MYTABLE, no fields where shown on the dropdown : I had to rename the table #__MYTABLE to be able to see the fields :
- if the table has to be named as other J! tables #__.... because this is a requirement, we should not see the
MYTABLE name in the Parameters list
- if the table can be named without #__...., we should see its fields in the following dropdown.
My preference goes to then latter.


I entered a few companies that were correctly saved in #__MYTABLE

Then I created a List & Search Type
I could see in the list the companies I entered, but only these companies.
The ~100K initial companies did not show.

Sor I invastigated and discovered the #__cck_core table
and was very surprised that it has 1 row per entry I created in #__MYTABLE
(and of course no row for the rows that were already in #__MYTABLE).

So do you mean that Seblod must have one row in that #__cck_core table for any row in a free table ?
Knowing that this table is the smallest (I have 5 more tables of ~500K to ~1M rows each of them), I ask to experts if
there is a better use of Seblod that would allow to get rid of that #__cck_core table ?

Get a Book for SEBLOD
154 Posts
WebOne
8 years ago
1
Level 1

For your form what is your OBJECT set to?

8 years ago
0
Level 2

When creating the form, I have set the Object to "Free". May be should have set it to None ? (in this case, I don't want Article neither User)

154 Posts
WebOne
8 years ago
1
Level 1

Object: Free is correct.

For more information on how Seblod handles these types of forms :

www.seblod.com/community/forums/lists-search-types/no-search-result-with-a-free-object-table-search

8 years ago
0
Level 2

Thank you. It helped.

Get a VIP membership