Feng Forum

Support => Feng Office 2 => : lexoyo April 20, 2012, 11:01:50 AM

: Plugin, select all workspaces
: lexoyo April 20, 2012, 11:01:50 AM

Hi
To select all workspace i use this request

"SELECT * FROM `"+Config.TABLE_PREFIX+"objects`
  WHERE "+Config.TABLE_PREFIX+"objects.id in (SELECT "+Config.TABLE_PREFIX+"workspaces.object_id
  FROM "+Config.TABLE_PREFIX+"workspaces)"

I would like to select workspaces which are the children of a given parent  workspace.... But I could not find the table with this info

: Re: Plugin, select all workspaces
: rafj April 20, 2012, 05:40:10 PM

look into table fo_members

: Re: Plugin, select all workspaces
: lexoyo April 21, 2012, 04:26:50 PM

Thanks, it works
Here is how my request looks like :)

SELECT * FROM fo_objects WHERE fo_objects.`id` in (SELECT fo_workspaces.`object_id` FROM fo_workspaces) AND fo_objects.`id` in (SELECT id FROM fo_members WHERE `parent_member_id`="3")