E9: Dashboard - Filter gridview when numeric field is null

I ended up adding another field from PORel to my BAQ so that if there
was no matching record in PORel, I would have two numeric fields that
are null or non-existent. Then from the dashboard, I created a filter
where the first field equaled the second field. Kind of a workaround but
it did the trick.



Thanks for the suggestions.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of robertb_versa@...
Sent: Friday, July 09, 2010 7:48 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] E9: Dashboard - Filter gridview when numeric
field is null





This would be a snap to do in SQL... The frustrating thing is Progress
query language is equally capable.

It's the 'dumbed down' BAQ editor that limits us. I would trade the
wizards in the BAQ editor for a simple text editor w/ full(er) Progress
query language support in a heartbeat.

Good luck with it.

Rob

--- Original Message ---
From:robertb_versa@... <mailto:robertb_versa%40yahoo.com>
Sent:Fri 7/9/10 7:40 pm
To:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Cc:
Subj:Re: [Vantage] E9: Dashboard - Filter gridview when numeric field is
null

Within the BAQ, try a criteria of including only POrel numbers less than
one.

I would think it would then just return Job subc OPs that have no linked
subc PO line release.

Null doesn't work because of your join type.

The values you seek aren't null value records - they are non-existent
records (which is different than Null).

Something along the lines I describe as a criteria (in the BAQ) should
work... Just hunt around and try it on different fields until one does.

Rob
--- Original Message ---
From:"Joe Rojas" <jrojas@... <mailto:jrojas%40matsinc.com> >
Sent:Fri 7/9/10 4:49 pm
To:<vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
Subj:[Vantage] E9: Dashboard - Filter gridview when numeric field is
null

Hi All,

I'm creating a dashboard to show job subcontract operations that do not
have an associated PO.

My BAQ has an outer join from JobProd to PORel. If there is no
associated PO, PORel.PONum is blank or null.

I wasn't able to limit the result of my BAQ to only return rows where
PORel.PONum is null, so I'm returning all open subcontract ops with the
hopes of filtering the gridview.

When I create a filter that PORel.PONum = Constant: NullValue , I get
the following error:

Error Detail

============

Invalid Filter: Alpha compare against Numeric Column: 'PORel.PONum =
Constant: NullValue'

How can create this filter if there is no numeric null constant???







Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
Hi All,



I'm creating a dashboard to show job subcontract operations that do not
have an associated PO.

My BAQ has an outer join from JobProd to PORel. If there is no
associated PO, PORel.PONum is blank or null.



I wasn't able to limit the result of my BAQ to only return rows where
PORel.PONum is null, so I'm returning all open subcontract ops with the
hopes of filtering the gridview.



When I create a filter that PORel.PONum = Constant: NullValue , I get
the following error:

Error Detail

============

Invalid Filter: Alpha compare against Numeric Column: 'PORel.PONum =
Constant: NullValue'



How can create this filter if there is no numeric null constant???










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
Within the BAQ, try a criteria of including only POrel numbers less than one.

I would think it would then just return Job subc OPs that have no linked subc PO line release.

Null doesn't work because of your join type.

The values you seek aren't null value records - they are non-existent records (which is different than Null).

Something along the lines I describe as a criteria (in the BAQ) should work... Just hunt around and try it on different fields until one does.

Rob
--- Original Message ---
From:"Joe Rojas" <jrojas@...>
Sent:Fri 7/9/10 4:49 pm
To:<vantage@yahoogroups.com>
Subj:[Vantage] E9: Dashboard - Filter gridview when numeric field is null

Hi All,



I'm creating a dashboard to show job subcontract operations that do not
have an associated PO.

My BAQ has an outer join from JobProd to PORel. If there is no
associated PO, PORel.PONum is blank or null.



I wasn't able to limit the result of my BAQ to only return rows where
PORel.PONum is null, so I'm returning all open subcontract ops with the
hopes of filtering the gridview.



When I create a filter that PORel.PONum = Constant: NullValue , I get
the following error:

Error Detail

============

Invalid Filter: Alpha compare against Numeric Column: 'PORel.PONum =
Constant: NullValue'



How can create this filter if there is no numeric null constant???










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
This would be a snap to do in SQL... The frustrating thing is Progress query language is equally capable.

It's the 'dumbed down' BAQ editor that limits us. I would trade the wizards in the BAQ editor for a simple text editor w/ full(er) Progress query language support in a heartbeat.

Good luck with it.

Rob

--- Original Message ---
From:robertb_versa@...
Sent:Fri 7/9/10 7:40 pm
To:vantage@yahoogroups.com
Cc:
Subj:Re: [Vantage] E9: Dashboard - Filter gridview when numeric field is null

Within the BAQ, try a criteria of including only POrel numbers less than one.

I would think it would then just return Job subc OPs that have no linked subc PO line release.

Null doesn't work because of your join type.

The values you seek aren't null value records - they are non-existent records (which is different than Null).

Something along the lines I describe as a criteria (in the BAQ) should work... Just hunt around and try it on different fields until one does.

Rob
--- Original Message ---
From:"Joe Rojas" <jrojas@...>
Sent:Fri 7/9/10 4:49 pm
To:<vantage@yahoogroups.com>
Subj:[Vantage] E9: Dashboard - Filter gridview when numeric field is null

Hi All,



I'm creating a dashboard to show job subcontract operations that do not
have an associated PO.

My BAQ has an outer join from JobProd to PORel. If there is no
associated PO, PORel.PONum is blank or null.



I wasn't able to limit the result of my BAQ to only return rows where
PORel.PONum is null, so I'm returning all open subcontract ops with the
hopes of filtering the gridview.



When I create a filter that PORel.PONum = Constant: NullValue , I get
the following error:

Error Detail

============

Invalid Filter: Alpha compare against Numeric Column: 'PORel.PONum =
Constant: NullValue'



How can create this filter if there is no numeric null constant???










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]