Skip to main content

I’m trying to create persistent reference type custom field in a custom logical unit.

I want to create two custom fields for project id and for subproject id.

In order to get a LOV, I tried to connect to views which are already exists in  Project Time Registration window, PROJECT_APPROVED_COMPANY_PA and SUB_PROJECT_APPROVED_PA.

But I was unable to connect those views.

Can you please explain.

 

Hi @MitDenukN ,

When you are using a ProjView it appears that it does not have a base table. So, you won’t be able to use views related to that. 

If you use a view of logical unit where there is a base table, you will be able to add that reference to your custom field. 

Technically, if you want to find whether that logical unit has a base table, you can use following code to check.
 

begin
-- Call the function
:result := dictionary_sys.get_base_table_name(lu_name_ => :lu_name_);
end;

 


Hi @Minoshini Fonseka,Thank you very much for the explanation. :blush: