_filterList sintax in AfterSelect Javascript of Edit-Combo List

[simeatan]

Hi! Coming from the xBase line of dBASE, Clipper, Foxpro, VFP programming, so javascript and webdev is new to me.
I'm hoping someone will point out what am I doing wrong with a simple task of filtering out a list after a value in a textbox (edit-combo list type) is being selected.
I'd like to avoid using a Search button, which works fine in filtering the list after. I tested invoking that code from AfterSelect (and OnSelect) with {dialog.object}.buttonClick('BUTTON_3'); . It works too, but for some reason not the first time I select a value.
So, back to the initial idea of the filtering with javascript command right from AfterSelect in the Lookup definition:

Using the latest update.

Works:
{dialog.object}._filterList('list2','prod_cat = "207 "');

Does not work (after "207 " row is selected):
var a;
a = this.value;
alert(a); // this messagebox comes up fine
{dialog.object}._filterList('list2', 'prod_cat = :a');

No surprise, this does not work either:
var a;
a = "207 ";
alert(a); // this messagebox comes up fine
{dialog.object}._filterList('list2', 'prod_cat = :a');


I tried multiple combinations of the second part of that command, at no avail. Am I missing something in defining the parameters in _filterList?
I see there's a filterExpn,orderExpn,filterParameters,havingExpn in the syntax. Maybe put a placeholder there, empty quotes?

Thanks in advance!

[GGandhi]

Re: _filterList sintax in AfterSelect Javascript of Edit-Combo List

var a;
 a = this.value;
 alert(a); // this messagebox comes up fine
 {dialog.object}._filterList('list2'), 'prod_cat = ' + a);
or
{dialog.object}._filterList('list2'), 'prod_cat =" + a + " ' );

I don't have version 12, but this is how you will normally replace the any item with a variable, try and see if this works.

[simeatan]

Re: _filterList sintax in AfterSelect Javascript of Edit-Combo List

Gandhi,
Thanks for your reply - Sorry I had an extra ")" in the previous edit of my post. I tried the suggested syntax. No luck yet.

[Davidk]

Re: _filterList sintax in AfterSelect Javascript of Edit-Combo List

Have a look at the _filterList example in the List methods inline doc. In one of your examples you were trying to use an argument, but not supplying the value for that argument. I'm not sure what your posted example syntax was, but the posted solution syntax was incorrect.

If you'd like to use arguments, then you can do this... (change my 'CUSTOMER_ID' to your field name... you get the idea). This code has been tested. This code is called in the onSelect event of a Textbox control set up as an edit-combo.

Here we are setting up a parameter string to feed into your argument. The argument is specified by the : in front of what name you'd like - it can be any meaningful text - it doesn't have to match the column name. The params string is passed into the method.

var params = this.value + '|||N|whatId';
{dialog.object}._filterList('LISTCUST','CUSTOMER_ID = :whatId','',params);

The sample code in the inline doc is...

//use \n to create a cr-lf delimited list
//var params = 'Boston|||C|whatcity\nSmith|||C|whatname';
//{dialog.object}._filterList('MYLIST1','city = :whatcity AND name = :whatname','',params);

The example is using 2 arguments. You can see that a value, 3 pipes, a type, a pipe, and a name is supplied for each argument section. In your case, for 1 argument, it would be...

var params = this.value + '|||N|procCat';
{dialog.object}._filterList('LISTCUST','prod_cat = :prodCat','',params);

Or... you don't have to use an argument. You can add the supplied value to the 2nd parameter of the _filterList method.

{dialog.object}._filterList('LISTCUST','CUSTOMER_ID = ' + this.value);

[simeatan]

Re: _filterList syntax in AfterSelect Javascript of Edit-Combo List

David, thanks for your input. I tried the last line of code but it shows an empty list now. I don't need any (extra) parameters in the js code, or passing values to xbasic. Just failing to see what's the difference, or my mistake in the syntax. Looks so basic, no pun intended. It works fine with a button that filters/searches.
1) {dialog.object}._filterList('list2','prod_cat = "207 "'); // works

and

2)
var a;
a = "207 ";
{dialog.object}._filterList('list2','prod_cat =' + a); // not working

I'm attaching two screenshots. Thanks again!

lookup1.jpglookup2.jpg

[GGandhi]

Re: _filterList sintax in AfterSelect Javascript of Edit-Combo List

{dialog.object}._filterList('list2', 'prod_cat =\"" + a + "\" ' );
may be this?

[simeatan]

Re: _filterList sintax in AfterSelect Javascript of Edit-Combo List

Gandhi,
I just tried both
{dialog.object}._filterList('list2', 'prod_cat =\"" + a + "\" ' );
and
{dialog.object}._filterList('list2', 'prod_cat ="\" + a + "\" ' );

, getting this error message in the empty list.

['Error.No such field']

[simeatan]

Re: _filterList sintax in AfterSelect Javascript of Edit-Combo List

Hi guys. Just a quick update/conclusion: I ended up creating a javascript action and and doing runaction it in the AfterSelect place.
A regular "Filter Records in a List Control" did the trick, instead of a _filterList command. Still puzzling, but not the only thing that puzzles me in programming and life. Or the world, for that matter. Thanks for your help - I appreciate it!

[Davidk]

Re: _filterList sintax in AfterSelect Javascript of Edit-Combo List

Now that I know you're working with DBF tables, it makes sense. You should try to specify your Alpha build and data source when posting... it helps.

Working with a DBF table, this does not work... (it works using SQL)

var a;
a = "00000004";
{dialog.object}._filterList('LISTCUST','CUSTOMER_ID = ' + a);

This does work...

var a;
a = "00000004";
{dialog.object}._filterList('LISTCUST','CUSTOMER_ID = "' + a + '"');

And so... this works...

{dialog.object}._filterList('LISTCUST','CUSTOMER_ID = "' + this.value + '"');

[simeatan]

Re: _filterList sintax in AfterSelect Javascript of Edit-Combo List

Thanks a lot, David - I tried the code you supplied (with this.value) and works like a charm!
My apologies I forgot to mention I work with the existing DBFs during their transition to mysql.
A big lesson I learned from this: syntax and using quotes in the interpreting of dbf and sql table fields is different, in a same command. Have a great weekend!

[Davidk]

Re: _filterList sintax in AfterSelect Javascript of Edit-Combo List

Excellent... glad to hear it worked out... and that you were able to find another way to get this done... one of Alpha's many strengths.

[simeatan]

Re: _filterList sintax in AfterSelect Javascript of Edit-Combo List

So true - although sometimes (me, the ungrateful) wishes I wasn't given more than one choice. That'd force me to look for the best way, the only one. Of course, the other side of the coin is that in different situations we need a different code to employ. The beauty of many ways around. The beauty of Alpha too, I agree.