Dear All,
I have a read only attribute which should autopopulate during importing of document.
The value assistance dql is: select description from dm_user where user_name='$r_creator_name'
But it is not displaying anything.
Value assistance does NOT work with read-only. If you are using value assistance query, why does it need to be read-only? As long as you check the "list is complete" checkbox, users can not change the value that is returned by the query (so in essence its "read-only").
Dear Johnny,
I have tow fields : 1. Document Owner (Author) 2. Owner Function
Document owner will have drop down with list with all users: select user_name from dm_user
but default value should be r_creator_name (Not able to achieve)
Owner function : select description from dm_user where user_name='$value(doc_owner)' will return only one value.
You can fake this out by doing UNION between your list and the CURRENT user:
select USER from dm_server_config UNION select description from dm_user where user_name='$value(doc_owner)'
fyi - r_creator_name value does NOT exist yet, because import has not completed yet.
yamangoyal wrote:Dear Johnny,I have tow fields : 1. Document Owner (Author) 2. Owner FunctionDocument owner will have drop down with list with all users: select user_name from dm_user but default value should be r_creator_name (Not able to achieve)Owner function : select description from dm_user where user_name='$value(doc_owner)' will return only one value.
There is already an authors attribute, but as it is repeating I guess that is not what you want.
You can not achieve your objective by configuration alone.
What client? If Webtop, then you can extend the import and provide a list of default values for attributes. It would be best to use a TBO customisation to ensure the correct value is put into the read only field. That way the read only value is always correct regardles of client.
If you have less than 495 potential authors, there is a way to achieve your goal of a user friendly label without having two attributes, by using the data dictionary ability to display different labels for different locales!!! I have used this trick in my last few projects.
You would need to write a job and method to build and run an alter type statement. See following link for an example of the statement and why the 495 item limit.
https://community.emc.com/thread/122163
