Re: [D] MongoQuery is not picking runtime value from previous transform (hop)

[via GitHub]

GitHub user swaroopchenchu edited a discussion: MongoQuery is not picking 
runtime value from previous transform

Hi,

<img width="1335" height="774" alt="image" 
src="https://github.com/user-attachments/assets/9d87a8bf-046a-43be-ad35-0b1c109307f7";
 />

I am placing my mongoDB input transform

`<?xml version="1.0" encoding="UTF-8"?>
<pipeline-transforms>
<transforms>
  <transform>
    <name>MongoDB input</name>
    <type>MongoDbInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>MONGO_DB_GENERIC</connection>
    <fields_name/>
    <collection>optiva/1/billingAccounts</collection>
    <json_field_name>json</json_field_name>
    <json_query>{ &#34;externalID&#34;: &#34;${parentBAN}&#34; }</json_query>
    <output_json>N</output_json>
    <query_is_pipeline>N</query_is_pipeline>
    <execute_for_each_row>Y</execute_for_each_row>

    <mongo_fields>
      <mongo_field>
        <field_name>relatedParty</field_name>

        <field_path>relatedParty</field_path>

        <field_type>JSON</field_type>

      </mongo_field>
      <mongo_field>
        <field_name>contact</field_name>

        <field_path>contact</field_path>

        <field_type>JSON</field_type>

      </mongo_field>
      <mongo_field>
        <field_name>name</field_name>

        <field_path>name</field_path>

        <field_type>String</field_type>

      </mongo_field>
      <mongo_field>
        <field_name>parentBAN</field_name>

        <field_path>externalID</field_path>

        <field_type>String</field_type>

      </mongo_field>
    </mongo_fields><attributes></attributes>
    <GUI>
      <xloc>240</xloc>
      <yloc>128</yloc>
    </GUI>
    </transform>

</transforms>
<order>
</order>
<notepads>
</notepads>
<transform_error_handling>
</transform_error_handling>
</pipeline-transforms>
`

And also other issue when i send manual value and preview its not fetching 
array object came null
<img width="940" height="387" alt="image" 
src="https://github.com/user-attachments/assets/e209275f-beea-466b-b841-3f20a669b095";
 />


If I change field path in mongoDBinput transform
<img width="573" height="364" alt="image" 
src="https://github.com/user-attachments/assets/f91ec9c2-0ce3-4361-be63-687e11b914a5";
 />
and try preview
<img width="1629" height="362" alt="image" 
src="https://github.com/user-attachments/assets/fa0b68b0-a0f4-4ba9-8c24-8acbd1458ab6";
 />


Any please help me on this

Thanks

GitHub link: https://github.com/apache/hop/discussions/5555

----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscr...@hop.apache.org