topic MongoDB DBref field not found in Load script in Qliksense in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/MongoDB-DBref-field-not-found-in-Load-script-in-Qliksense/m-p/1956915#M11097 <P>Hi All,</P> <P><SPAN>Can you please help me with below issue in Qlik Sense to MongoDB connectivity.</SPAN></P> <P><SPAN>While fetching data fields from MongoDB to Qlik sense using MongoDB BI connector and Qlik ODBC connector,&nbsp; we are not getting "DBref" field names from any table from MongoDB.</SPAN></P> <P><SPAN>Below is a sample field from MongoDB which is not fetched/identified by Qliksense Load script:</SPAN></P> <P><SPAN>"<STRONG>placement</STRONG>" :</SPAN><SPAN>&nbsp;DBRef</SPAN><STRONG><SPAN>(</SPAN></STRONG><SPAN>"placement"</SPAN><STRONG><SPAN>,</SPAN></STRONG><SPAN>&nbsp;ObjectId</SPAN><STRONG><SPAN>(</SPAN></STRONG><SPAN>"60d64b6654a89f56347929fb"</SPAN><STRONG><SPAN>))</SPAN></STRONG></P> <P><STRONG><SPAN>Definition: </SPAN></STRONG>in program collection points to"_id" attribute of placement collection.</P> <P>&nbsp;</P> <P><SPAN>Please note that we are using ODBC connector to connect MongoDB 4.2 version.</SPAN></P> <P><SPAN>Any help is appreciated!!</SPAN></P> Mon, 18 Jul 2022 07:36:18 GMT Geekwarrior007 2022-07-18T07:36:18Z MongoDB DBref field not found in Load script in Qliksense https://community.qlik.com/t5/Connectivity-Data-Prep/MongoDB-DBref-field-not-found-in-Load-script-in-Qliksense/m-p/1956915#M11097 <P>Hi All,</P> <P><SPAN>Can you please help me with below issue in Qlik Sense to MongoDB connectivity.</SPAN></P> <P><SPAN>While fetching data fields from MongoDB to Qlik sense using MongoDB BI connector and Qlik ODBC connector,&nbsp; we are not getting "DBref" field names from any table from MongoDB.</SPAN></P> <P><SPAN>Below is a sample field from MongoDB which is not fetched/identified by Qliksense Load script:</SPAN></P> <P><SPAN>"<STRONG>placement</STRONG>" :</SPAN><SPAN>&nbsp;DBRef</SPAN><STRONG><SPAN>(</SPAN></STRONG><SPAN>"placement"</SPAN><STRONG><SPAN>,</SPAN></STRONG><SPAN>&nbsp;ObjectId</SPAN><STRONG><SPAN>(</SPAN></STRONG><SPAN>"60d64b6654a89f56347929fb"</SPAN><STRONG><SPAN>))</SPAN></STRONG></P> <P><STRONG><SPAN>Definition: </SPAN></STRONG>in program collection points to"_id" attribute of placement collection.</P> <P>&nbsp;</P> <P><SPAN>Please note that we are using ODBC connector to connect MongoDB 4.2 version.</SPAN></P> <P><SPAN>Any help is appreciated!!</SPAN></P> Mon, 18 Jul 2022 07:36:18 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/MongoDB-DBref-field-not-found-in-Load-script-in-Qliksense/m-p/1956915#M11097 Geekwarrior007 2022-07-18T07:36:18Z