Fetching selective Fields from TypedView

Posts   
 
    
Posts: 10
Joined: 11-Dec-2008
# Posted on: 23-Dec-2008 18:47:44   

(First of all, please accept my appologies, if I am asking in wrong section because I couldn't find the appropriate section)

I am using LLBLGen Pro 2.6 and I want to fetch few fields from a TypedView. Suppose my TypedView contains the fields CustomerID, FirstName, LastName, HouseNo, Street, PostCode, City, Salary and so on.

But I only want to fetch CustomerID, FirstName and LastName. How to do it? I tried my best to find a solution, but couldn't succeed. (I am using SelfService)

magic
User
Posts: 125
Joined: 24-Nov-2008
# Posted on: 23-Dec-2008 19:20:31   

softsurgeon wrote:

(First of all, please accept my appologies, if I am asking in wrong section because I couldn't find the appropriate section)

I am using LLBLGen Pro 2.6 and I want to fetch few fields from a TypedView. Suppose my TypedView contains the fields CustomerID, FirstName, LastName, HouseNo, Street, PostCode, City, Salary and so on.

But I only want to fetch CustomerID, FirstName and LastName. How to do it? I tried my best to find a solution, but couldn't succeed. (I am using SelfService)

why is it important to fetch just the selected fields? Isn't it ok, to fetch all fields of the needed rows and then just use the ones that are of interest?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 24-Dec-2008 06:40:31   

softsurgeon wrote:

(First of all, please accept my appologies, if I am asking in wrong section because I couldn't find the appropriate section)

I am using LLBLGen Pro 2.6 and I want to fetch few fields from a TypedView. Suppose my TypedView contains the fields CustomerID, FirstName, LastName, HouseNo, Street, PostCode, City, Salary and so on.

But I only want to fetch CustomerID, FirstName and LastName. How to do it? I tried my best to find a solution, but couldn't succeed. (I am using SelfService)

That's supported for entity fetches (see this). However not supported for typedview/typedlist. My advise, if you really want this, is to create your own view with the subset of fields you want.

David Elizondo | LLBLGen Support Team