Type alias QuickBaseResponseGetTableReports

Type declaration

• description: string

  The configured description of a report.

• id: string

  The identifier of the report, unique to the table.

• name: string

  The configured name of the report.

• ownerId: number

  Optional, showed only for personal reports. The user ID of report owner.

• properties: any

  A list of properties specific to the report type. To see a detailed description of the properties for each report type, See Report Types.

• query: {
      filter: string;
      formulaFields: {
          decimalPrecision: number;
          fieldType: "rich-text" | "text" | "numeric" | "currency" | "percent" | "rating" | "date" | "timestamp" | "timeofday" | "duration" | "checkbox" | "phone" | "email" | "user" | "multiuser" | "url";
          formula: string;
          id: number;
          label: string;
      }[];
      tableId: string;
  }

  The query definition as configured in Quickbase that gets executed when the report is run.

  • filter: string

    Filter used to query for data.

  • formulaFields: {
        decimalPrecision: number;
        fieldType: "rich-text" | "text" | "numeric" | "currency" | "percent" | "rating" | "date" | "timestamp" | "timeofday" | "duration" | "checkbox" | "phone" | "email" | "user" | "multiuser" | "url";
        formula: string;
        id: number;
        label: string;
    }[]

    Calculated formula fields.

  • tableId: string

    The table identifier for the report.

• type: "map" | "gedit" | "chart" | "summary" | "table" | "timeline" | "calendar"

  The type of report in Quickbase (e.g., chart).

• usedCount: number

  The number of times a report has been used.

• usedLast: string

  The instant at which a report was last used.