Sort and Prefetch on child entity and mapped field

Posts   
 
    
Ammit
User
Posts: 59
Joined: 19-May-2006
# Posted on: 22-Mar-2007 23:31:21   

HI, i have an entity which has mapped fields from other entity.. so can I sort on those mapped fields? how? i tried doing that but it throws some XXX field is not a valid value for the EntityXFieldIndex.

when i do the paging with prefetch path then what happens to the mapped fields?

i am on 2.0 version... if i do the pagning with prefetch path then how is it going to impact the performance? previously it used to create temo table idex and bunch of other stuffs...which made it little slower and heavy... are you still handling it the same way in LLBL2.0?

-Ammit

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 23-Mar-2007 08:17:34   

Are you doing client side ot server side sorting? Have you read the following thread? http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=9194

Ammit
User
Posts: 59
Joined: 19-May-2006
# Posted on: 23-Mar-2007 22:38:20   

Walaa wrote:

Are you doing client side ot server side sorting? Have you read the following thread? http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=9194

server side paging..

thanx for that thread link that helped...

it will be great if you can answer other concerns as well.,...

aprat from that i am really interested in knowing folowing.. if i have an entity calles employee and a child entity called accountifo

i have mapped one of the fields on account info to the employee entity...

not can i do the sorting on that entity? [ the mapped one?]

Ammit
User
Posts: 59
Joined: 19-May-2006
# Posted on: 23-Mar-2007 23:01:13   

Ammit wrote:

Walaa wrote:

Are you doing client side ot server side sorting? Have you read the following thread? http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=9194

server side paging..

thanx for that thread link that helped...

it will be great if you can answer other concerns as well.,...

aprat from that i am really interested in knowing folowing.. if i have an entity calles employee and a child entity called accountifo

i have mapped one of the fields on account info to the employee entity...

not can i do the sorting on that entity? [ the mapped one?]

i am using following feature in the UI for LLBL Fields mapped on related fields sub tab

to map the field... andi want to sort onthis mapped field..

bclubb
User
Posts: 934
Joined: 12-Feb-2004
# Posted on: 24-Mar-2007 00:51:56   

These posts should help.

Check this one and see if it helps before jumping to the other thread. http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=8363&HighLight=1

http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=9288&HighLight=1