How to remove the "Modified" Sign at the Object De

mgerhartzmgerhartz Member Posts: 50
Hi,

I've a short questition. I want to remove all the Signs "Modified" at the Object Designer, because we relaunched the whole database and want to see which objects are modified since today.

Is it possible to remove all marks at one time?

Comments

  • jpjesusjpjesus Member Posts: 45
    Yes,

    Create a codeunit or a report over table 2000000001 and do:

    Record.MODIFYALL(Field, NewValue [, RunTrigger]);

    where:

    Record.MODIFYALL(Modified, False);


    Easy.
  • kinekine Member Posts: 12,562
      Object.MODIFYALL(Modified,false);
    


    Ah, I see now that I was too slow... ;-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • mgerhartzmgerhartz Member Posts: 50
    Thanks for your help. I tried it, but I got the following error message:
    "You cannot modify table data in the object table. Modify the table definition instead."

    Any Idea?
  • kinekine Member Posts: 12,562
    add
      OBject.SETRANGE(Type,Object.Type::Table,Object.Type::MenuSuite);
    
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • mgerhartzmgerhartz Member Posts: 50
    nothing changed after adding your code part :roll:
  • mgerhartzmgerhartz Member Posts: 50
    Do I need some special rights to get access to the table "Object"? We have the development licence. (Just an info: I become a developer. At this time I'm a blody greenhorn)

    :sick:
  • unnareliunnareli Member Posts: 7
    Hi,

    Create a Report and save it.

    In the DataItem put in Object.

    Go into the properties of the DataItem Object and add the following line into the DataItemTableView.

    SORTING(Type,Company Name,ID) WHERE(Type=FILTER(Table..Codeunit),Modified=Const(Yes))

    * This is in V3.70 so you might need to add the menusuite into your filter on the type e.g. (Table..MenuSuite)

    Then on aftergetrecord of the DataItem write the following code.

    Modified := FALSE;
    MODIFY;

    And the run.

    Just Make sure that the report you design is within you license range.

    Reg, Unnar
  • mgerhartzmgerhartz Member Posts: 50
    Hi Unnar,

    Thank you so much. It's working fine!

    Have a nice day :D
  • krikikriki Member, Moderator Posts: 9,118
    mgerhartz wrote:
    Hi,

    I've a short questition. I want to remove all the Signs "Modified" at the Object Designer, because we relaunched the whole database and want to see which objects are modified since today.

    Is it possible to remove all marks at one time?
    Wouldn't it be easier to put a filter on the Date-field when you need to know it?
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.