Syntax for addFoundSetFilterParam with 'IN'

Classic Servoy
1

Hi,

The addFoundSetFilterParam works fine using ‘IN’ when I use a SQL statement as the parameter. However for the world of me I can’t seem to figure it out if instead I want to pass a series of primary key values directly. I tried various permutations: with parentheses,quotation marks, and the best I’ve done is to have it just filter on the very last primary key in my list. And now I can’t even remember how I got that to work! Can anybody help?

fountset.addFoundSetFilterParam('NPV_ID', 'IN', PKS?)

This is Servoy 3.5.10

2

Hi John

This code is quite old and refers to addTable but should get you started.

	if ( globals.curr_User_Status == 'Sales'  )
	{

		var vUserID = globals.curr_User
		forms.j_users_countries_list.controller.find()
			forms.j_users_countries_list.zrid_user = vUserID
		var vCount = forms.j_users_countries_list.controller.search()
	
		var vArray = new Array()
		for (var i = 1; i <= vCount; i++) 
		{ 
			forms.j_users_countries_list.controller.setSelectedIndex(i)
			
			vArray[i-1] = forms.j_users_countries_list.country; 
		} 

		var vSuccess = databaseManager.addTableFilterParam('proptek04', 'contacts', 'addcountry', 'IN', vArray )

ps: You should be at ServoyCamp in DenHam - centre of the Servoy Universe this week -:slight_smile:

3

Hi John,

This is the code i use on a solution with the 'IN" statement

globals.gUserName = security.getUserName();
globals.gUserID = core_rso_emp_to_core_rso_user.user_id

if (globals.gUserID == null){
	security.logout();
	application.closeSolution();
}

	else if ((security.getUserName() == 'larivera') || (security.getUserName() == 'sadelcastillo') || (security.getUserName() == 'kajohnson')){
	var NestedIN = "SELECT jobcode FROM core_rso_emp WHERE jobcode IN('3440','4958','3465','4959','0000')";
	databaseManager.addTableFilterParam('rcs_billing_sharedcore', 'core_rso_emp', 'jobcode', 'IN', NestedIN);

	//disable Excel Import or Export
	plugins.excelxport.importEnabled = true;
	plugins.textxport.importEnabled = true;

	//disable menu bars
	plugins.kioskmode.setToolBarVisible(false);
	forms.form_RSO_Customers.controller.show()
}

	else {
	plugins.excelxport.importEnabled = true;
	plugins.textxport.importEnabled = true;
	plugins.kioskmode.setToolBarVisible(false);
	forms.form_RSO_Customers.controller.show()
}

hope that helps. this is on Servoy 3.5.10 with a SQL 2005 backend – also works on our SQL2000 backend as well

-David

4

Hi Graham and David,

I’m very sorry too that I’m not in Den Ham. This is my first ‘miss’ of a major Servoy event… Had to back out at the last minute unfortunately.

As to this topic at hand, I’m obviously getting too old… I was screwing around with it and actually thought I tried passing an array for the ‘IN’ parameter. But must have done something minor wrong and when it didn’t run I started obsessing that it must want a dataset and/or a delimited list of some kind… God only knows what I was thinking. Then when I saw David’s post and the phrase ‘NestedIN’ I thought that sounds familiar. So I searched the forum and sure enough:
http://www.servoy.com/forum/viewtopic.php?f=3&t=5864
Not only was I involved with that topic but I was the one who rather inadvertently discovered that you could use ‘IN’ as a parameter before it became ‘official’ and I actually used that phrase of ‘NestedIN’! Duh… Somewhat lamely in my defense I had only ever used the filter by feeding the straight SQL rather than the IDs directly or as an array. And when I searched the Forum I was looking for the FoundSetFilter rather than the TableFilter. OK, OK, I know: that’s weak. Anyway thanks both for helping the old man’s memory! I want to experiment using one query to capture various items, one of which will be the foundsetFilter but others will populate various valuelists, etc. Not sure which is faster in this case so wanted to test it.

Enjoy DenHam!

5

You’ve been missed John but not sure how good a shot you are with an arrow AT NIGHT - AFTER DRINKING! You may have just had a lucky escape!
Next time good friend!