11 years ago
4
Topic

Hello
Please, I tried to make a system where I need to call the Products category grandson (Daily Agenda). This like this:

Category
-- Schedule
---- Daily Agenda
---- Daily Agenda
-- Schedule
---- Daily Agenda
---- Daily Agenda
---- Daily Agenda

I made this configuration:







How do I work this?

Get a Book for SEBLOD
11 years ago
0
Level 1

Hi Petrucci,

Thank you for your post and welcome to SEBLOD forum.

Would you like to have two levels of select? For example, in the first level, you will select category "Agenda". In the second level, you will select all categories whose parent is "Agenda" (for example: "Agenda Diaria", "Agenda Semanal Bolso", ...).

Regards,
Mehdi.

11 years ago
0
Level 1

Hello Mehdi,
Yes that is what I want.
-- Father
---- Son -> Product
-- Another Father
---- Another son -> Products
Are some "Categories" and in each category are some "Sub-categories" and the sub comes the "Products" when I register the products they always go for a single "Categories".
Has some way to go when the product is registered it go to a certain sub-category in the right category?
Thank you
Petrucci

27 Posts
jsfernando
11 years ago
1
Level 1

Mehdi,

Can you give me a help.
Am using Dynamic Select FREE.
Need a result of all users of a particular group.
The syntax in MySQL would be like this:

SELECT U.name, U.id the responsible
FROM # __users U
INNER JOIN # __user_usergroup_map G
ON = U.id G.user_id
WHERE G.group_id = 24

But I noticed that the options option name and value options no longer appear to be Query FREE in the model, then I got a tip for that type would have to be FREE like this:
Field_name_1 AS SELECT text, field_name_2 AS value FROM # __table
How is the help of the field ...

Then I got lost in the construction of SQL syntax because I am using two tables ...
I made these two ways below and showed nothing in the consultation:

SELECT U.name AS SELECT text, U.id AS value
FROM # __users U
INNER JOIN # __user_usergroup_map G
ON = U.id G.user_id
WHERE G.group_id = 24

OR

SELECT text AS __users.name #, # __users.id AS value
FROM INNER JOIN # # __users __user_usergroup_map
__users.id = ON # # __user_usergroup_map.user_id
WHERE # __user_usergroup_map.group_id = 24

The result would show the names of the users group = 24, but the record id of the User field in the Select a table FREE.

Could you help me?

http://tinyurl.com/oume3fs

http://tinyurl.com/px638o6


27 Posts
jsfernando
11 years ago
0
Level 2

Mehdi,

got it

The SQL syntax looked like this:

SELECT text AS __users.name #, # __ users.id AS value
FROM INNER JOIN # # __users __user_usergroup_map
__users.id = ON # # __user_usergroup_map.user_id
WHERE # __user_usergroup_map.group_id = 24

Appears [Faculty Supervisor]
http://easycaptures.com/fs/uploaded/726/7363199289.png

But the time of writing does not work, the field in the table is as int (11).
Error message appears [an error occurred]
I tried to change the SQL and field to see if it would:

Now to save as same name ...
Field in the table varchar (255)

SELECT text AS __users.name #, # __users.name AS value
FROM INNER JOIN # # __users __user_usergroup_map
__users.id = ON # # __user_usergroup_map.user_id
WHERE # __user_usergroup_map.group_id = 24

It worked ... is recording, but the error message still appears [an error occurred]

How and why I use the the error message?

Thank you,

Get a Book for SEBLOD