How can we find the database locations of fields?
For instance, an extendedSchemaTable with a namespace nsp has a fieldName with string type.
How do we locate this fieldName?
I am not sure if I got understood your question. But in case, you are looking for the details of a field (of an extended schema), you can check the 'Preview' tab of the main schema. (e.g. if nms:recipient schema has been extended to cus:recipient, the extended field details can be viewed in Preview tab of nms:recipient schema).
What will be the value if I need to use it in a workflow ?
will it be nspExtendedSchemaTable.sFieldName ?
It should be originalSchema.sfieldName. e.g. nmsRecipient.newField.
In addition to this, if I create a variable within a workflow, let say myCode in an activity,
and then later if I want to use this code, then i have to use it as targetData.myCode, am I right?
Then if I need to create a query then I have to use [targetData/@myCode], is this ok?
For a variable in your workflow, you can define it as instance.vars.xxx (considering xxx is the variable name) and use it in your query block as $(instance/vars/@xxx)
Thanks, I got your logic.,
(if we provide a name for the field at XML, then it will be Fieldname, otherwise,
system would assign sFieldName, i think.)
In a schema view, click on preview tab.
SQL Table name will be stored as schema.element.@sqltable
SQL Field name will be stored as schema.element.attribute.@sqlname