is there a way to exclude fields from a table in a BO


Author
Message
Bradley Marston
Bradley Marston
StrataFrame Novice (58 reputation)StrataFrame Novice (58 reputation)StrataFrame Novice (58 reputation)StrataFrame Novice (58 reputation)StrataFrame Novice (58 reputation)StrataFrame Novice (58 reputation)StrataFrame Novice (58 reputation)StrataFrame Novice (58 reputation)StrataFrame Novice (58 reputation)
Group: Forum Members
Posts: 24, Visits: 119
I was just wondering. Lets say I have a BO mapped to a table with 12 fields

is there a way to have the BO only map to 5

thanks Brad

Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
At the moment, no.  However, there is really no additional overhead having those properties there.  If you do not reference them then it is as though they do not exist.  What is the reason you want to prevent the other properties from being created?
Chan
Chan
Advanced StrataFrame User (723 reputation)Advanced StrataFrame User (723 reputation)Advanced StrataFrame User (723 reputation)Advanced StrataFrame User (723 reputation)Advanced StrataFrame User (723 reputation)Advanced StrataFrame User (723 reputation)Advanced StrataFrame User (723 reputation)Advanced StrataFrame User (723 reputation)Advanced StrataFrame User (723 reputation)
Group: Forum Members
Posts: 533, Visits: 2K
What is the reason you want to prevent the other properties from being created?




Hi,

What if to not download unnecessary data to workstation to improve performance in certain process or screen?
Greg McGuffey
Greg McGuffey
Strategic Support Team Member (3.5K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
I've successfully just not included fields in the returned data. I.e. if you have 12 fields, but only need 7, just reference those 7 fields in the select statements that retrieve the data. Then just remember that when using that Fill method not to reference the fields not included.
Peter Jones
Peter Jones
Advanced StrataFrame User (520 reputation)Advanced StrataFrame User (520 reputation)Advanced StrataFrame User (520 reputation)Advanced StrataFrame User (520 reputation)Advanced StrataFrame User (520 reputation)Advanced StrataFrame User (520 reputation)Advanced StrataFrame User (520 reputation)Advanced StrataFrame User (520 reputation)Advanced StrataFrame User (520 reputation)
Group: Forum Members
Posts: 386, Visits: 2.1K
Hi Guys,

I'm new to SF and most of our tables have columns that are maintained by triggers, e.g. date created, last updated etc and it was my intention to simply create views which excluded these columns. My concern is (with respect) this seems pretty 'obvious' way of doing things but it wasn't mentioned in response to the original question. Does this mean there are issues with using views as bo data sources and have matching stored procedures when filling bo's at run time.

Cheers, Peter

StrataFrame Team
S
StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
No, the structure of DataTable inside the business objects is completely flexible... it can have extra columns, or even not all of the columns that are defined on a business object.  We have several users who are building their business objects off of views and using stored procedures to both select the data into the business objects and save the data back to the multiple tables.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search