Finding Objects of Selected Object Type
By dragging and dropping, a user can populate the right side of the window with the desired property sheet fields from the selected object type.
Once the user clicks on the Create Form button, the following query finds all the objects in the database of the selected object type,. Here [MODULE] is a variable and the value depends on the object type.
SELECT Name, Pdm_Blobid
FROM [MODULE]
WHERE pdm_current = 1 AND
pdm_blobid = (SELECT DISTINCT child
FROM parent_list);
Example:
Auto Populate Query