I would like to paginate a list of information provided by a view. I use skip and take without forgetting to sort the list. For this I use Entity SQL.
The query is Entite SQL:
Code: Select all
Select VALUE s from EntitiesSTN.SocieteDso as s
ORDER BY s.RAISONSOCIALE ASC
Code: Select all
IQueryable listeSociete = null;
if (numLigneDebut == 0 & & numLigneFin> 0)
listeSociete = query.Take ((int) numLigneFin);
if (numLigneDebut> 0 & & numLigneFin> 0)
listeSociete = query.Skip ((int) numLigneDebut). Take ((int) numLigneFin);
Code: Select all
SELECT
"Project1".CODECLIENT AS CODECLIENT,
"Project1".CODECLIENTFONCTIONNEL AS CODECLIENTFONCTIONNEL,
"Project1".CODESTATISTIQUE1 AS CODESTATISTIQUE1,
"Project1".CODESTATISTIQUE2 AS CODESTATISTIQUE2,
"Project1".CODESTATISTIQUE3 AS CODESTATISTIQUE3,
"Project1".CODESTATISTIQUE4 AS CODESTATISTIQUE4,
"Project1".CODESTATISTIQUE5 AS CODESTATISTIQUE5,
"Project1".TYPESOCIETE AS TYPESOCIETE
FROM ( SELECT "Project1".CODECLIENT AS CODECLIENT, "Project1".CODECLIENTFONCTIONNEL AS CODECLIENTFONCTIONNEL, "Project1".CODESTATISTIQUE1 AS CODESTATISTIQUE1, "Project1".CODESTATISTIQUE2 AS CODESTATISTIQUE2, "Project1".CODESTATISTIQUE3 AS CODESTATISTIQUE3, "Project1".CODESTATISTIQUE4 AS CODESTATISTIQUE4, "Project1".CODESTATISTIQUE5 AS CODESTATISTIQUE5,"Project1".TYPESOCIETE AS TYPESOCIETE, row_number() OVER (ORDER BY ,"Project1".RAISONSOCIALE ASC) AS "row_number"
FROM ( SELECT
"Extent1".CODECLIENT AS CODECLIENT,
"Extent1".CODECLIENTFONCTIONNEL AS CODECLIENTFONCTIONNEL,
"Extent1".CODESTATISTIQUE1 AS CODESTATISTIQUE1,
"Extent1".CODESTATISTIQUE2 AS CODESTATISTIQUE2,
"Extent1".CODESTATISTIQUE3 AS CODESTATISTIQUE3,
"Extent1".CODESTATISTIQUE4 AS CODESTATISTIQUE4,
"Extent1".CODESTATISTIQUE5 AS CODESTATISTIQUE5,
"Extent1".TYPESOCIETE AS TYPESOCIETE
FROM (
SELECT
VUESOCIETESDSO.CODECLIENT AS CODECLIENT,
VUESOCIETESDSO.CODECLIENTFONCTIONNEL AS CODECLIENTFONCTIONNEL,
VUESOCIETESDSO.CODESTATISTIQUE1 AS CODESTATISTIQUE1,
VUESOCIETESDSO.CODESTATISTIQUE2 AS CODESTATISTIQUE2,
VUESOCIETESDSO.CODESTATISTIQUE3 AS CODESTATISTIQUE3,
VUESOCIETESDSO.CODESTATISTIQUE4 AS CODESTATISTIQUE4,
VUESOCIETESDSO.CODESTATISTIQUE5 AS CODESTATISTIQUE5,
VUESOCIETESDSO.TYPESOCIETE AS TYPESOCIETE
FROM STN_DEV_DBA.VUESOCIETESDSO VUESOCIETESDSO
) "Extent1"
WHERE ("Extent1".IDMEMBRE = :Param1) AND ("Extent1".TYPESOCIETE = :Param2)
) "Project1"
ORDER BY "Project1".RAISONSOCIALE ASC
) "Project1"
WHERE "Project1"."row_number" > 149 AND ROWNUM 149 AND ROWNUM <= (299)
it
row_number () OVER (ORDER BY ,"Project1". RAISONSOCIALE ASC) AS "row_number"
as if he missed a field
Someone Does he have any idea?
Thank you