@sourceloop/reporting-service / Exports / StructuredQueryInterface
Interface: StructuredQueryInterface¶
Table of contents¶
Properties¶
Properties¶
from¶
• from: Object
Type declaration¶
| Name | Type |
|---|---|
dataSources |
string[] |
joins? |
{ dataSource: string ; on: string ; type: string }[] |
Defined in¶
services/reporting-service/src/interfaces/structured-query.interface.ts:30
limit¶
• Optional limit: number
Defined in¶
services/reporting-service/src/interfaces/structured-query.interface.ts:43
offset¶
• Optional offset: number
Defined in¶
services/reporting-service/src/interfaces/structured-query.interface.ts:44
orderBy¶
• Optional orderBy: { field: string ; order: "asc" | "desc" }[]
Defined in¶
services/reporting-service/src/interfaces/structured-query.interface.ts:39
select¶
• select: Object
Type declaration¶
| Name | Type |
|---|---|
distinct? |
boolean |
fields |
(string | { alias: string ; field: string })[] |
functions? |
{ alias?: string ; field: string ; functionType: "COUNT" | "SUM" | "AVG" | "MIN" | "MAX" }[] |
Defined in¶
services/reporting-service/src/interfaces/structured-query.interface.ts:21
where¶
• Optional where: WhereClause
Defined in¶
services/reporting-service/src/interfaces/structured-query.interface.ts:38