I have a form which has a tab panel, which in turn has sub tab panel
inserted. Everything works fine, but I can’t include these tab panels in searching criteria. Any hope to get this working?
The other problem is searching a word which is included in a field, but possibly not the first or the last one. Are there any possibilities to have
searhing command little bit more tolerated (or more searching characters than % and #). I have made kind of search/replace metod with regular expressions, but I think in this (only ) case FileMaker’s way of searhing works better than Servoy’s.
One more wish to include is possibility to have the empty space under
default controller to use. I would like to place my buttons and valuelists
to the left side and at the same time use Servoy’s default controller above them. Any possibilities?
Thanks for a good product- it has saved my day many times already!
I have a form which has a tab panel, which in turn has sub tab panel
inserted. Everything works fine, but I can’t include these tab panels in searching criteria. Any hope to get this working?
Are you trying to do a search like: mainForm AND subform1 AND subform2? can you give a me an example?
The other problem is searching a word which is included in a field, but possibly not the first or the last one. Are there any possibilities to have
searhing command little bit more tolerated (or more searching characters than % and #). I have made kind of search/replace metod with regular expressions, but I think in this (only ) case FileMaker’s way of searhing works better than Servoy’s.
Are you talking about doing a search in general, or creating search and replace script. Can you give me an example here as well?
One more wish to include is possibility to have the empty space under
default controller to use. I would like to place my buttons and valuelists
to the left side and at the same time use Servoy’s default controller above them. Any possibilities?
It’s on our list to have multiple controllers on a form. It’s technically possible, but we have to work out which properties wil accompany this feature.(there a lot of implications with this feature)
I can discuss with dev team to offer the default controller as a bean/object.
Thanks for a good product- it has saved my day many times already!
It’s very inspiring, getting so many positive reactions about our product.
Thank you for investing your time into Servoy!
Using ‘%’ on both sides of the text to be searched doesn’t demand
anything to be on the sides- so this feature works like a dreamM-^EI’m
very-very sorry giving some extra points for FM . Promise to be kinder
for Servoy next time.
But. I found that trying to search on RTF-fields doesn’t work in any form
(not speaking about tab panels yet). If I change the display_type to text_field then everything works fine. (Happens on MacOSX 10.2.6 developer and client as well, not tested on PC yet).
In addition I found that searching on tab panel works one level deep
if the dataprovider belongs to the same table as the main form. If this
same dataprovider is two tab panels deep, searching doesn’t work.
Using ‘%’ on both sides of the text to be searched doesn’t demand
anything to be on the sides- so this feature works like a dream…I’m
very-very sorry giving some extra points for FM . Promise to be kinder
for Servoy next time.
That’s OK.
But. I found that trying to search on RTF-fields doesn’t work in any form
(not speaking about tab panels yet). If I change the display_type to text_field then everything works fine. (Happens on MacOSX 10.2.6 developer and client as well, not tested on PC yet).
You’re right. One of our programmers is looking into this now.
In addition I found that searching on tab panel works one level deep
if the dataprovider belongs to the same table as the main form. If this
same dataprovider is two tab panels deep, searching doesn’t work.
I agree that the one of the things that filemaker does well is “finds” you can search a field or calcualted field with any part of a search string, if for the name john smith, you can type “john Smith or jo smi or j smi or anything like it a get a found set, no messing around with”#" or “%” or the like. I have never seen any other database that can do it as well. Why cant Servoy do the thing without alot of extra work. Also why is there no “masking” built in for fields, that is the one thing filemaker has left out for along time that Servoy should include. You should not have to program a telephone number format, SSN or the like. Look at Alpha 5 who has a rich set of field rules and formating options. Just an idea since Servoy is new to most of us it would be nice to have the best off all the database tools around. Thanks
Well it’s mainly for performance, we want the user explictly think about doing such a search (which a SQL ‘like’ at the backend db if you use % signs in the text, can be very expensive)
It is actually up to the developer, if he want to hide that from the user like [u]Cool rapid search[/u] he could do so.
drobindo:
I agree that the one of the things that filemaker does well is “finds” you can search a field or calcualted field with any part of a search string, if for the name john smith, you can type “john Smith or jo smi or j smi or anything like it a get a found set, no messing around with”#" or “%” or the like. I have never seen any other database that can do it as well. Why cant Servoy do the thing without alot of extra work. Also why is there no “masking” built in for fields, that is the one thing filemaker has left out for along time that Servoy should include. You should not have to program a telephone number format, SSN or the like. Look at Alpha 5 who has a rich set of field rules and formating options. Just an idea since Servoy is new to most of us it would be nice to have the best off all the database tools around. Thanks
The fact that you need to explicitly choose for like and case insensitive searches in Servoy has good reasons. If you start searching case insensitive or begins with in a SQL database the index of a column cannot be used which in production environments can have serious performance consequences. If as a programmer you know that your dataset is small and your number of concurrent users is low you can program a begins with (and/or case insensitive) search in just a couple of seconds (check the CRM example included with Servoy)
We have planned support for datamasking in future versions. Until then it is fairly easy to implement that using a simple JavaScript and an event.