web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Find DBNav customizati...
Microsoft Dynamics SL (Archived)

Find DBNav customization is using

(0) ShareShare
ReportReport
Posted on by Candice82 4

How do you find the DBNav that is being used by a customization? I have to add a radio button to filter the grid, but I need to know the DBNav the grid is using. I did a SQL trace, and it seems that the grid on the screen I am customizing (TM.TRA.00) uses several DIFFERENT DBNav's.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi

    Follow the below steps to get the dbnav value in customization

    1) Insert Command button in to that customization screen

    2) Under that Command button click event enter the below code

    Dim StrVal As String

    Call getprop("spread1", "DBNAV", StrVal)

    Call MessBox(StrVal, MB_ICONINFORMATION, "Test")

    3) Save the customization

    4) Close and open that screen and click that newly inserted button. This will provide you the DbNav value for that grid

    Note:

    1) Instead of inserting the command button, you can include the above code in  Form1_Display()  also.

    2) As per the standard all the Grid in that standard screen will be named as Spread1, Spread2 like that.

    Hope this helps

    Thanks & Regards

  • Candice82 Profile Picture
    Candice82 4 on at

    Spread1 is not the name of the control. I got a message saying that spread1 wasn't the correct name. I am trying to customize the Time Review and Approval Screen (TM.TRA.00) and I need to add another filter (by employee).

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Use the below code for that specified screen

    Dim StrVal As String

    Call getprop("ssHours_PWT", "DBNAV", StrVal)

    Call MessBox(StrVal, MB_ICONINFORMATION, "Test1")

    Hope this helps

    Thanks & Regards

  • Candice82 Profile Picture
    Candice82 4 on at

    Thanks! That Worked!

  • Community Member Profile Picture
    Community Member on at

    Always Welcome ....   Thanks for the confirmation..

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans