Hi

I am having requirement where i need to restrict account lookup on add assocation form so that i need to return only broker type of accounts for one condition and all accounts for another condition

So i have written my code below

(if (my conition succeded))

{

luToIDText.LookupPreFilters.Add(

 }

i have written this code on form bound page addeditaccountasociation.ascx.cs.But it is not working .

When i give the same filter in static mode (like below) i am able to see the filtered accounts

<SalesLogix:LookupPreFilter PropertyName = "Type" PropertyType = "System.String" OperatorCode = "=" FilterValue = "Broker">

but i want dynamically filtering lookup lease Help

Mark

I have ran into the same situation in the past.

Basically, once you apply a condition, even if it is programatically, it won't revert back until the site is restarted....

Now, here is a potential solution, thiking out of the box:

  On your form, place 2 Lookup Controls, one with the Condition and one without the Condition.

  Use your Code to dynamically filter which Control is being displayed on the Screen.

  Off course, this also means that one control would probably be unbound, but you could always have code on the Opening of the Form and on the Closing of the Form to sync the values.

e.g.

  OnLoad

    myLookupWithConds.LookupResultValue = myLookup.LookupResultValue;

  On Save ( or on myLookupWithConds On Lookup Value Change event):

    myLookup.LookupResultValue = myLookupWithConds.LookupResultValue;

  On your Code:

  bool useFiltering = MyLogic();

  myLookup.Visible = !useFiltering;

  myLookupWithConds.Visible = !useFiltering;

Hi Raul,

Are you suggesting to have two controls one with filter and one without filter and make them visible and invisible based on my conditions or if we restart the site the dynamic filtering will work

mark

I suggest you use the Hidden Control Approach.

Restarting IIS will fix the problem, but then the next time you set filtering it will again keep the filter, I was just mentioning that restarting IIS cleared the condition only temporarily, but this off course is not a valid approach for a Production site.

Mark,

   The followng code should work.  Note the presense of the single quotes - these are not always needed - it depends on the type of column you're filtering on.

lueMyLookup.LookupPreFilters.Clear();
Sage.SalesLogix.HighLevelTypes.LookupPreFilter filter = new Sage.SalesLogix.HighLevelTypes.LookupPreFilter();
filter.LookupEntityName = "SomeEntity";
filter.PropertyName = "SomeProperty";
filter.CondOperator = "Equal";
filter.PropertyType = "System.String";
filter.FilterValue = "'" + "Some Value" + "'";
lueMyLookup.LookupPreFilters.Add(filter);