Can someone help me in filtering so that I only have records that are
blank.
My Scenario: I have a questionnaire that has the eligibility section and
the Behavioral questionnaire. To reach the Behavioral questionnaire, a
participant has to pass the eligibility, otherwise they are screened out
and all the values in the Behavioral are null. One of the variables am
using for filtering is the SiteNo. Therefore if I want to get all the
ineligible participants, I create a filter to display records where
"SiteNo Equals Null".
My problem is: how do i represent 'null'? coz writing null results in a
reload of the page (Aggregate server)
Filters also allow you to define what rows you want to Hide.
Change the 'Display' 'Rows' to 'Hide' 'Rows' and enter a constraint like:
'SiteNo' '>' 0
(assuming all your sites have positive site numbers).
Typing in 'null' undoubtedly tried to do a string comparison with your
presumably numeric field, causing the failure/refresh.
Mitch
···
On Wed, Sep 12, 2012 at 6:11 AM, Daniel wrote:
Hi all,
Can someone help me in filtering so that I only have records that are
blank.
My Scenario: I have a questionnaire that has the eligibility section and
the Behavioral questionnaire. To reach the Behavioral questionnaire, a
participant has to pass the eligibility, otherwise they are screened out
and all the values in the Behavioral are null. One of the variables am
using for filtering is the SiteNo. Therefore if I want to get all the
ineligible participants, I create a filter to display records where
"SiteNo Equals Null".
My problem is: how do i represent 'null'? coz writing null results in a
reload of the page (Aggregate server)
···
On Wednesday, September 12, 2012 11:09:25 PM UTC+3, Mitch wrote:
>
> Filters also allow you to define what rows you want to Hide.
>
> Change the 'Display' 'Rows' to 'Hide' 'Rows' and enter a constraint like:
>
> 'SiteNo' '>' 0
>
> (assuming all your sites have positive site numbers).
>
> Typing in 'null' undoubtedly tried to do a string comparison with your
> presumably numeric field, causing the failure/refresh.
>
> Mitch
>
> On Wed, Sep 12, 2012 at 6:11 AM, Daniel <mfe...@gmail.com >wrote:
>
>> Hi all,
>>
>> Can someone help me in filtering so that I only have records that are
>> blank.
>> My Scenario: I have a questionnaire that has the eligibility section and
>> the Behavioral questionnaire. To reach the Behavioral questionnaire, a
>> participant has to pass the eligibility, otherwise they are screened out
>> and all the values in the Behavioral are null. One of the variables am
>> using for filtering is the SiteNo. Therefore if I want to get all the
>> ineligible participants, I create a filter to display records where
>> "SiteNo Equals Null".
>>
>> My problem is: how do i represent 'null'? coz writing null results in a
>> reload of the page (Aggregate server)
>>
>> Thanks
>> Daniel
>>
>> --
>> Post: opend...@googlegroups.com
>> Unsubscribe: opendatakit...@googlegroups.com
>> Options: http://groups.google.com/group/opendatakit?hl=en
>>
>
>
>
> --
> Mitch Sundt
> Software Engineer
> University of Washington
> mitche...@gmail.com
>
Can someone help me in filtering so that I only have records that are
blank.
My Scenario: I have a questionnaire that has the eligibility section and
the Behavioral questionnaire. To reach the Behavioral questionnaire, a
participant has to pass the eligibility, otherwise they are screened out
and all the values in the Behavioral are null. One of the variables am
using for filtering is the SiteNo. Therefore if I want to get all the
ineligible participants, I create a filter to display records where
"SiteNo Equals Null".
My problem is: how do i represent 'null'? coz writing null results in a
reload of the page (Aggregate server)
Yes, SiteNo is an integer value between 1 and 10. I have sent you the form
···
On Thursday, September 13, 2012 7:11:16 PM UTC+3, Mitch wrote:
>
> Is SiteNo an integer value? Can you send me the form? (
> mitche...@gmail.com ).
>
> On Thu, Sep 13, 2012 at 12:11 AM, Daniel <mfe...@gmail.com >wrote:
>
>> Thanks Mitch,
>>
>> That does not seem to work as sites >=1 are still returned. I have
>> attached a log for that.
>> My sites are 1 to 10.
>>
>>
>> On Wednesday, September 12, 2012 11:09:25 PM UTC+3, Mitch wrote:
>>
>>> Filters also allow you to define what rows you want to Hide.
>>>
>>> Change the 'Display' 'Rows' to 'Hide' 'Rows' and enter a constraint like:
>>>
>>> 'SiteNo' '>' 0
>>>
>>> (assuming all your sites have positive site numbers).
>>>
>>> Typing in 'null' undoubtedly tried to do a string comparison with your
>>> presumably numeric field, causing the failure/refresh.
>>>
>>> Mitch
>>>
>>> On Wed, Sep 12, 2012 at 6:11 AM, Daniel wrote:
>>>
>>>> Hi all,
>>>>
>>>> Can someone help me in filtering so that I only have records that are
>>>> blank.
>>>> My Scenario: I have a questionnaire that has the eligibility section
>>>> and the Behavioral questionnaire. To reach the Behavioral questionnaire, a
>>>> participant has to pass the eligibility, otherwise they are screened out
>>>> and all the values in the Behavioral are null. One of the variables am
>>>> using for filtering is the SiteNo. Therefore if I want to get all the
>>>> ineligible participants, I create a filter to display records where
>>>> "SiteNo Equals Null".
>>>>
>>>> My problem is: how do i represent 'null'? coz writing null results in a
>>>> reload of the page (Aggregate server)
>>>>
>>>> Thanks
>>>> Daniel
>>>>
>>>> --
>>>> Post: opend...@googlegroups.com
>>>> Unsubscribe: opendatakit...@**googlegroups.com
>>>> Options: http://groups.google.com/**group/opendatakit?hl=en
>>>>
>>>
>>>
>>>
>>> --
>>> Mitch Sundt
>>> Software Engineer
>>> University of Washington
>>> mitche...@gmail.com
>>>
>> --
>> Post: opend...@googlegroups.com
>> Unsubscribe: opendatakit...@googlegroups.com
>> Options: http://groups.google.com/group/opendatakit?hl=en
>>
>
>
>
> --
> Mitch Sundt
> Software Engineer
> University of Washington
> mitche...@gmail.com
>