# wire.data.TableQuery

The `TableQuery` class is used to create queries.  Use the `wire.data.select` method to create `TableQuery` instances.

The following makes a call to a custom web service method `GetUsers` and returns the results into the `data` variable.

```javascript
const accountService = new wire.data.DataSource("custom", {
    ...
});

const query = wire.data.select().from("GetUsers")

const data = accountService.exec(query);
```

`TableQuery` has many methods which allow a target data source to be queried.  Check the target [service provider](https://docs.wirebootstrap.com/wirebootstrap/connecting-to-data/data-connectors) documentation for details including support for `TableQuery`.

The full list of `wire.data.select` methods available is listed below.

```javascript
 wire.data.select([fields])
 
  [.top(number)]
  [.distinct()]
  [.field(field)]
    [.eventName(name)]
 
  .from([entity])
 
  [.join(entity)]
  [.leftJoin](entity)]
  [.rightJoin](entity)]
  [.on(entity,field)]
  [.onValue(field, value)]
 
  [.where([custom expression])]
    [.expression(expression)]
    [.eq(field,value)]
    [.ne(field,value)]
    [.in(field,[values])]
    [.between(field,value1,value2)]
    [.starts(field,value)]
    [.contains(field,value)];
    
  [.groupBy(fields)]
  [.orderBy(field, [desc])]
```

The following example selects the list of active users directly from a SQL database using the [WireBootstrap Query Service](https://docs.wirebootstrap.com/query-service).

```javascript
const accountService = new wire.data.DataSource("table", {
    ...
});

const query = wire.data.select("UserName")
    .from("Users")
    .where().eq("Active", true);
    
const table = accountService.exec(query);
```

For more `TableQuery` examples, visit [Creating Queries - Select Queries](https://docs.wirebootstrap.com/wirebootstrap/creating-queries/select-queries).