Project

General

Profile

Feature #495

Is it possible to search on columns that are one table away from the columns set up in the global list picker method?

Added by John Michael Parkan about 12 years ago. Updated almost 12 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Robert Ivens
Target version:
-
Start date:
04/18/2012
Due date:
% Done:

0%

Estimated time:
Browser (if web client):

Description

// What columns are we gonna show, at least 1 column is required
_oCL = _oLP.newColumn();
_oCL.dataprovider = "qs_projects_to_qs_quotes.csono";

// On what columns are we gonna search. at least 1 column is required
_oCL = _oLP.newSearchColumn();
_oCL.dataprovider = "qs_projects_to_qs_quotes.csono";

Files

Screen_Shot_2012-04-18_at_5.32.23_PM.png (35 KB) Screen_Shot_2012-04-18_at_5.32.23_PM.png John Michael Parkan, 04/18/2012 11:46 PM
Screen_Shot_2012-04-18_at_5.32.15_PM.png (21.3 KB) Screen_Shot_2012-04-18_at_5.32.15_PM.png John Michael Parkan, 04/18/2012 11:46 PM

History

#1

Updated by Robert Ivens about 12 years ago

  • Status changed from New to Feedback

Yes you can search over Servoy relationships on related tables. Even more than one table away.
Just pass the relationshipname.columnname as a string and this should work.
Of course all the Servoy rules apply here so searching on non-stored data (unstored-calcs) is not supported.

#2

Updated by John Michael Parkan about 12 years ago

I thought I was passing "the relationshipname.columnname as a string" like this:

_oCL.dataprovider = "qs_projects_to_qs_quotes.csono";

#3

Updated by Robert Ivens about 12 years ago

That is correct. You say that isn't working ?

#4

Updated by John Michael Parkan about 12 years ago

See the screen shots below... the list picker doesn't see to be picking up the available csono (first column) when being called and searching doesn't find anything though the relation.

Here is what the console throws:

Your JSListPicker instance has the following issue(s):
- There is no callback properties set. You need to add a callback method OR a callback form and column/variable
-----------
Your JSListPicker instance has the following issue(s):
- There is no callback properties set. You need to add a callback method OR a callback form and column/variable

I took a cursory look at what it was trying to do but I couldn't really follow the code at first glance.

#5

Updated by Robert Ivens about 12 years ago

John Michael Parkan wrote:

Here is what the console throws:

I am pretty sure you are seeing 2 different things here. When you get these messages in the console then the listpicker will not show at all so your screenshots are from other code.

#6

Updated by Robert Ivens almost 12 years ago

  • Status changed from Feedback to Closed
  • Target version deleted (1.1)

Also available in: Atom PDF