How can i read FlowField values from SQL Database.

SHIV_DYNSHIV_DYN Member Posts: 30
edited 2010-06-01 in NAV Three Tier
Hi everyone,
Could anyone tell me
How can i read FlowField values from SQL Database ?
Ex: We are working on Reporting services, for that we need to retrive data for XXX table which has some flowFields.
normal fields i can able to retrive but FlowFields not able to retrive.
Thanks & Regards,


  • rdebathrdebath Member Posts: 383
    If you're on 5sp1 or later the flowfields are stored in indexed views, pretty easy to read. If you're using standard version SQL you have to add the NOEXPAND hint, if you're using Enterprise version SQL it will use the indexed views automatically if they look like a good idea.

    For earlier versions you can look at the tables in the database with $12345$5 like names. But that's usually far too much of a hassle to be worthwhile. They're kept up to date by a trigger on the table.
  • dbabasdbabas Member Posts: 32
    For versions before 5sp1, the easiest way for me is to use a subquery for each flowfield you need. It's very easy if you know T-SQL and look the definition of the flowfield.
  • strykstryk Member Posts: 645

    maybe this could help you to generate the FlowField-"SubQueries":
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
Sign In or Register to comment.