Open Forum

Expand all | Collapse all

NAV Programming newbie - flow fields in SQL views

  • 1.  NAV Programming newbie - flow fields in SQL views

    GOLD CONTRIBUTOR
    Posted 08-09-2018 01:31 PM
    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"?

    Thanks,
    Debbie

    ------------------------------
    Debbie Danner Greene
    Senior Analyst
    Samaritan's Purse
    Boone NC
    ------------------------------


  • 2.  RE: NAV Programming newbie - flow fields in SQL views

    Posted 08-10-2018 03:41 AM
    If it's pulling in to SQL from the table as a '1' or '0' then a CASE When Statement should work

    ------------------------------
    Raul Martinez
    National Raisin Company
    Fowler CA
    ------------------------------



  • 3.  RE: NAV Programming newbie - flow fields in SQL views

    Posted 08-10-2018 05:54 AM

    Hi Debbie,

    I did a Webinar on this topic for NAV Skills here:

    C/SIDE Development 101 #5 - Field - keys, SIFT and more

    YouTube remove preview
    C/SIDE Development 101 #5 - Field - keys, SIFT and more
    In this session David Singleton explains Fields, Keys and SIFT for Microsoft Dynamics NAV
    View this on YouTube >

    Also in October I will be covering this in my presentation

    APP84 - Understanding Dynamics NAV on SQL

    Thursday, October 18

    8:30 AM - 9:30 AM

    I hope to see you there.



    ------------------------------
    David Singleton
    Go Live International
    SQL Perform Navision Performance Consultant
    dsingleton@go-live.us
    ------------------------------