Custom LU field attributes

Hi @asjaus ,

I was looking recently to see if there is something we could do to force a unique field value into a persistent field.

It may not be the best approach but if you have access to the oracle database - I created a new sequence in Oracle. I then created a new custom menu of type PL/SQL Block. Inside the block I put something similar to the following:

declare
  attr varchar2(1000);
  objid varchar2(1000);
  info varchar2(1000);
  objversion  varchar2(1000);

cursor c1 is 

select b.objid, b.objversion, {SEQUENCE}.nextval as ID
  from ifsapp.{CUSTOM_VIEW} b
 where b.objid = &OBJKEY;

 begin

 for r in c1 loop
   begin
 ifsapp.client_sys.Clear_Attr(attr);
 ifsapp.client_sys.Add_To_Attr('CF$_ID',r.ID,attr);
 IFSAPP.{CUSTOM_VIEW}.MODIFY__(info, r.objid, r.objversion, attr, 'DO');

  end;

  end loop;
 end; 

and for the conditions I put the ID (the field I wanted a new sequence number in) to not contain anything and the objkey to contain something.

In this instance the user would go to the CLU page create a record - the ID would be blank. They would then right click on the page and they would see a generate ID button. When click and applied - the option would then disappear as the ID would have a value and the condition above would no longer be valid to show.

Kind Regards,

Dan