Hello all,
I have to create a view on Sql server managment studio,where i have to insert 4 fields fromTaxGroupData table,but one of them is a display method( TaxGroupName()).
Does anyone knows how to add this display method on views that are created direct from SQL server managment studio?
Thank you in advance!
*This post is locked for comments
I don't know what you mean by "them" in "if we create them from AX", but there is a huge difference in accessing AX database directly instead of going through the application layer. You must open up the database, you bypass AX security, you bypass caching, you can't utilize AX business logic (that's what this thread is about), you must deal manually with things like partitions, data areas, table inheritance and so on and so on.
Yeah i know but in this case the requirement was to access direct the database. Isn't the same thing if we create them from AX?
Display methods don't exist in database; you would have to redesign the logic. In this case, you can simply join TaxTable and take TaxName from there.
But may I ask you what you're trying to achieve? You shouldn't access AX database directly...
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (