Problem

A request was made to confirm where in the database you need to look to locate objects in the basket.

Solution

As of 15.4.1 you can do the following:

SELECT a.object_id,a.object_type FROM gui_structures a
INNER JOIN gui_folders f ON a.gui_folder_id = f.gui_folder_id
INNER JOIN settings s ON f.gui_folder_id = s.value
INNER JOIN setting_defs d ON d.setting_id = s.setting_id
INNER JOIN persons p ON s.object_id = p.person_id
WHERE d.code = 'PersonalBasketId' AND p.person_code = 'ADMIN'

External Links

Bentley Technical Support KnowledgeBase

Bentley LEARN Server

Comments or Corrections?

Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!