+15I’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.
Best answer by Minoshini Fonseka
Hi
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;
+19Hi
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;
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
