autoComplete question. I am trying to get an autoComplete statement t

autoComplete question.

I am trying to get an autoComplete statement to work and Appian is throwing an error.

I am wondering if the predefined datastore has to have a name longer than three letters.
I looked at documentation and could not see anything refer to the name size being an issue.
If I chose a different database and table, I can get it to work. This is a view and I am not able to get it to work.

I can query view SQL Server 2008 without and issue and also with a query database node in Appian it will work.

var query = "Select applicationname from vw_active_application where applicationname not in ('zOther','DBA','') order by applicationname”;
FormAPI.attachAutocompleteFromQuery("appName”,"jdbc/DDS", query,"applicationname", " applicationname",false);


I even tried it without the where and order clause and it will not work.

Any thoughts?

...

OriginalPostID-117847

OriginalPostID-117847