Home RAP
New Blog Posts: Merging Reports - Part 1 and Part 2

Query builder & domain fields

edited December 2006 in RAP
I use ReportExplorer and ReportDesigner with ZeosLib components to build
end-users reports in a PostgreSQL database.

When I try to build a query in Data Tab from ReportDesigner, the list of
available fields from a table not include fields of data type associated to
custom domain.

Example:

CREATE DOMAIN zip_code_type AS VARCHAR(6) NOT NULL;
CREATE TABLE states (id INT4, name VARCHAR(100), zip_code ZIP_CODE_TYPE);

Only fields id and name are listed as available fields to be included in
query results.
Thakns

Fernando L. Garetto
Desarrollo
FULFILL TECHNOLOGY S. A.
27 de Abril 424 3ro. A
X5000AEJ - C?RDOBA - RA
TE: 54 351 4283419
http://www.fulfill-tech.com

Comments

  • edited December 2006

    Please do not cross post.

    This question has been answered in the End-User newsgroup, although the DADE
    newsgroup would be more appropriate. :)


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.