Defaulting Item attribute Item Extended Attributes values in PDH

Summary:

Summary:

Defined attributes under attribute group. For 2 of the attributes, need to default the value.

Attribute(user) needs to be defaulted with the user who has logged in and another attribute (last update date) needs to be defaulted with the current date.

To Achieve this, in the item attribute setup, initial default value has been configured. Tried different methods, but did do not see the default value, when I open the item and navigate to item EFFs.

Is defaulting support in Item EFFs? Please suggest if the format needs to be corrected.

Method1

default type as sql and sql statement to fetch the display name of the logged in User. Query is valid and giving the output with one value when executed separately. But not defaulting on the item EFF