I use a stored procedure for the read list operation on the external content type.

I have a filter which based on User Profile then Username (or Accountname if you want it DOMAINUSERNAME format).

In the return parameters the key field which is passed to the read item operation is marked as the system identifier.

The read item operation on the same external content takes an input filter with the same column also marked as the system identifier.

Note that this is reliant on usernames being a field in the database table.

I can get it to work with the external data column control being in default display mode but not in drop down mode.

It does however let me prefilter the results from the external content type based on the user.

Hope this helps.

Hi Nancy,

I'm battling the same problem.

I'm working on a solution which uses a site workflow using Nintex form for start form.

I can connect the External Data Column control to workflow variable.

However when I try to use a calculated value control, in the formula builder the external data column does not appear in the named controls even when the EDC column does have a name.

I'm trying to see what I can do via javascript.

The other thing is that the EDC control allows for additional fields but I do not know how to access those.

Cheers,

Gavin

Hi Darwin

Code sample

So I have an external control named: edc-StudentUsername

I have 3 single line text box controls:

- slt-StudentPreferredName (Client ID javascript: StudentPreferredNameCalculated)

- slt-StudentID (Client ID javascript: StudentIDCalculated)

- slt-StudentUsername (Client ID javascript: StudentUsernameCalculated2)

In the user profile service there is a custom property StudentID which I populate via user profile sync.

Parent clicks on the select external item button (popup window) for the external data column control.

This retrieves the student username from the database query.

JavaScript then takes the value from the control and uses spservices.

(References in the form settings as a custom javascript include).

Then following javascript is in the form settings:

Hope this helps.

Cheers,

Gavin

NWF$(document).ready(function() {

NWF$("#" + ECTStudentUsername).bind('DOMNodeInserted', function(event) {
 
var studentusername = NWF$(this).find('div').attr('displaytext');

var calControl = NWF$('#' + StudentUsernameCalculated2);
studentusername = studentusername.trim()
calControl.val(studentusername );
var profile = {};    NWF$().SPServices({        operation: "GetUserProfileByName",        async: false,        AccountName: studentusername,        completefunc: function (data, status) {            NWF$(data.responseText).find("PropertyData").each(function (idx, val) {                var $val = NWF$(val);                var name = $val.find("Name").text();                var value = $val.find("Value").text();
                profileÂname] = value;              });        }     });

var studentID = profileÂ"StudentID"];
var testcontrol = NWF$('#' + StudentIDCalculated);
testcontrol.val(studentID);

var StudentPreferredName = profile "PreferredName"];
var StudentPreferredNamecontrol =  NWF$('#' + StudentPreferredNameCalculated);
StudentPreferredNamecontrol.val(StudentPreferredName);

});

});

I am still battling how to connect external data column (drop down list) with read only list. it shows blank in drop down.

Please share me

I think, this might help you: