Hi,
Am trying to retrieve complete set of results from the TR_SECTION table using GetLocalData. However this method requires a Retrieval Column to filter the results. However I want all the results. Any suggestions on the best way to do this?
Thanks
Well, if you're using a view to filter the table before presenting it to GetLocalData (as you should, in my opinion) then you could just add a dummy column to the view, e.g. "1 as filter_col" and then just pass in the default value as your filter. I guess I've never hit that as all my views wound up with Business Unit in them, and I've always used that as a default.
Yeah it works if I access the data via view.