Unable to view the value of extended definition

[Former Member]

Hi,

I added a value from the extension schema into the result field of the query. But I am able to view only the header and not the values. The column remains blank. What might be the problem with this? This additional fields have been added to the value list types and values and also in the Extension definition. I used the below query and the result field. I was able to display the Value Cycle/Customer Department and contracts but not the other two.

Please help.

SELECT <%RESULTS%>

FROM

FCI_CONTRACT C, <%EXT_TABLE(contracts.Contract)%> AE

WHERE

C.CONTEXTID = <%CONTEXT(contracts.Contract)%>

AND

C.OBJECTID=AE.PARENT_OBJECT_ID

<%ORDERBY%>

Column Header Resource * Database Column Name

******************************************************************************************************************************************************

Class ID * 101 AS CLASSID 1(Ascending)

Value Cycle/Customer Department * FCI_MAS_GETVLVRESID(AE.VALUECYCLE_OBJECT_ID)

Local_Regional_Global Field * FCI_MAS_GETVLVRESID(AE.Local_Reg_Glb_OBJECT_ID)

Options * FCI_MAS_GETVLVRESID(AE.OPT_IN_AGR_OBJECT_ID)

Contracts * FCI_MAS_GETVLVRESID(AE.CONTRACTTYPE_OBJECT_ID)

Thanks in Advance

Sharmele.

[Former Member]

Sharmele,

What is the column type that you have defined for the field in question? Make sure it is appropriate for the returning of the resource_OBJECT_ID

-Howie