How can I make a persistent user field equal a derived field?

Good Morning. I need to make a few user fields accessible in dbexport in IPA. I know the fields have to be persistent fields and can not be derived fields. So, I created a derived field and a user field. My idea was to make the user field equal the derived field. However, everything I tried is not working. I tried adding LPL to user field = derived field. I tried field rules to make the default value the derived field, didn't work.

Is there any way I can do this? (We have be able to do this in a custom business class but added the code in the business class LPL. The fields I'm adding are in the CodeBlockRelationDetail business class.

Any help/suggestions would be appreciated. Thank you.

Find more posts tagged with

LSF/Landmark Development

Accepted answers

All comments

robert-nevinger

Have you tried a combination of Field Rule & Initial Value ?

Dr. Awesome

What isn't working? The user field is always blank when you export it? The export fails or something?

A user field on a delivered BC should be automatically available in ISD, web services, IPA, dbexport or online. Could security be making the field appear empty because you don't have access? Can you find the BC in Data Menu search and use Export to CSV, does that work?

Noe Ramos

I'm trying to do this same thing as well. Looking for some insight. I created a derived field within the Employee bc. i then created a persistent field within the Employee bc. i understand the derived value wont pull when using API so i was trying to prepopulate the persistent field based on the derived field criteria so i'm able to pull the persistent field data via API. Is there a sort of call or pull that i need to do so that the persistent field is populated for all employees or is that data filled at the moment of the api call?

andy

"i understand the derived value wont pull when using API"

Are you making Raw Data Web Service API calls? In my experience derived fields can be returned by Raw Data Web Service API calls.

sara_moffett

I have this same issue and have tried everything I can think of. I tried creating a condition instead of using the full If/When statement, using field rules in the persistent user field code, tried it in the derived field itself to say if the statement is met than = the userfield. I even tried creating an action and invoking that but nothing will work. I was using booleans, tried using numeric instead. Same thing. I see that the derived field is creating a True value appropriately, but the user field will simply not update -- just stays blank no matter what I do. We're trying to pull this data from the database and since derived fields aren't available there, we have to get that information into a persistent field. I'll keep trying every combination but if anyone has figured this out please respond!

Copyright © 2025 Infor. All rights reserved.