ComboBox Search Filter

thanks Joshua

What i used in the end is generating from the wizard a simple search
attached to a combobox and then modified the whereClause to mattch what i
need.

Thanks for the help



On Tue, Aug 6, 2013 at 3:27 PM, Joshua Giese <jgiese@...
> wrote:

> **
>
>
> I was mistaken I thought I used BOReader for this but I didn't. The idea
> would be exactly the same except instead of using a list as the datasource
> you would use the returned data from BOReader. None of the delegate inits
> are in here, but hopefully you have a handle on that. Anything you need to
> know about how to use BOReader will already be online here.
>
> private void cboDown1_ValueChanged(object sender, System.EventArgs
> args)
> {
> try
> {
> string value =
> ((EpiCombo)sender).Value.ToString();
> if (value != "")
> {
> UpdateCboDown2(value);
> }
> }
> catch
> {
> //
> }
> }
>
> private void UpdateCboDown2(string value)
> {
> //MessageBox.Show(value);
> List<string> list = new List<string>();
> cboDown2.Text = "";
> switch(value)
> {
> case "Art":
> list.Add("Adjust Registration");
> list.Add("Toning Ink");
> cboDown2.DataSource = list;
> cboDown2.Enabled = true;
> break;
>
> case "Maintenance":
> list.Add("Jam-up");
> list.Add("Paper Break");
> list.Add("Glue +/-");
> list.Add("Cutoff Issue");
> cboDown2.DataSource = list;
> cboDown2.Enabled = true;
> break;
>
> default:
> cboDown2.DataSource = list;
> cboDown2.Enabled = false;
> break;
>
> }
> }
>
> Joshua Giese
>
> CTO
>
> 920.437.6400 Ext. 337
>
> Site ID: 27450-E905700B2-SQL64
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Ephraim Feldman
> Sent: Tuesday, August 6, 2013 12:09 PM
> To: Vantage Yahoo Group
> Subject: Re: [Vantage] ComboBox Search Filter
>
> Joshua
>
> Thanks for the response
>
> Would you mind to elaborate a bit on how you did it and maybe give me a
> example of the code
>
> I will really appreciate that
>
> Ephraim
>
> On Tue, Aug 6, 2013 at 11:26 AM, Joshua Giese <
> jgiese@...> wrote:
>
> > **
>
> >
> >
> > I used a BOReader on value change and EpiUltraCombo got the data back
> > from the BOReader and set it as the datasource of the second combo
> >
> > Joshua Giese
> >
> > CTO
> >
> > 920.437.6400 Ext. 337
> >
> > Site ID: 27450-E905700B2-SQL64
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of Ephraim Feldman
> > Sent: Tuesday, August 6, 2013 9:06 AM
> > To: Vantage Yahoo Group
> > Subject: Re: [Vantage] ComboBox Search Filter
> >
> > Hi Karen
> >
> > I reviewed that Answerbook already a while back but it only gives a
> > example with a hardcoded search as in "CustNum = 31" but not a dynamic
> > one based on a value in your form
> >
> > I need to filter based on the customer value in the order entry form
> >
> > Ephraim
> >
> > On Tue, Aug 6, 2013 at 9:36 AM, Karen Schoenung <
> > kschoenung@...> wrote:
> >
> > > **
> >
> > >
> > >
> > > 4492ESC is from EpicWeb and shows an example...There probably is
> > > something in the tools book too (ICE).
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of Ephraim Feldman
> > > Sent: Tuesday, August 06, 2013 8:26 AM
> > > To: Vantage Yahoo Group
> > > Subject: [Vantage] ComboBox Search Filter
> > >
> > >
> > > Hi All
> > >
> > > I am trying to crate a ComboBox that will show a filtered list based
> > > on another value on the screen but no success
> > >
> > > I want to get something like the contact combo on the order entry
> > > that shows all contacts based on the customer selected .
> > > I tied putting in the SearchValue property CustNum =
> > > OrderHed.CustNum but i am getting a error "invalid query" when i try
> to retrieve data.
> > >
> > > Maybe there is a other way to achive that?
> > >
> > > thanks
> > >
> > > Ephraim
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> > ------------------------------------
> >
> >
> > 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]
>
> ------------------------------------
>
> 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]
Hi All

I am trying to crate a ComboBox that will show a filtered list based on
another value on the screen but no success

I want to get something like the contact combo on the order entry that
shows all contacts based on the customer selected .
I tied putting in the SearchValue property CustNum = OrderHed.CustNum but i
am getting a error "invalid query" when i try to retrieve data.

Maybe there is a other way to achive that?

thanks

Ephraim


[Non-text portions of this message have been removed]
4492ESC is from EpicWeb and shows an example...There probably is something in the tools book too (ICE).

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ephraim Feldman
Sent: Tuesday, August 06, 2013 8:26 AM
To: Vantage Yahoo Group
Subject: [Vantage] ComboBox Search Filter



Hi All

I am trying to crate a ComboBox that will show a filtered list based on
another value on the screen but no success

I want to get something like the contact combo on the order entry that
shows all contacts based on the customer selected .
I tied putting in the SearchValue property CustNum = OrderHed.CustNum but i
am getting a error "invalid query" when i try to retrieve data.

Maybe there is a other way to achive that?

thanks

Ephraim

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



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

I reviewed that Answerbook already a while back but it only gives a example
with a hardcoded search as in "CustNum = 31" but not a dynamic one based on
a value in your form

I need to filter based on the customer value in the order entry form

Ephraim


On Tue, Aug 6, 2013 at 9:36 AM, Karen Schoenung <
kschoenung@...> wrote:

> **
>
>
> 4492ESC is from EpicWeb and shows an example...There probably is something
> in the tools book too (ICE).
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Ephraim Feldman
> Sent: Tuesday, August 06, 2013 8:26 AM
> To: Vantage Yahoo Group
> Subject: [Vantage] ComboBox Search Filter
>
>
> Hi All
>
> I am trying to crate a ComboBox that will show a filtered list based on
> another value on the screen but no success
>
> I want to get something like the contact combo on the order entry that
> shows all contacts based on the customer selected .
> I tied putting in the SearchValue property CustNum = OrderHed.CustNum but i
> am getting a error "invalid query" when i try to retrieve data.
>
> Maybe there is a other way to achive that?
>
> thanks
>
> Ephraim
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
I used a BOReader on value change and EpiUltraCombo got the data back
from the BOReader and set it as the datasource of the second combo

Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ephraim Feldman
Sent: Tuesday, August 6, 2013 9:06 AM
To: Vantage Yahoo Group
Subject: Re: [Vantage] ComboBox Search Filter

Hi Karen

I reviewed that Answerbook already a while back but it only gives a
example with a hardcoded search as in "CustNum = 31" but not a dynamic one
based on a value in your form

I need to filter based on the customer value in the order entry form

Ephraim


On Tue, Aug 6, 2013 at 9:36 AM, Karen Schoenung <
kschoenung@...> wrote:

> **
>
>
> 4492ESC is from EpicWeb and shows an example...There probably is
> something in the tools book too (ICE).
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Ephraim Feldman
> Sent: Tuesday, August 06, 2013 8:26 AM
> To: Vantage Yahoo Group
> Subject: [Vantage] ComboBox Search Filter
>
>
> Hi All
>
> I am trying to crate a ComboBox that will show a filtered list based
> on another value on the screen but no success
>
> I want to get something like the contact combo on the order entry that
> shows all contacts based on the customer selected .
> I tied putting in the SearchValue property CustNum = OrderHed.CustNum
> but i am getting a error "invalid query" when i try to retrieve data.
>
> Maybe there is a other way to achive that?
>
> thanks
>
> Ephraim
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>


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



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

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
Joshua

Thanks for the response

Would you mind to elaborate a bit on how you did it and maybe give me a
example of the code

I will really appreciate that

Ephraim




On Tue, Aug 6, 2013 at 11:26 AM, Joshua Giese <
jgiese@...> wrote:

> **
>
>
> I used a BOReader on value change and EpiUltraCombo got the data back
> from the BOReader and set it as the datasource of the second combo
>
> Joshua Giese
>
> CTO
>
> 920.437.6400 Ext. 337
>
> Site ID: 27450-E905700B2-SQL64
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Ephraim Feldman
> Sent: Tuesday, August 6, 2013 9:06 AM
> To: Vantage Yahoo Group
> Subject: Re: [Vantage] ComboBox Search Filter
>
> Hi Karen
>
> I reviewed that Answerbook already a while back but it only gives a
> example with a hardcoded search as in "CustNum = 31" but not a dynamic one
> based on a value in your form
>
> I need to filter based on the customer value in the order entry form
>
> Ephraim
>
> On Tue, Aug 6, 2013 at 9:36 AM, Karen Schoenung <
> kschoenung@...> wrote:
>
> > **
>
> >
> >
> > 4492ESC is from EpicWeb and shows an example...There probably is
> > something in the tools book too (ICE).
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of Ephraim Feldman
> > Sent: Tuesday, August 06, 2013 8:26 AM
> > To: Vantage Yahoo Group
> > Subject: [Vantage] ComboBox Search Filter
> >
> >
> > Hi All
> >
> > I am trying to crate a ComboBox that will show a filtered list based
> > on another value on the screen but no success
> >
> > I want to get something like the contact combo on the order entry that
> > shows all contacts based on the customer selected .
> > I tied putting in the SearchValue property CustNum = OrderHed.CustNum
> > but i am getting a error "invalid query" when i try to retrieve data.
> >
> > Maybe there is a other way to achive that?
> >
> > thanks
> >
> > Ephraim
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
>
> 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]
I was mistaken I thought I used BOReader for this but I didn't. The idea
would be exactly the same except instead of using a list as the datasource
you would use the returned data from BOReader. None of the delegate inits
are in here, but hopefully you have a handle on that. Anything you need to
know about how to use BOReader will already be online here.

private void cboDown1_ValueChanged(object sender, System.EventArgs
args)
{
try
{
string value =
((EpiCombo)sender).Value.ToString();
if (value != "")
{
UpdateCboDown2(value);
}
}
catch
{
//
}
}

private void UpdateCboDown2(string value)
{
//MessageBox.Show(value);
List<string> list = new List<string>();
cboDown2.Text = "";
switch(value)
{
case "Art":
list.Add("Adjust Registration");
list.Add("Toning Ink");
cboDown2.DataSource = list;
cboDown2.Enabled = true;
break;

case "Maintenance":
list.Add("Jam-up");
list.Add("Paper Break");
list.Add("Glue +/-");
list.Add("Cutoff Issue");
cboDown2.DataSource = list;
cboDown2.Enabled = true;
break;

default:
cboDown2.DataSource = list;
cboDown2.Enabled = false;
break;
}
}

Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ephraim Feldman
Sent: Tuesday, August 6, 2013 12:09 PM
To: Vantage Yahoo Group
Subject: Re: [Vantage] ComboBox Search Filter

Joshua

Thanks for the response

Would you mind to elaborate a bit on how you did it and maybe give me a
example of the code

I will really appreciate that

Ephraim




On Tue, Aug 6, 2013 at 11:26 AM, Joshua Giese <
jgiese@...> wrote:

> **
>
>
> I used a BOReader on value change and EpiUltraCombo got the data back
> from the BOReader and set it as the datasource of the second combo
>
> Joshua Giese
>
> CTO
>
> 920.437.6400 Ext. 337
>
> Site ID: 27450-E905700B2-SQL64
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Ephraim Feldman
> Sent: Tuesday, August 6, 2013 9:06 AM
> To: Vantage Yahoo Group
> Subject: Re: [Vantage] ComboBox Search Filter
>
> Hi Karen
>
> I reviewed that Answerbook already a while back but it only gives a
> example with a hardcoded search as in "CustNum = 31" but not a dynamic
> one based on a value in your form
>
> I need to filter based on the customer value in the order entry form
>
> Ephraim
>
> On Tue, Aug 6, 2013 at 9:36 AM, Karen Schoenung <
> kschoenung@...> wrote:
>
> > **
>
> >
> >
> > 4492ESC is from EpicWeb and shows an example...There probably is
> > something in the tools book too (ICE).
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of Ephraim Feldman
> > Sent: Tuesday, August 06, 2013 8:26 AM
> > To: Vantage Yahoo Group
> > Subject: [Vantage] ComboBox Search Filter
> >
> >
> > Hi All
> >
> > I am trying to crate a ComboBox that will show a filtered list based
> > on another value on the screen but no success
> >
> > I want to get something like the contact combo on the order entry
> > that shows all contacts based on the customer selected .
> > I tied putting in the SearchValue property CustNum =
> > OrderHed.CustNum but i am getting a error "invalid query" when i try
to retrieve data.
> >
> > Maybe there is a other way to achive that?
> >
> > thanks
> >
> > Ephraim
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
>
> 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]



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

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