In record producer, I have a Variable referencing HR Profile table. I used ref_ac_columns to display the fields. But I could see only name and personal email id. Other fields like first name, employee number, manager I cant see.
Why it is not showing all fields.
Thankq.
I would appreciate if you go through the previous similar queries from next time. Its very useful.
Thanks for ur quick response.
I have used the same thing but it doesnt work for fields like- first name, last name. Check the fields in HR Profile table, those have User.field name that is fields from User table.
Used: - ref_ac_columns=first_name;personal_email;last_name
Do I need to Use some dot operator for these fields?
No I dont think so.
And where would you use dot operator as we are working on the ref attributes?
I tried replicating your case.
Yeah not able to use with dot fields.
When we refer it from field referencing HR Profile table it is accessible but not available from Variable.
