obj_isphysical(path)

Returns a boolean value that indicates if the object at the given path is a saved physical table. (Available as of version 10.23)

Syntax

obj_isphysical(path)

Input

Argument Type Description
path text A path to an object (e.g., table, folder, query)

The path parameter can be a scalar value (e.g., pub.demo.retail.item) or the name of a column containing paths to objects.

If path is the empty string (e.g., ''), the function returns information corresponding to the root-level folder, which contains all of the top-level folders (e.g., pub, default, uploads).

Return Value

Returns an integer value of 1 or 0 that indicates whether or not the object at the specified path is a physical table saved on the 1010data Insights Platform.

Returns 0 if the path does not exist.

Example

The following example demonstrates the behavior of obj_isphysical(path) using the values in the example_path column specified via the <table> element.

<table cols="example_path">pub.demo.retail;
  pub.demo.retail.item;
  pub.demo.retail.selectionlib;
  pub.demo.retail.foo;
  default.doc.interactive.trsgsg_qa;
  default.doc.interactive.doc_lib;
  foo;
  ;
</table>
<col name="example_path" format="width:35"/>
<willbe name="obj_isphysical_result" value="obj_isphysical(example_path)"/>

Note: When the value of the path parameter is equal to the empty string, the function returns information corresponding to the root-level folder in the 1010data Insights Platform, which contains all of the top-level folders (e.g., pub, default, uploads).