Good Day All,
I have a field 'Active' in all of my BO. Instead of deleting I want to do soft deletes by just changing this field from 'Yes' to 'No'. I can easily create an 'Operations with Records' entry to execute a process to do the update.
But in my process I have to specify the BO name then the attribute like so.
TaskCardDefaults.Active = 'No'
But this means I need a separate process for every BO.
Is there a way to structure this so I can do it in 1 process? I have tried 'THIS' but does not work.
Thanks
Can you pass a generic BO name to process?
Re: Can you pass a generic BO name to process?
You could put the BOs in a BO Group and have that attribute be common to all in the group.
Tom - V8.8 build 3137 - MySql / PostGres
Re: Can you pass a generic BO name to process?
Great!! That works nicely.
Thanks tford
Thanks tford
Re: Can you pass a generic BO name to process?
there's database overhead associated with BOs in groups.
Don't know the extent of your application, but tables must be joined together (Union) for groups - if it were me, I'd examine SQL Profiler (if MS SQL) to see if you observe lots of "extra" reads when setting this field.
There's no overhead (only annoyance) in having to create 5,10,15 "kinda redundant" processes.
Don't know the extent of your application, but tables must be joined together (Union) for groups - if it were me, I'd examine SQL Profiler (if MS SQL) to see if you observe lots of "extra" reads when setting this field.
There's no overhead (only annoyance) in having to create 5,10,15 "kinda redundant" processes.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL
Re: Can you pass a generic BO name to process?
Jaymer, this is important information.
Would the extra overhead be evident in normal usage of these BO or only when accessing via the BOG?
Thanks
Would the extra overhead be evident in normal usage of these BO or only when accessing via the BOG?
Thanks
Re: Can you pass a generic BO name to process?
I agree its important.
But I can't tell you under what circumstances you're gonna feel it.
Whats your backend db?
But I can't tell you under what circumstances you're gonna feel it.
Whats your backend db?
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL
Re: Can you pass a generic BO name to process?
cant help you there. no idea how to do SQL monitoring there.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL
Re: Can you pass a generic BO name to process?
If I notice any slowdown I will remove the BOG approach and go back to individual process.
Would it not make sense to have a way to pass the BO name into the process so that you could better utilize your code segments?
Would it not make sense to have a way to pass the BO name into the process so that you could better utilize your code segments?
Re: Can you pass a generic BO name to process?
I hear what you’re saying, but I’ve never had that be an issue for myself. In your specific case, you are noticing that right now, because you have a field named the same exact thing across many BOs. I can’t say that happens to me a lot, so it’s never really been an issue.bwalk wrote: Would it not make sense to have a way to pass the BO name into the process so that you could better utilize your code segments?
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL