Adding a flow field from one view to another view

dgreene1051dgreene1051 Member Posts: 3
I need to add the assembly BOM field from the Item card in a view. This is a flow field. I have a view that is pulling the fields from the BOM component table in NAV . And I have a separate view that is pulling the fields from the item table (27). The Assembly BOM field as a flow field on the item card is a Boolean type. What will be the SQL statement that I need to add the Assembly BOM field to my Item view so that the Assembly BOM field will show up as "yes" or "no"?

Answers

  • dgreene1051dgreene1051 Member Posts: 3
    I think I need to use the SIFT in my statement for the flow field. What would be the statement that I would use? From a NAV programmer newbie just learning SQL.
  • Slawek_GuzekSlawek_Guzek Member Posts: 1,690
    SELECT Item.*, 
      IIF([Parent Item No_] IS NULL, 'No', 'Yes') [Assembly BOM] 
    FROM [Company$Item] Item
    LEFT OUTER JOIN [Company$BOM Component] ON [Parent Item No_] = Item.[No_]
    
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
Sign In or Register to comment.