StrataFrame Forum

Using Between Date lookup in BrowseDialog

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

By Guillermo Vilas - 8/18/2008

I´m trying to figure out how to implement this kind of search.



Search PO from date A to date B



Since I am looking in the same Date column field I´m getting an exception telling me that the same reference is already added to the search field collection. Do I need to override the search text manually?



Thanks
By Edhy Rijo - 8/18/2008

Hi Guillermo,

Check out the Unique Key value in the BD Search Field Criteria form.  This will allow you to have a unique key for a field which is used several times in the BD like in your case with the date range search.

By Trent L. Taylor - 8/18/2008

Edhy is right.  This is why the unique key was added back in 1.6.5 for this very reason.  By default, if you do not provide one, it will use the name of the field when you close the dialog.  But if you specify a unique value here, it will use it.  The problem is that you have the same field in there twice and they are trying to use the same key.  Provide a different key for each field and it will resolve your problem:
By Guillermo Vilas - 8/18/2008

Thanks to both Edhy and Trent.

That made the trick!!
By Trent L. Taylor - 8/19/2008

Cool Cool