Is there any way we can set default value for a Date Attribute to current date in Master Data Services

Answered Is there any way we can set default value for a Date Attribute to current date in Master Data Services

  • 16 noiembrie 2011 09:40
     
     

    Is there any way we can set default value for a Date Attribute to current date in Master Data Services.

     

    I as well wants to know that is there any posibility to show Calendar control while input data into respective date attributes.

    Thanks.

Toate mesajele

  • 19 noiembrie 2011 20:13
     
     Răspuns
    Hi Anagha,
    So far i havent found any way to set todays date by default from MMI, but i guess this flow should work as workaroud
    1. Add buisness rule which can set a default value when Date = NULL/Blank
    2.get the entity table ,use -select EntityTable from mdm.tblEntity where Name = '<enter entity name>'
    3.Go to that table and add a after update trigger like
    if uda_<entityid>_<attributeid(Date attribute)> = default value
    update uda_<entityid>_<attributeid(Date attribute)> =getdate() where id = <LastUpdatedRow>
    I will check on this too from my side.
    By the way AFAIK i dont think so calendar control integration is possible .
  • 10 aprilie 2012 11:13
     
     
    Any update on this topic?