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.

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

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,