Search puzzle

Classic Servoy
1

I have a tabpanel displayed in table mode which features a trash icon. I want to enable the user to delete that record and all rows associated with it. To find the associates I need to search the “catkey” text field for rows with the current contents of catkey plus any extensions. Thus “L1C1”, “L1C1x”, “L1C1xx”, etc.

If I go to the tabpanel form and manually do a find for “L1C1%” I come up with four rows. However the following method attached to the trash icon comes up with only one. The method is local to the tabpanel itself, not the form displaying the tab panel. What am I missing?

var key = catkey + '%';
controller.find();
catkey = key;
controller.search();
2

You’re searching the current controller where there is a record that has any child record that matches your request.

Instead - try:

var key = catkey + '%';
form.tabpanelform.controller.find();
form.tabpanelform.catkey = key;
form.tabpanelform.controller.search();

Bob Cusick

3

Nope, that’s not it. Still returns 1 record instead of 4.

The button is ON the tabpanel and the method is attached to the tabpanelform. The intent is the user clicks the trash icon of the records they wish to delete.

If I bring up the tabpanel form itself independently and click the button it works perfectly. But if I click on it from its normal placement within another form, then 1 record is returned.

If it matters, the tabpanel is within the same table as the form presenting the tabpanel. Still puzzled.

4

Morley,

You probably are showing the form in the tabpanel based on a relation?

Is the tabpanel form set to “useSeparateFoundSet”?

Bob