[SOLVED] Quicksearch in Forms / Grids

Scriptcase 7 Bugs
#1

Hi,

i have a form (show single record) with tabs. In one tab is a grid with quicksearch enabled. The quicksearch field is not shown (header is enabled) …

In another tab is a form (editable grid view) also with quicksearch field. The quicksearch field appears, but the search result is totally wrong. The where clause from the editable grid view is not observed! Only the searchterm from the quicksearch field (search in all fields) … Result: records are displayed, that not belong to the master record!

Grid and form (editable grid view) not in tabs works as expected.

#2

Hello,

Please contact our support regarding this issue. Our chat is active on workdays from 8:00am to 6:00pm, and our ticket system is always available.

regards,
Bernhard Bernsmann

#3

Excuse me Bernhard, but your support ist slow and often not answering …

You can easy reproduce the bug in SC 7 within 5 minutes: create a form (single record view) with 2 tabs and link a grid / form as detail as posted in my first post. You can’t see the quicksearch field on the tab grid and the where clause (where clause for master to detail link) is not observed on the tab form when used the quicksearch field!

#4

The wrong where clause generated by scriptcase:


SELECT  top 20 Nummer, Mandant, Adresse, Ansprechpartner, Telefon, Telefax, EMail, Mobilfunk from dbo.KHKAnsprechpartner where (Mandant = 1 AND Adresse = 507)  and Ansprechpartner like '%scriptcase%' or Telefon like '%scriptcase%' or Telefax like '%scriptcase%' or EMail like '%scriptcase%' or Mobilfunk like '%scriptcase%' order by Nummer

The correct clause:


SELECT  top 20 Nummer, Mandant, Adresse, Ansprechpartner, Telefon, Telefax, EMail, Mobilfunk from dbo.KHKAnsprechpartner where (Mandant = 1 AND Adresse = 507)  and (Ansprechpartner like '%scriptcase%' or Telefon like '%scriptcase%' or Telefax like '%scriptcase%' or EMail like '%scriptcase%' or Mobilfunk like '%scriptcase%') order by Nummer

(Brackets missing before “Ansprechpartner” and after “or Mobilfunk like ‘%scriptcase%’”)

#5

Hello Reinhard,

Issue reported to our bugs team. Although I strongly believe you may find a solution faster by getting in touch with our support.

regards,
Bernhard Bernsmann

#6

Hi Bernhard,

thank you!

And the problem that quicksearch field is not display on grids in tabs? “Feature” or bug?

#7

Hello Reinhard,

That is actually the default behavior of Detail applications. Almost everything from the toolbar isn’t displayed.

regards,
Bernhard Bernsmann

#8

Hi Bernhard,

unfortunately … actually is not unusual that you would search in a detailed grid. For example although many contacts exist in a company. It would therefore already attached when the quick search also works in detail.

Thank you.

#9

[QUOTE=RHS;13071]Hi Bernhard,

unfortunately … actually is not unusual that you would search in a detailed grid. For example although many contacts exist in a company. It would therefore already attached when the quick search also works in detail.

Thank you.[/QUOTE]

Hello,

Some of our users have sent as a suggestion that the toolbar should keep all items (or most of it) on a detail application. Our development team is analyzing the suggestion.

regards,
Bernhard Bernsmann

#10

Search-Problem not solved in SC v7.0.006

#11

Hello Reinhard,

As I mentioned before, that is the actual default behavior of detail applications. It isn’t a bug, it is just how detail applications were designed.

regards,
Bernhard Bernsmann

#12

No Bernhard, look at post #4, the generated sql code is wrong (missing brackets). This is a bug, not a design feature …

#13

Hello Reinhard,

Just to keep you updated, I’m reviewing the issue you posted. I had confused with another problem, sorry about that.

regards,
Bernhard Bernsmann

#14

Hello Reinhard,

Just to keep you updated, I’m reviewing the issue with our bugs team.

regards,
Bernhard Bernsmann

#15

SC 7.00.0013 - not solved

#16

Fixed with 7.00.0015, Thanks!

#17

Hello Reinhard,

Thanks also!

regards,
Bernhard Bernsmann

#18

Quick Search in grid (detail applications): do you have here something else in development in the meantime?

#19

Reminder …

#20

Reinhard,

I will get in touch with our bugs team.

Thanks,
Bernhard