Where does BOMapper store Nulltype and Null Replacment value?


Author
Message
Charles R Hankey
Charles R Hankey
StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)
Group: Forum Members
Posts: 524, Visits: 30K
I'd like to write some sprocs to handle stuff like setting the Nulltype and Null replacement values for UIDs , for example.



Can't find where they are stored in the strataframe data. Is there another table someplace that is joined to the fields table?



Guidance appreciated.



ER for BOMapper - default settings for data types - but just guidance on a tsql script to accomplish the same thing is sufficient and probably more efficient of framework developer time Smile

Replies
Greg McGuffey
Greg McGuffey
Strategic Support Team Member (4.8K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
I think Charles is wanting to write a sproc that would setup a bunch of columns to use the alternate null settings directly. I.e. rather than go into the BO Mapper and setup 100s of columns manually, just run a sproc to set them all at once by directly manipulating the meta data that SF stores in the db. Then he'd open the BO mapper, rebuild his partials.



So, if I'm correct, he's wanting to know were this meta data is stored within the SF database. Is that right Charles?
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
If that is the case, and I caution you on this as it can break a lot of stuff, but you will want to use the DTEProjects tables. Specifically you are wanting to create exceptions. Is this not something you can do through the Customization Wizard?
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