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

  • Question

  • 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.

    Wednesday, November 16, 2011 9:40 AM

Answers

  • 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 .
    Saturday, November 19, 2011 8:13 PM

All replies

  • 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 .
    Saturday, November 19, 2011 8:13 PM
  • Any update on this topic?
    Tuesday, April 10, 2012 11:13 AM
  • I'm not sure if you are still looking for answer, there is no straight forward way to acheive this. you have to trigger external work flow to do so which makes use of business rules, service broker and .net assemblies. personally I thinks it;s better option to mange it within subscription views.

    please follow the below link , hope it helps.

    http://johanmachielse.blogspot.com/2011/07/master-data-services-implementing.html

    • Proposed as answer by vishal.... _ Tuesday, November 25, 2014 5:59 PM
    Tuesday, November 25, 2014 5:59 PM