Simple Search and Universal Search are both very useful but that still do not search the subform fields. Is there anyway to search also the subform tableview forms along with the mainform for that simple word or words?

Hello Bharat,

It would add a bit of overhead to the file and increase the size of each parent record but it would accomplish what you are after and allow simple search to work on values stored in the subform.

-Ray

Hello Bharat,

Looking at it now, It is going to be quite a lot of programming to maintain that description element on the Parent form.

Mark was brainstorming here in the office and came up with a way that may work for you depending on several things.

When you do a simple search are you looking for a single word or multiple words?
You say you want to search the description element of all 3 subforms, in addition to that, How many elements on the parent form do you really need to search for that data as well?

-Ray

Trying to maintain an element that contains the values for elements that appear on three subforms, each possibly containing dozens, if not hundreds, of records, sounds very difficult. You will need to continuously run through all of the subform records and rebuild the "read only" field. Trying to maintain the totality string on the parent form, without rebuilding it over and over again, is likely to be extremely difficult. If you have a lot of records in the subforms, it will be nearly impossible to determine the beginning point and end point of edits without also saving every original value in yet another globally static variable or element - one for each record in each subform.

I would recommend instead, that you place a button on the parent form in search that brings up a @PromptForUserInput and asks the user for a search string. It then fills in the search spec in the appropriate elements in the subforms (and in the main form, if any elements there are relevent) and sets the search mode to "or" instead of "and" and kicks off the search. If need be, you can preface and concatenate ".." onto the string. While not as flexible as Universal Search, this will allow you to easily search all of the values in all of the subform records for one or more elements per subform / parent form.

I'm not sure what you are asking.

I believe you can meet your requirement using some automation in SBasic. Even if you need to search all of the elements on the main form, plus some on the subforms, it is simply a matter of changing the mode (from "and" to "or") and using filling out those elements on the retrieve spec. Basically, you are automating what you would do by hand.

I looked into getting Universal Search to work with subforms. It doesn't look too difficult. I will probably add it as a feature to Sesame 3.

Bharat_Naik wrote on Mar 22^nd, 2013 at 8:02pm:


Use SelectTreeItem to set the mode to "Meet any Restriction" (or "Or") before using SelectTreeItem to launch the search.