Question - How to use a BAQ to identify records with blank field

Yahoo Archive
1
Thank you everyone for your help! I was forgetting the outerjoin when I created the BAQ before.

It works great now.

Once again, thanks for everyones help.

Jason
2
We are in the process of creating a new database with clean information as we are now one company where as we were several operating together in the past.

We have reports created in Crystal which are run every morning for different purposes - To identify Parts with out MOMS , Parts without Customer Part Numbers etc.

These are currently run through ODBC and we are working to convert them to BAQS to attach them to an overnight schedule.

Does anyone know of a way to filter a BAQ looking for blank fields?

Example - All parts that do not have a corresponding Customer Part Number in our CustXPart Table

Any help would be greatly appreciated. :-)
3
Hi LakeIT,

You could use the criteria to filter out those fields with blank fields. Hope it can help you

Best Regards
Adrian

--- In vantage@yahoogroups.com, "LakeIT" <inthespot1@...> wrote:
>
> We are in the process of creating a new database with clean information as we are now one company where as we were several operating together in the past.
>
> We have reports created in Crystal which are run every morning for different purposes - To identify Parts with out MOMS , Parts without Customer Part Numbers etc.
>
> These are currently run through ODBC and we are working to convert them to BAQS to attach them to an overnight schedule.
>
> Does anyone know of a way to filter a BAQ looking for blank fields?
>
> Example - All parts that do not have a corresponding Customer Part Number in our CustXPart Table
>
> Any help would be greatly appreciated. :-)
>
4
Really? How do you do it? I tried and couldn't come up with a query.

You can't leave the criteria field blank, you can't use '' and you can't use ?.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of adriancctfssb
Sent: Thursday, March 18, 2010 3:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Question - How to use a BAQ to identify records with blank fields

Hi LakeIT,

You could use the criteria to filter out those fields with blank fields. Hope it can help you

Best Regards
Adrian

--- In vantage@yahoogroups.com, "LakeIT" <inthespot1@...> wrote:
>
> We are in the process of creating a new database with clean information as we are now one company where as we were several operating together in the past.
>
> We have reports created in Crystal which are run every morning for different purposes - To identify Parts with out MOMS , Parts without Customer Part Numbers etc.
>
> These are currently run through ODBC and we are working to convert them to BAQS to attach them to an overnight schedule.
>
> Does anyone know of a way to filter a BAQ looking for blank fields?
>
> Example - All parts that do not have a corresponding Customer Part Number in our CustXPart Table
>
> Any help would be greatly appreciated. :-)
>




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
5
On trick is to compare it to another field that you know will always be blank.




________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Thu, March 18, 2010 9:19:33 AM
Subject: RE: [Vantage] Re: Question - How to use a BAQ to identify records with blank fields

Â
Really? How do you do it? I tried and couldn't come up with a query.

You can't leave the criteria field blank, you can't use '' and you can't use ?.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of adriancctfssb
Sent: Thursday, March 18, 2010 3:44 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Re: Question - How to use a BAQ to identify records with blank fields

Hi LakeIT,

You could use the criteria to filter out those fields with blank fields. Hope it can help you

Best Regards
Adrian

--- In vantage@yahoogroups .com, "LakeIT" <inthespot1@ ...> wrote:
>
> We are in the process of creating a new database with clean information as we are now one company where as we were several operating together in the past.
>
> We have reports created in Crystal which are run every morning for different purposes - To identify Parts with out MOMS , Parts without Customer Part Numbers etc.
>
> These are currently run through ODBC and we are working to convert them to BAQS to attach them to an overnight schedule.
>
> Does anyone know of a way to filter a BAQ looking for blank fields?
>
> Example - All parts that do not have a corresponding Customer Part Number in our CustXPart Table
>
> Any help would be greatly appreciated. :-)
>

------------ --------- --------- ------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links







[Non-text portions of this message have been removed]
6
I tried comparing it to character10 in the same table which I know is blank and then I didnt get anything.

It should just be

FieldName(XPartNum) = (IsConst not checked) ToDataTableID(CustXPart)ToFieldName(Character10)

Correct?

--- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> On trick is to compare it to another field that you know will always be blank.
>
>
>
>
> ________________________________
> From: Brian W. Spolarich <bspolarich@...>
> To: vantage@yahoogroups.com
> Sent: Thu, March 18, 2010 9:19:33 AM
> Subject: RE: [Vantage] Re: Question - How to use a BAQ to identify records with blank fields
>
> ÂÂ
> Really? How do you do it? I tried and couldn't come up with a query.
>
> You can't leave the criteria field blank, you can't use '' and you can't use ?.
>
> -bws
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
>     bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com
>
> -----Original Message-----
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of adriancctfssb
> Sent: Thursday, March 18, 2010 3:44 AM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Re: Question - How to use a BAQ to identify records with blank fields
>
> Hi LakeIT,
>
> You could use the criteria to filter out those fields with blank fields. Hope it can help you
>
> Best Regards
> Adrian
>
> --- In vantage@yahoogroups .com, "LakeIT" <inthespot1@ ...> wrote:
> >
> > We are in the process of creating a new database with clean information as we are now one company where as we were several operating together in the past.
> >
> > We have reports created in Crystal which are run every morning for different purposes - To identify Parts with out MOMS , Parts without Customer Part Numbers etc.
> >
> > These are currently run through ODBC and we are working to convert them to BAQS to attach them to an overnight schedule.
> >
> > Does anyone know of a way to filter a BAQ looking for blank fields?
> >
> > Example - All parts that do not have a corresponding Customer Part Number in our CustXPart Table
> >
> > Any help would be greatly appreciated. :-)
> >
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/.
> (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
7
When I used Part.Character10, it worked. Try that. It might be getting confused by comparing fields from the same table. I also used CustXPart.PartNum to compare it to, but it should work no matter what field you use in the CustXPart table. Just remember to check the outer join in Phrase Builder/ Table Relations.

--- In vantage@yahoogroups.com, "LakeIT" <inthespot1@...> wrote:
>
> I tried comparing it to character10 in the same table which I know is blank and then I didnt get anything.
>
> It should just be
>
> FieldName(XPartNum) = (IsConst not checked) ToDataTableID(CustXPart)ToFieldName(Character10)
>
> Correct?
>
> --- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@> wrote:
> >
> > On trick is to compare it to another field that you know will always be blank.
> >
> >
> >
> >
> > ________________________________
> > From: Brian W. Spolarich <bspolarich@>
> > To: vantage@yahoogroups.com
> > Sent: Thu, March 18, 2010 9:19:33 AM
> > Subject: RE: [Vantage] Re: Question - How to use a BAQ to identify records with blank fields
> >
> > ÂÂ
> > Really? How do you do it? I tried and couldn't come up with a query.
> >
> > You can't leave the criteria field blank, you can't use '' and you can't use ?.
> >
> > -bws
> >
> > --
> > Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
> >     bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com
> >
> > -----Original Message-----
> > From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of adriancctfssb
> > Sent: Thursday, March 18, 2010 3:44 AM
> > To: vantage@yahoogroups .com
> > Subject: [Vantage] Re: Question - How to use a BAQ to identify records with blank fields
> >
> > Hi LakeIT,
> >
> > You could use the criteria to filter out those fields with blank fields. Hope it can help you
> >
> > Best Regards
> > Adrian
> >
> > --- In vantage@yahoogroups .com, "LakeIT" <inthespot1@ ...> wrote:
> > >
> > > We are in the process of creating a new database with clean information as we are now one company where as we were several operating together in the past.
> > >
> > > We have reports created in Crystal which are run every morning for different purposes - To identify Parts with out MOMS , Parts without Customer Part Numbers etc.
> > >
> > > These are currently run through ODBC and we are working to convert them to BAQS to attach them to an overnight schedule.
> > >
> > > Does anyone know of a way to filter a BAQ looking for blank fields?
> > >
> > > Example - All parts that do not have a corresponding Customer Part Number in our CustXPart Table
> > >
> > > Any help would be greatly appreciated. :-)
> > >
> >
> > ------------ --------- --------- ------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/.
> > (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> > (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>