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

Keith over 9 years ago

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?

...

Discussion posts and replies are publicly visible

Parents

0 Keith over 9 years ago

I am struggling again... I tried various things... Without the where clause we get data. However we want to filter the data for a site. the data also has a slash in it and it looks like autoComplete without the where clause shows the result very differently.

For instance. 10.120.0.0/29 shows as 10.120.0.29

Here is my statement..
importScript('/plugins/servlet/FormsExt.js');
var query = "select StartingIP from SIP_Networks where SegmentNumber = \\"\\'kygra\\'\\" and DataCenter = \\"\\'center\\'\\" order by 1";
FormAPI.attachAutocompleteFromQuery("text2", "jdbc/2029_SQL_Inet_ECS", query, "StartingIP", "StartingIP", false);

this does not work - it resolves, but no data shows.

If I remove the where clause it then works.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Keith over 9 years ago

I am struggling again... I tried various things... Without the where clause we get data. However we want to filter the data for a site. the data also has a slash in it and it looks like autoComplete without the where clause shows the result very differently.

For instance. 10.120.0.0/29 shows as 10.120.0.29

Here is my statement..
importScript('/plugins/servlet/FormsExt.js');
var query = "select StartingIP from SIP_Networks where SegmentNumber = \\"\\'kygra\\'\\" and DataCenter = \\"\\'center\\'\\" order by 1";
FormAPI.attachAutocompleteFromQuery("text2", "jdbc/2029_SQL_Inet_ECS", query, "StartingIP", "StartingIP", false);

this does not work - it resolves, but no data shows.

If I remove the where clause it then works.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data