Getting SDT variables in Listbox

Hello!

I have the SDT process variable named 'ServiceData' (with repeatable variables inside) and I need to show one of its variables (with its values) in the Listbox.

In the Forms Builder I created the Taskspace Task and the adaptor:

- adaptor type = Data source

- class name = com.documentum.xforms.engine.adaptor.datasource.docbase.IDocbaseDataSourceAdaptorService

- type = SBO

- initial parameter: name = 'dql', value =

SELECT srv_r.attr7,

srv_r.r_object_id

FROM dmc_wfsd_servicedata srv,
dmc_wfsd_servicedata_r srv_r

WHERE srv_r.attr8 = '${attr}'
AND srv.workflow_id = '${workflow-id}'

AND srv_r.r_object_id = srv.r_object_id

- input: attr (string) - another variable from SDT 'ServiceData' and workflow-id (string)

- output: Schema->Items->Number (string)

After that I assigned this adaptor to listbox on the General -> Data&Storage. I assigned input parameters attr and workflow-id to another variables.

Also I checked my dql query with Document Administrator's utility - DQL editor and got the result is that I need. (Here I substituted the attr and workflow-id with real values).

Finally I got listbox with a number empty/blank lines and this number is mathes the number of lines in DQL editor.

Also I tried a simplier query (it has no meaning, it only needed to test):

SELECT r_object_id,
string_value

FROM dmc_wfsd_element_string

But got the same result - a set with empty lines.

What I missed?

Thanks and regards,

Konstantin

Find more posts tagged with

Comments

DCTM_Guru

If you are assigning the values in a previous activity, why dont you just map the listbox control directly to your process variable using data mapper activity?

Miller-zzMST

Hi,

I would like to, but the problem is that the listbox does not display such a variable (remember, I want to display one of the reapeatable variables of my STD: ServiceData have a few string repeatable variables: Name, Number, etc).

DCTM_Guru

I'm not quite following you. In the Special Tab (Data Source textbox) for your listbox control, you should be able to bind to the process variable.

Miller-zzMST

I am doing next steps:

1. Create the SDT 'Test1' with first variable (repeatable) 'attr-1':

1 - SDT.PNG

2. Create the process variable std2 and assing it's values with Process Data mapping activity:

std2 -> Test1 -> attr-1[0] = "1-1"

std2 -> Test1 -> attr-1[1] = "1-2"

std2 -> Test1 -> attr-1[2] = "1-3"

2 - Assigning variables.PNG

3. Bind to listbox on the form:

3 - Binding variables.PNG

4. The result is empty listbox with error popup message:

4 - Empty listbox.PNG

Also I checked the variable std2->Test1-attr-1 without installed form:

5 - Checking variable.PNG

PS. Sorry, I haven't mentioned - I use xCP Developer Edition 6.5 SP2.

Miller-zzMST

Problem solved:

- modify the dql-query:

SELECT srv_r.attr7

FROM dmc_wfsd_servicedata srv,
dmc_wfsd_servicedata_r srv_r

WHERE srv_r.attr8 = '${attr}'
AND srv.workflow_id = '${workflow-id}'
AND srv_r.r_object_id = srv.r_object_id

- and re-create form (I don't know why but after first step the error appear, just after recreating the form solved the problem).