JDBC Driver for Zoho Books

Build 22.0.8479


Generated schema file.

Table Specific Information


The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.

  • TransactionDate supports the '=' comparison.
  • ToMonth supports the '=' comparison.
  • FromMonth supports the '=' comparison.
For example:
    SELECT * FROM businessperformanceratiosreport

    SELECT * FROM businessperformanceratiosreport WHERE TransactionDate = 'PreviousQuarter'

    SELECT * FROM businessperformanceratiosreport WHERE TransactionDate = 'CustomDate' and FromMonth = '2022-10' and ToMonth = '2022-11'


Name Type References SupportedOperators Description
DashboardMonth String DashboardMonth
Denominator Integer Denominator
DiffLastQuarter Double DiffLastQuarter
DiffLastSixMonths Double DiffLastSixMonths
DiffLastTwelveMonths Double DiffLastTwelveMonths
DiffLastYear Double DiffLastYear
LastQuarter Integer LastQuarter
LastSixMonths Double LastSixMonths
LastTwelveMonths Double LastTwelveMonths
LastYear Double LastYear
Numerator Integer Numerator
PreLastQuarter Double PreLastQuarter
PreLastSixMonths Double PreLastSixMonths
PreLastTwelveMonths Double PreLastTwelveMonths
PreLastYear Double PreLastYear
PreviousValues String PreviousValues
Ratio Integer Ratio
RatioPrev Integer RatioPrev


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
TransactionDate String Filter transaction by any transaction date.

使用できる値は次のとおりです。PreviousQuarter, PreviousYear, LastSixMonths, LastTwelveMonths, CustomDate

ToMonth String To Months
FromMonth String From Month
UseState Boolean UseState


Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479