RE: collection.min() Returns Null

it never downloaded the message. Steve -Original Message- From: Cannon Smith [mailto:can...@synergyfarmsolutions.com] Sent: Friday, July 27, 2018 8:00 AM To: s.o...@the-aquila-group.com; 4D iNug Technical <4d_tech@lists.4d.com> Subject: Re: collection.min() Returns Null Hi Steve, FWI

Re: collection.min() Returns Null

Hi Steve, FWIW, I'm only getting one copy of each message. -- Cannon Smith > On Jul 27, 2018, at 5:51 AM, Stephen J. Orth via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > For the past few days I'm getting multiples of the same message, over and > over. Today I received like 15 copies of this

RE: collection.min() Returns Null

] On Behalf Of Cannon Smith via 4D_Tech Sent: Thursday, July 26, 2018 8:12 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Cannon Smith Subject: Re: collection.min() Returns Null Hi Miyako, Perfect! Thanks, that makes sense and works well. -- Cannon.Smith Synergy Farm Solutions Inc

Re: collection.min() Returns Null

Hi Miyako, Perfect! Thanks, that makes sense and works well. -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236 > On Jul 26, 2018, at 3:27 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > in your case, you could do something like > >

Re: collection.min() Returns Null

one thing to keep in mind is that this (rules on sorting) does not apply to count() or average() - count does NOT count null, object, collection the doc. says that the method only counts "non-null" values. non-null does not include object or collection - average() does not include null,

Re: collection.min() Returns Null

it is documented. min() http://doc.4d.com/4Dv17/4D/17/collectionmin.301-3730928.en.html says If the collection contains different types of values, the collection.min( ) method will return the minimum value within the first element type in the type list order (see collection.sort( )

Re: collection.min() Returns Null

query() is not the only member function to filter a collection. in your case, you could do something like $cTest:=$cTest..filter("remove_null") where the project method remove_null is C_OBJECT($1) $1.result:=($1.value#Null) 2018/07/27 5:09、Cannon Smith via 4D_Tech

Re: collection.min() Returns Null

Hi Christian, Thanks. The values are a series that need to be graphed. Some values in a series may be null, indicating that the graph line should be skipped at that point since we don’t know what the value is. That’s why I decided to use C_COLLECTION instead of ARRAY REAL to hold the values.

Re: collection.min() Returns Null

Yes, this is expected. You can only do a query() on a Collection with objects. Where do you get these values? You should select before to get only non-null values or remove them from the collection with a For/Each-Loop. -- Grüße/Regards, [heubach-media] | Christian Sakowski

Re: collection.min() Returns Null

As a follow up, I thought I would try to remove the null’s from the collection use collection.query(), but I don’t know what to use for the query string since there are no named object properties in the collection. $cTest:=New collection(100;200;Null;80)