Where is search on Ubuntu Software Center?

Question

I wrote a stored procedure for getting the count from a column but when I execute the procedure its returning a date value. While separate query execution returns the required result set.

ALTER PROCEDURE [dbo].[USP_ViewAdminDashBoard](@LoginUser varchar(75)) 
AS 
BEGIN 

    DECLARE @LastLoginDate  as DateTime 

    Select  @LastLoginDate = dbo.UDF_GetLastLoginByUser(@LoginUser);

    Select  'Last Login Date', @LastLoginDate 
    Union
    Select  'No. Active Business Associates' as Title, COUNT(isActive) Total 
    from    (select 1)d(isActive)
    where   isActive = 1 
  Union Select 'New Registration Today' as Title, COUNT(1) Total from dbo.TBL_iREGFORM     where isActive = 1 And GETDATE()>= RegDate
 Union Select 'Registration Pending for Verification' as Title, COUNT(1) Total from dbo.TBL_iREGFORM where isActive = 1 and isVerified = 1
END

Solution 1

Gary Lasker from Canoical contacted me through launchpad. He asked me to run Ubuntu Software Center from a terminal using the command line.

⋯$ software-center

I did that and the search box is back. There were no updates in the interim so it possibly was a one time thing (so far).

Thanks to Gary for getting back to me quickly!

Solution 2

Ubuntu 20.04 LTS

The Search textbox is hidden by default, it is automatically displayed when typing.

Solution 3

Maybe this answer is just silly, but it is not just the case that the window is not big enough to show the Search textbox? If i resize my window to that size, the Search disappears because there's no space to it be shown.

Comments

[Yaqub Ahmad]

Can you provide your actual query?

[joshua]

Sorry For Formatting ...

[r0101]

That is not the case on my 11.10 system. There is a limit to how narrow we can make the window and it still has the search panel.

[geethujoseph]

I have 11.10 too (Ambiance theme) and when i resize it to the minimum size allowed, the Search bar dissapears: goo.gl/wmva2

[keepitsimpleengineer]

I didn't change it from it's default size when it opened, pretty much filled the small laptop screen.

[Adam Wenger]

There isn't much anyone will be able to tell you without being able to see the query.

[joshua]

thanks for help pal.i need to type cast every single select query.or go with two different select..

[nathan_jr]

yep, the date value you are seeing is your integer from the count cast as a date. (int)0 = (datetime)1900-01-00

[0x6A75616E]

@Cams this is a usability failure on Ubuntu's side. Don't feel stupid.

[Ciro Santilli OurBigBook.com]

Bad UI design .

[Noone AtAll]

for f sake this is idiotic

[Braian Coronel]

I agree, it is not an intuitive UX.

[Deepak Gautam]

You're right. Search bar appears as I start typing.