Query Views, Columns from federated data source

HCL Domino Domino Forum
1

I trying to set up a query view that queries federated data. I am using the query below and it returns the correct number of rows in the view. But I cannot get values in columns. I thought I should give a column a value that matches the columns from the query: 'CUSTOMERID". What am I missing. Thx David.

SELECT CUSTOMERID FROM ADMINISTRATOR.CUSTOMERS ORDER BY CUSTOMERID

2

Subject: resolved

Had convert the column to varchar:

SELECT VARCHAR(CUSTS.CUSTOMERID) AS CID FROM ADMINISTRATOR.CUSTOMERS AS CUSTS

Then have a column value of CID.