Question

Custom Field error - not an approved persistent Custom Attribute

  • 25 July 2023
  • 1 reply
  • 214 views
H
Rank
Badge +2

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.

1 reply

T
Rank
Userlevel 4
Badge +12

@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.

Reply


Terms & ConditionsCookie settings