Hi,
How can I get List Fields data using a Workflow SQL Query activity ?
The propval table isn't guaranteed to give you all possible values of a particular list field. If that's what you are looking for, you'll need to query the lup table using the prop_id.
Hi Michel,
Can you clarify your question? Are you wanting to know how to use a Workflow SQL Query to get all possible values of a list field? Are you asking about just getting the value that's set in that list field for a particular document? If you can provide more context to your request, then we'll be better able to provide an answer.
Regards
Hi Alex,
I would like to know how to use a Workflow SQL Query to get all possible values of a list field.
Regards,
One way to get those values is to search for a List Field name in table 'dbo.propdef' and get the value in column 'prop_id'. Then I use that value as a key in table 'dbo.propval' to get all possible values. of the List Field.