OverrideSearchTableName


Author
Message
Alex Luyando
Alex Luyando
StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)
Group: StrataFrame Users
Posts: 112, Visits: 1.2K
No worries... it's all good.

________________
_____/ Regards,
____/ al
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
I assume you mean set the default Search Style (not the Initial Search Value).




Yeah, sorry. Blush It sounds like you went back in and did what I was suggesting anyway even through my poor post. Let me know if you have any other issues.
Alex Luyando
Alex Luyando
StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)
Group: StrataFrame Users
Posts: 112, Visits: 1.2K
Trent -



I assume you mean set the default Search Style (not the Initial Search Value). That being the case, then yes (installed 1.7.0.2), and yes (went back into the dialogs and set the Search Style).



One of the things I had not done, however, was to change the Search Styles to something other than the default Equals (because, well, I wanted Equals to be the default). Doing that now (e.g., setting Search Styles to Begins With) resolves the "empty" DropDown Listbox issue. I think I can live with that, but let me know if you need additional information from me to troubleshoot this in case there's a tweak that's needed).



Thanks.

________________
_____/ Regards,
____/ al
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
Still have the "empty" DropDowns in the Search dialog for any search field that is a view-only (i.e., not part of the real BO), but I will try to not worry about that too much unless it creates a problem. (Maybe just a bit concerned as it seems to deviate from expected behavior).




Have you downloaded 1.7.0.2 and then gone back into the editor to set the initial value? I fixed this in the most recent build to prevent this from happening.
Alex Luyando
Alex Luyando
StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)
Group: StrataFrame Users
Posts: 112, Visits: 1.2K
Trent L. Taylor (08/27/2009)
Ahhh...you are trying to put the column in the results, not the search!.




Movie Trivia Quote of the Day: "What we have here, is a failure to communicate."



I had been concerned that we were mixing Cowboys and Giants BigGrin) Thanks for the tip... the Company Name now appears in the BD's listivew... love it. Still have the "empty" DropDowns in the Search dialog for any search field that is a view-only (i.e., not part of the real BO), but I will try to not worry about that too much unless it creates a problem. (Maybe just a bit concerned as it seems to deviate from expected behavior).




________________
_____/ Regards,
____/ al
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
Ahhh...you are trying to put the column in the results, not the search!

There is a new property called IgnoreTableMappingAndIncludeAllFieldsInResults (or something like that) on the BrowseDialog that will include any column that is part of the overriding table as part of the search results.

Alex Luyando
Alex Luyando
StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)StrataFrame User (210 reputation)
Group: StrataFrame Users
Posts: 112, Visits: 1.2K
Trent -



Installed the 1.7.0.2 update; no change (not that we expected any). I will work on setting up the StrataFlix database and testing the sample application this evening.



In the meanwhile it occurred to me that throughout this I have never posted the exception details, so I am including it here fwiw.



Thanks.



_____________________________________________________

IndexOutOfRangeException

The given item name could not be evaluated. The item 'CompanyName' does not exist on the business object.



Source : MicroFour StrataFrame Business



Stack Trace:

at MicroFour.StrataFrame.Business.BusinessLayer.GetDescriptor(String FieldName)

at MicroFour.StrataFrame.Business.BusinessLayer.get_Item(String FieldName)

at MicroFour.StrataFrame.UI.Windows.Forms.BrowseDialogwindow.CreateListViewItem()

at MicroFour.StrataFrame.UI.Windows.Forms.BrowseDialogwindow.LoadBrowseResults()

at MicroFour.StrataFrame.UI.Windows.Forms.BrowseDialogwindow.ExecuteSearch()

at MicroFour.StrataFrame.UI.Windows.Forms.BrowseDialogwindow.ProcessCmdKey(Message& msg, Keys keyData)

at System.Windows.Forms.Control.ProcessCmdKey(Message& msg, Keys keyData)

at System.Windows.Forms.ContainerControl.ProcessCmdKey(Message& msg, Keys keyData)

at MicroFour.StrataFrame.UI.Windows.Forms.DateTimePicker.ProcessCmdKey(Message& msg, Keys keyData)

at System.Windows.Forms.Control.PreProcessMessage(Message& msg)

at System.Windows.Forms.Control.PreProcessControlMessageInternal(Control target, Message& msg)

at System.Windows.Forms.Application.ThreadContext.PreTranslateMessage(MSG& msg)


________________
_____/ Regards,
____/ al
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
No problem....I have a list of other things that you have requested that will most likely make it into a near point release as well. If you were using the override features this was a bit annoying....so it was higher on the list! Smile
Larry Caylor
Larry Caylor
StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)
Group: Awaiting Activation
Posts: 592, Visits: 3.7K
I downloaded and installed v_1.7.0.2 and it works great. I'd been setting all my view specific fields in code since I was never sure exactly what the designer was doing. Thanks for the fixBigGrin
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
OK, I have put SF 1.7.0.2 out in the My Account area and have made a few minor changes to the BrowseDialog. I may send out an email and post a news article later, but this should be ready to go. After you load the 1.7.0.2 build (I fixed some minor things to make life easier) then you will need to do the following to make this sample work. It uses the StrataFlix database, so make sure it is loaded. Once loaded, then execute this command on the StrataFlix database to create a view for this sample:



CREATE VIEW SampleBrowse

AS



SELECT

   MV.*,

   

   -- Get the top 1 cast member for the last name

   COALESCE(

   (

   SELECT TOP 1

      P.pl_LastName

   FROM MovieCast AS MC

      LEFT JOIN People AS P ON P.pl_pk = MC.mc_pl_pk

   WHERE MC.mc_mv_pk = MV.mv_pk

   Wink, '') AS CastLastName,

   

   -- Get the top 1 cast member for the first name

   COALESCE(

   (

   SELECT TOP 1

      P.pl_FirstName

   FROM MovieCast AS MC

      LEFT JOIN People AS P ON P.pl_pk = MC.mc_pl_pk

   WHERE MC.mc_mv_pk = MV.mv_pk

   Wink, '') AS CastFirstName

FROM Movies AS MV







Note: This query is not optimized so please don't post threads saying that the sample takes 10 seconds to being back a result set. I was not trying to create an optimized query, just one easy to understand without creating new indexes, etc.



After this is done, then the sample should work.

Attachments
CustomViewBrowseDialogSample.zip (152 views, 85.00 KB)
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search