Filter EpiCombo based off of User Code

Assume that myCombo is the name of your combobox:



In InitializeCustomCode method, add the line:

myCombo.BeforeDropDown += new
System.ComponentModel.CancelEventHandler(Script.myCombo_BeforeDropDown);



In the DestroyCustomCode method, add the line:

myCombo.BeforeDropDown -= new
System.ComponentModel.CancelEventHandler(Script.myCombo_BeforeDropDown);



Add the following method:



private static void myCombo_BeforeDropDown(object
sender, System.ComponentModel.CancelEventArgs args)

{

EpiCombo combo = (EpiCombo)sender;

DataTable dt =
(DataTable)combo.DataSource;

if (dt.ExtendedProperties["Modified"] !=
null)

return;

dt.ExtendedProperties["Modified"] =
true;

foreach (DataRow row in dt.Rows) {

if
(!(bool)row["IsActive"]) {


combo.Rows.ColumnFilters["CodeID"].FilterConditions.Add(Infragistics.Win\
.UltraWinGrid.FilterComparisionOperator.NotEquals, row["CodeID"]);

}

}

}


--- In vantage@yahoogroups.com, Joe Rojas <jrojas@...> wrote:
>
> Hello,
>
>
>
> I have an EpiCombo on my screen that is setup to pull a specific user
> code.
>
> We recently modified the code list and I marked some as inactive.
>
> I'd like to now go back and filter the inactive codes from the
EpiCombo
> but I just can't figure it out.
>
> I added UDCodes.IsActive = FALSE to the EpiFiltersAppend property but
it
> keeps telling me that IsActive must be a quoted constant of an
> unambiguous field in query qryUDCodes.
>
>
>
> Any ideas on how I do this?
>
>
>
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> 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]
>




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



I have an EpiCombo on my screen that is setup to pull a specific user
code.

We recently modified the code list and I marked some as inactive.

I'd like to now go back and filter the inactive codes from the EpiCombo
but I just can't figure it out.

I added UDCodes.IsActive = FALSE to the EpiFiltersAppend property but it
keeps telling me that IsActive must be a quoted constant of an
unambiguous field in query qryUDCodes.



Any ideas on how I do this?










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
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]
Try adding IsActive to the hiddencolumns of the EpiCombo. Sorry, I don't know the exact syntax off the top of my head.
Â


________________________________
From: Joe Rojas <jrojas@...>
To: vantage@yahoogroups.com
Sent: Tuesday, April 3, 2012 4:39 PM
Subject: [Vantage] Filter EpiCombo based off of User Code


Â
Hello,

I have an EpiCombo on my screen that is setup to pull a specific user
code.

We recently modified the code list and I marked some as inactive.

I'd like to now go back and filter the inactive codes from the EpiCombo
but I just can't figure it out.

I added UDCodes.IsActive = FALSE to the EpiFiltersAppend property but it
keeps telling me that IsActive must be a quoted constant of an
unambiguous field in query qryUDCodes.

Any ideas on how I do this?







Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
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]




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