Fixed Value Attribute will not accept values from query.
Why won't eB save the text value returned from a SQL query into the attribute?
The attribute is set up as a Fixed Value attribute which should allow entry of alpha-numerics up to 255 characters. The query is: SELECT FULL_NAMES NAME FROM PERSONS WHERE STATUS = 'A' and returns what is expected to the 'Current Values' list when tested.
When attempting to populate this attribute on a document, the following error is returned: 'Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index'
Any ideas?
Hi Ken,
Fyodor suggest the following:
SELECT full_names AS value, 'N' AS is_obsolete FROM persons WHERE status = 'A' AND full_names IS NOT NULL ORDER BY full_names
Please let us know if this works for you.
What is the purpose of the " 'N' AS is_obsolete " portion of the query?
This new query works.
Great. Could you please close this issue by selecting "This helped me" and "Verify"
Thanks
I will gladly close this issue when an acceptable explanation has been provided for the question.
Thanks Carma!
Ken.
DOCX
Answer Verified By: Carma De Villiers