Hello gba,
welcome on SEBLOD.
The first thing to do with SEBLOD, it's to not to think "table", let SEBLOD doing what he has to do.
A groupX is a field which allow you to repeat a group of fields. The best way to do that:
- 1 - Make a content type (the group) with all fields with NO storage.
- 2 - In your general content type, add a GroupX field, in which you set the name of the previews group.
- 3 - The GroupX MUST have the storage " Custom | Article | database_field[my_field] "
That's all you need to do.
if you don't play with the padlock in the form view, SEBLOD store your fields in a table "#__cck_core_store_form_nameofyourcontenttype".
Now, if you want to make a search on date range, it's a little more different.
In the group, the field "date" must have the same storage as the groupX field in the main content type, like that :
" custom | free | #__cck_core_store_form_nameofyourcontenttype | database_field " (without [my_field]).
And for date range, you will need this field 2 times, so you must create an alias of this field, like that:
name : date_alias
storage : the same : " custom | free | #__cck_core_store_form_nameofyourcontenttype | database_field "
After that, in the search form, add those 2 fields, with option 3 select the matches:
- First field : "Date & Time Futur"
- Second firld: "Date & Time Past"
and in option 3 parameter (+), set on which collection those fields are linked.
Hope it will help you.
Best regards.
Lionel