GP Extender Views are populated with bad records - why?

(0) Share

Report

Posted on by Community Member Microsoft Employee

We are using a few extender views in GP for additional data that we need to use. However, I have noticed that some records in the view don't get loaded in a query but they are there on the Extender window! So I did a query of all records in the view (select * from this_view), I see records with nulls, and fields with spaces. Our developer said that they opened a ticket with MS but MS says that shouldn't happen in GP! But I see that garbage data in the select * query.

Does anyone out there experience this?

Thanks in advance.

*This post is locked for comments

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: GP Extender Views are populated with bad records - why?

Victoria, thank you. We will look at the design of the view.
Verified answer

Victoria Yudin 22,766 on at

Like (0)

Report

RE: GP Extender Views are populated with bad records - why?

GP (and Extender) tables will not store data as nulls (by design), however, the design of your Extender view may be causing this. For example, if your view is combining data from 2 Extender windows or from an Extender window and a GP table, you might get null results. I would start by examining the code of your view.