rfx response question score

[Former Member]

I am trying to fetch the question score using below query but I am not able to fetch could you please where am doing mistake

SELECT <%RESULTS%> FROM

(SELECT

'1' AS SORDER,

MAX(T5.SECTION_ORDER) AS SECTIONORDER,

T10.VENDOR_REF_OBJECT_NAME AS

SUPPLIER,

T6.PROMPT AS PROMPT,

(CASE WHEN T4.IS_ANSWERED = 1AND

T9.ROUND_LEVEL =0 THEN T8.SECTION_SCORE END) AS QSCORE

FROM

<%SCHEMA%>.FCI_RFX_RESPONSE T1,

<%SCHEMA%>.FCI_ONT_DOCREF T2,

<%SCHEMA%>.FCI_ONT_RESPONSE_DOC

T3,

<%SCHEMA%>.FCI_ONT_ATTRIBUTE_VALUE T4,

<%SCHEMA%>.FCI_ONT_DOC T5,

<%SCHEMA%>.FCI_ONT_ATTRIBUTE

T6,

<%SCHEMA%>.FCI_ONT_ATTRIBUTE_SCORE

T8,

<%SCHEMA%>.FCI_RFX_DOC T9

LEFT OUTER JOIN

<%SCHEMA%>.FCI_RFX_VENDOR T10

ON T9.OBJECTID = T10.PARENT_OBJECT_ID

LEFT OUTER JOIN <%SCHEMA%>.FCI_MAS_VENDOR T11

ON

T10.VENDOR_REF_OBJECT_ID = T11.OBJECTID

WHERE T1.CONTEXTID IN

(<%CONTEXT(rfx.RFXResponse)%>)

AND T1.OBJECTID = T2.PARENT_OBJECT_ID

AND T2.PARENT_CLASS_ID = 905

AND T3.OBJECTID = T2.COUPLED_OBJ_OBJECT_ID

AND T2.COUPLED_OBJ_CLASS_ID = 771

AND T3.OBJECTID = T4.PARENT_OBJECT_ID

AND T5.OBJECTID = T3.ONTOLOGY_DOC_OBJECT_ID

AND T6.OBJECTID =

T4.ATTRIBUTE_OBJECT_ID

AND T3.OBJECTID=T8.PARENT_OBJECT_ID

AND

T9.OBJECTID=T1.PARENT_OBJECT_ID

AND T9.OBJECTID =

<%?(CurrentDocument)%>

GROUP BY

T10.VENDOR_REF_OBJECT_NAME,T6.PROMPT,T4.IS_ANSWERED

,T9.ROUND_LEVEL,T8.SECTION_SCORE

<%ORDERBY%>

)

[Former Member]

Hi Venkat,

Please find the below screenshot.

This has been taken from Database ERD.

The Hierarchy is, FCI_RFX_DOC table is parent, then comes FCI_CS_DOC table and then FCI_CS_SCORE_ATTR table.

Develop a query by using these 3 tables, you will get the RFx response score value from FCI_CS_SCORE_ATTR table(I have marked in red).

Hope this helps!!

Regards,

Vignesh

[Former Member]

Hi Expert,

I am not looking Collabrator score

I am looking RFx Response each Question Score .