Calling system property from script Include and calling script include in record producer

[TEJAS]

Hi All,

I hope you're doing well
I have a requirement where i am calling system property from script include and calling the script include in record producer one of the variable but i am getting null value in the form.
My requirement is i should get like this 

in my instance i am getting null value 

In system property i am assigning some value from Tables Please refer the below attachment for System property ,Script include and Record producer variable .

System property 

Script include 

Record producer variable 

Null value

Thanks in advance 
@TEJAS K J 

[_Gaurav · Accepted solution]

@TEJAS  
I tried in my PDI & it works for me

[_Gaurav]

Hi @TEJAS  
Instead of selecting an advanced reference qualifier, can't you use a simple reference qualifier and add all the conditions directly there as you're already referencing the 'sys_db_ojbect' table?

Please mark this as a solution and helpful if this resolves your query.

Thanks!

[TEJAS]

Thanks for the reply @_Gaurav ,
I tried using simple reference qualifier also at that time also i am not getting the values 

[_Gaurav]

Hi @TEJAS  
Can you share the snippet for the same?

[TEJAS]

Hi @_Gaurav ,
Variable pic

---

@_Gaurav wrote:

Hi @TEJAS  
Can you share the snippet for the same?

---