StrataFrame Forum

Browse Dialog Search Field

http://forum.strataframe.net/Topic29379.aspx

By Terry Bottorff - 1/17/2011

Does a Browse Dialog allow you to search on a Custom Field Property? If it is possible I am getting an error and I will attach to the next reply.
If not is there a way to search on a Custom Field? 
TIA.
By Ivan George Borges - 1/17/2011

Hi Terry.

Nope, there is no way to search on a custom property. Any field that you want to search on must exist in the database.
By Terry Bottorff - 1/17/2011

Makes sense. I was afraid of that because I thought that is what the error message was saying.
Is there any magic way around it that you are aware of?
TIA.
By Ivan George Borges - 1/17/2011

I guess this depends on your scenario. Would you be able to produce a view where you would have all the fields you want, including the field you were creating as a custom property? If yes, you can BrowseDialog on the view, get the PK of the chosen row and navigate your original BO to it.
By Terry Bottorff - 1/17/2011

So if I search for a record with out using the custom field, can I display the custom field in the results? I can not seem to get that to work either.
TIA
By Terry Bottorff - 1/17/2011

Yes I could do this but if I can do what I asked in my last question then I can stay away from the view. 
Thanks so much for the great help.
By Ivan George Borges - 1/20/2011

Yes Terry, you should be able to show your custom field on your form, if this is what you meant. But no, it won't be shown on the Search Results listview, for that the view would help.

You are welcome, let us know of the outcome. Wink
By Trent L. Taylor - 1/20/2011

Actually, there is one way. You can use the custom schema and table name on the browse and use a view to search on a field not in the normal table...assuming that the field does actually have something behind it.  If you custom field property is just pulling from other fields that actually exist in the table or that could be calculated as a view field, then this approach would work.