Skip to main content

Hi All, 
 

I am trying to implement a custom field so our users can see some historical information on work tasks. I can get the SQL to work using the SQL query tool, my issue seems to be with my arguments. 

My code is as follows:

Argument:
v.source_ref1
Select Statement:
select * from (select performed_work from jt_task_CFV where (state like '%Done' or state like 'Finished')  and source_ref1 =: source_ref1  order by TASK_seq desc ) where rowNum = 1


The error I receive is “The Column source_ref1 referred to in table t is not an approved persistent Custom Attribute”



Any assistance would be much appreciated.

@hburkett 

I had something similar for a custom field I created recently.  In your case, source_ref1 isn’t in JT_TASK_LOV and it isn’t in JT_TASK_CFT, but it is in JT_TASK.  Check the Approved Detail Views to see if JT_TASK_UIV is approved.  If it is, you may need to toggle it off and on again.  Then retry the validation on the new custom field.

And I’m not sure if it matters or not, but I’ve never used “v.” in front of my Arguments list.  It may be fine, I’ve just never done it that way.

@hburkett @Tracy Norwillo The best way to overcome this is to include the statement; In your case

“select * from (select performed_work from jt_task_CFV where (state like '%Done' or state like 'Finished')  and source_ref1 =: source_ref1  order by TASK_seq desc ) where rowNum = 1”

Inside an API  as a function and refer to the API using the primary key and return the value you require.

Reply


Terms & ConditionsCookie settings