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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

X++ Computed View AX 2012

(0) ShareShare
ReportReport
Posted on by

This is my very first computed View Method, and was wondering if someone would tell me if I am going in the correct direction.  

The View name is ccv_HierarchyTreeTable (which uses the table - HierarchyTreeTable.).  I am using the two fields [Path] and [Element Number].  I am using the computed field as a sort field, so I can get the data in the correct order for a grid view in a form.

It returns two different strings depending on if Path is blank or not (am I using the correct/best way of checking for a blank string?)

If I followed the example I took this from, I should have:  public static server str cc_SortNode() -- why would it have server in that line?  

Anyway - following is my code.  Does it look correct?  Anything else I need to know?

_________________

public static str cc_SortNode()

{

 #define.ViewName(ccv_HierarchyTreeTable)

 #define.DataSourceName("HierarchyTreeTable_1")

 #define.FieldPath("Path")

 #define.FieldElement("ElementNumber")

 str sReturn,

     sPath,

     sElementNumber;

 DictView dictView2;

 dictView2 = new DictView(tableNum(#ViewName));

 sPath = dictView2.computedColumnString

     (#DataSourceName,

      #FieldPath,

      FieldNameGenerationMode::FieldList,

      true);

 sElementNumber = dictView2.computedColumnString

     (#DataSourceName,

      #FieldElementNumber,

      FieldNameGenerationMode::FieldList,

      true);

  if (spath == "")

  {

    sReturn = sElementNumber + "!" + sElementNumber;

  }

  else

  {

    sReturn = sPath + sElementNumber;

  {

  return sReturn;

}

*This post is locked for comments

  • Suggested answer
    dolee Profile Picture
    11,279 on at

    Hi,

    What you are returning in this method should be a partial TSQL statement . The condition logic is to be included in it.

    In your case, that would mean you should look to return something like:

    CASE

     WHEN yourTable.[Path] = '' THEN yourTable.[Element Number] + '!' + yourTable.[Element Number]

     ELSE yourTable.[Path] + yourTable.[Element Number]

    END AS [My Field Name]

  • Community Member Profile Picture
    on at

    sReturn = strFmt("CASE " + "WHEN %1 = '' THEN %2 + '!' + %2 ELSE %1 + %2 END", sPath, sElementNumber);

    So - that was helpful.  I changed my if statement to this, and now it compiles and works.

    BUT!!! - I don't understand this CASE statement.  This isn't standard X++ case statement is it?  Is this more of an SQL case statement?  Where would I go look this up so I can better understand what I am doing!  Thanks

  • Verified answer
    dolee Profile Picture
    11,279 on at

    Yes, it is a TSQL statement syntax.

    What happen is the view in AOT is translated into SQL statements when synchronizing with database.

    When you have a computed column, the string returned by the view method is injected into the TSQL statement directly as a column definition.

    E.g.

    CREATE VIEW [dbo].[YourView] AS

    SELECT col1, col2, col3, <view method return value>

    FROM yourTable

    WHERE ....

    GO

  • dolee Profile Picture
    11,279 on at

    Forgot to mention, so you just need to lookup TSQL CASE statement for more information.

    msdn.microsoft.com/.../ms181765.aspx

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Prashant Singh Profile Picture

Prashant Singh 2

#1
nmaenpaa Profile Picture

nmaenpaa 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans