Filter

PEzechielsPEzechiels Member Posts: 83
Hey Guys,

I need to put a filter on a form ,one which a user cannot clear.
e.g. A user may only see the records that he or she entered.
If i set the filter in the script the user can reset the filters through "Show All".


Any Ideas?


thnx

Comments

  • Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Use FILTERGROUP for that reason. See Form 42 Sales Order, OnOpenForm-trigger:

    IF UserMgt.GetSalesFilter() <> '' THEN BEGIN
      FILTERGROUP(2);
      SETRANGE("Responsibility Center",UserMgt.GetSalesFilter());
      FILTERGROUP(0);
    END;
    
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • PEzechielsPEzechiels Member Posts: 83
    Like a charm........

    Thnx Luc
  • Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Isn't that great: have your question answered within 5 minutes ;-)
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • PEzechielsPEzechiels Member Posts: 83
    at that point nothing feels better :mrgreen:
  • SavatageSavatage Member Posts: 7,142
    Isn't that great: have your question answered within 5 minutes ;-)

    & At No Charge 8)
Sign In or Register to comment.