| I don't think the API supports this function as it appears to be a vendor specific feature. There are two approaches and you can adapt whatever you like:
Approach 1: This will make 2 db calls at minimum and will have more memory consumption.
NSArray<MyTable> objects1 = // objects where myDate() is null; NSArray<MyTable> objects2 = // objects where myDate() is not null but sorted as you like... NSArray<MyTable> objects = // append objects1 and objects2
Approach 2: This will make 1 db call, uses less memory. It's quite simple and easy to understand. The whole idea is to push the nulls at the end with minimum instructions.
Case 1: descs() NSArray<MyTable> objects = // sorted objects either using descs() so nulls are already at the end so no worries
Case 2: ascs() NSArray<MyTable> objects = // sorted objects using ascs() so nulls are in the beginning MyTable object = objects.get(objects.count() / 2); // to check if the if(object.myDate() != null) { Enumeration<MyTable> e = objects.objectEnumerator(); while(e.hasMoreElements()) { object = e.nextElement(); if(object.myDate() != null) break; objects.remove(object); objects.add(object); } } else { Enumeration<MyTable> e = objects.reverseObjectEnumerator(); while(e.hasMoreElements()) { object = e.nextElement(); if(object.myDate() == null) break; objects.remove(object); objects.add(0, object); } }
// After the above code execution, the nulls are pushed to the end in minimum execution time.
Farrukh
On 2012-07-18, at 6:06 PM, ALEXANDRE Grégoire < email@hidden> wrote:
Yes but i need
MyTable.MY_DATE.descs() // will put nulls at the end
MyTable.MY_DATE.ascs() // will put nulls at the end
=> "nulls last" in sql and i used
ERXEOControlUtilities.ObjectInRange...
Le 18/07/12 16:14, Farrukh Ijaz a écrit :
Hi,
Should be something like:
MyTable.MY_DATE.descs() // will put nulls at the end
MyTable.MY_DATE.ascs() // will put nulls at the first
Farrukh
On 2012-07-18, at 2:02 PM, ALEXANDRE Grégoire < email@hidden>
wrote:
hi,
i need to create fecth specification with my null element at
the end of the response
for example i need tu create this;
select * from my_table order by my_date nulls first;
thanks for reply.
--
Grégoire ALEXANDRE
Développeur
GIP Sym@ris
Pavillon 1
27 rue du 4ème RSM B.P. 29
F-68250 ROUFFACH
tel : 0389787406
Courriel : email@hidden
Web : http://www.symaris.com
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
--
Grégoire ALEXANDRE
Développeur
GIP Sym@ris
Pavillon 1
27 rue du 4ème RSM B.P. 29
F-68250 ROUFFACH
tel : 0389787406
Courriel : email@hidden
Web : http://www.symaris.com
|