[]
        
(Showing Draft Content)

C1.DataEngine.Workspace.query

query Method

query(string, object)

Creates a query based on a single table or query (not a join).

Declaration
public ExpandoObject query(string name, object settings)
Parameters
Type Name Description
string name

Name of the query. If the name is specified, query result is stored on disk.

object settings

Columns of the result, and other settings of the query.

Returns
Type Description
ExpandoObject

Dynamic object representing the query.

Remarks

The dynamic object can be used in queries over the result of this query if such are needed, same way as in table(string) Also, it has a Query property that returns the Query object representing this query. It is used for executing the query:

dynamic query1 = workspace.query(...);
query1.Query.Execute();

query(object)

Creates a query based on a single table or query (not a join).

Declaration
public ExpandoObject query(object settings)
Parameters
Type Name Description
object settings

Columns of the result, and other settings of the query.

Returns
Type Description
ExpandoObject

Dynamic object representing the query.

Remarks

The dynamic object can be used in queries over the result of this query if such are needed, same way as in table(string) Also, it has a Query property that returns the Query object representing this query. It is used for executing the query:

dynamic query1 = workspace.query(...);
query1.Query.Execute();