HI @NMALKI,

Can you try the below statement for the select statement?

select CF$PACKAGING_GROUP from SAFETY_PRECAUTION_cfv where cf$_hazard_id = :cf$_hazard_id

Best Regards,
Bhagya

nah it didn’t work ‘Invalid identifier because the field is hazard_id  in SAFETY_PRECAUTION_cfv (not hazard_id_cfv).

thanks anyway 

Hi @NMALKI,

In arguments, if you are taking the value from the view, it should be prefixed with v, not t. Therefore try changing the argument to v.cf$_hazard_id.

And the way you have specified the bind variable in the select statement is also not correct. 

Try this SQL statement instead.

select CF$_PACKING_GROUP from SAFETY_PRECAUTION_CFV where HAZARD_ID = :CF$_HAZARD_ID

Also refer to the documentation for select type read only Custom Fields here:

https://docs.ifs.com/techdocs/foundation1/040_administration/220_user_interface/020_custom_objects/040_custom_fields/020_create_custom_fields/steps_itd/set_ImplementationType.htm?nobanner=true

This explains what I mentioned above. 

Hope this helps!

@Charith Epitawatta thanks for your clarification . 

Still no result when I tried the above SQL.

I also have the below error when I try to use v.cf$_hazard_id.

Thanks 

Hi @NMALKI,

@Charith Epitawatta thanks for your clarification . 

Still no result when I tried the above SQL.

I also have the below error when I try to use v.cf$_hazard_id.

Thanks 

According to this message, you are creating this field on a Custom Logical Unit. In that case, please check whether the field CF$_HAZARD_ID exists in the relevant database table first(H_A_Z..._CLT table mentioned in above message) and prefix the argument with t instead of v as the error message explains. 

Hope this helps!