I know this is a repost, but I have not heard back on the 1st one I asked about yet. Wanted to make sure you get this one.Here is one where it may be a bug in StrataFrame.
I have a combo dropdown as a search item on the browse screen. In my example I'll just say it is a GENDER dropdown with values "Male" and "Female".
On the Search Criteria dialog "General" tab the "Initial Search Value" is left blanl and the "Ignore initial search value if not visible" is checked. The "Search Style" is set to "Begins With".
The other options on the screen are checked for "Allow Advanced Options", "Visible" and "Initially Enabled".
The Text tab has nothing entered on the "Field Mask" and the "Mask Literal and Prompt Option" is set to the default of "ExcludePromptAndLiterals".
The "Combo - General" tab has nothing entered in the "Top Most Text" or thye "Top Most Value".
The "Combo - Enum" tab has nothing entered.
The "Combo - Business Object" tab is selected to fill the combo box from a code table with the valid values which in this example are "Male" and "Female".
The value stored in the table to be searched is the same as the combo dropdown "Male" or "Female". This is just an example.
When you run the form and the BROWSE (this is a SF Maintenance form), the combobox displays showing the first value in the dropdown by default "Female". If you select the first value in the list and click on SEARCH, the results show all rows "Male" and "Female". If you select the 2nd valuie from the combo "Male", it just displays the rows that are "Male". I looked at the actual SQL that is being generated from the SEARCH by SF when the 1st value in the combo is chosen and it never includes this in the WHERE clause. Like it is assuming the the 1st value in the combo means the user wants to select all.
Then I changed the combo to have it show as the 1st value in the dropdown as "<not used>" followed by the 2 choices "Male" and "Female" by going into the SEARCH fields, selecting the combo, and then on the "Combo - General" tab put "<not used>" in the "Top Most Text" and "-1" in the "Top Most Value".
Then run the form and when the combo displays, by default it displays the 1st value in the combo which is "<not used>". Clicked on SEARCH and results show all, clicked on the 2nd and the 3rd options and they just returned the rows based on what was selected.
It appears that the SF BROWSE SEARCH is never including the first value in the dropdown as part of the generated WHERE clause. So my question here is two fold:
If I just want the dropdown to Display "Male" and "Female", what else do I need to do to fix the issue?
Assuming I want to have the 1st value in the dropdown actually be "<not used>" but want the second value in the dropdown be displayed by default when the form displays, what do I need to do?