• ⌂ Object Methods
• Methods
  • .IN_FOLDER()
  • .POSITION_IN()

.IN_FOLDER()

Return TRUE if an object is in a Folder where the object is not the main object in the FROM clause, but instead referenced through a field.  An object can be referenced through multiple fields using dot-notation.  For example, Parent.Parent.IN_FOLDER(/Folder).

Prototype

boolean .IN_FOLDER(cpath $cpath)

Parameters

• cpath - cPath, OID, DOID (ie. 123D) or UUID that references a folder or object that extends folder.

Return

TRUE if the object is in the specified folder, otherwise FALSE.

Examples

Folder cPath Example

SELECT * FROM WebPage ORDER BY Parent.IN_FOLDER(/Website/Content)

Folder OID Example

SELECT * FROM WebPage WHERE Parent.IN_FOLDER(123)

Related

IN_FOLDER(), POSITION_IN(), .POSITION_IN()

• < Object Methods
• .POSITION_IN() >