search on a grid question

[Anis]

Re: search on a grid question

This page gets called from a link field on a summary page.
in the screen shot if press DETAILS it calls the records of the grid.

[NoeticCC]

Re: search on a grid question

This page gets called from a link field on a summary page.
in the screen shot if press DETAILS it calls the records of the grid.

I suspect in that case that the characters in the URL are coming from the link - can you post the code used to generate the Details link, and the full URL of the same account grid (once you clicked on the link) for both the server & the other machine you are testing this on? (I can't see the whole URL on the screenshots you posted)

If security has been enabled on the server since you first made this, have you

a) Enabled proper access to both pages (e.g. set security permissions & are logged in correctly on both machines)

and

b) Published the whole project again?

[Anis]

Re: search on a grid question

Security is not active on this one, and I deleted all the published files and re-published just in case.

I attached a sample of the database including web projects.

Thanks for all the help

[NoeticCC]

Re: search on a grid question

I will try this out later on, thanks for posting the sample.

[NoeticCC]

Re: search on a grid question

Hm... tried this now but to be honest I can't see how these tables even relate do each other - the field from the summary table that you use as a filter of the detail page doesn't have any matching fields in the other two tables:

[Anis]

Re: search on a grid question

There's a summary operation that creates that field in the month summary table. It's the last field

[NoeticCC]

Re: search on a grid question

There's a summary operation that creates that field in the month summary table. It's the last field

1) At least in your sample, the last field in the summary table is nothing like any field in the other two tables (see screenshots 1 & 2/3)

2) The field you are filtering the detail grid by does not appear in the search fields in the detail grid component! (screenshot 4)

[Anis]

Re: search on a grid question

Because I built only a sample of the database for posting, I didn't run the summary operation which creates the matching field (Key) in the detailed.

here's the corrected one.
In any case if I use only the detailed page it acts the same way without considering the link.
If you publish and try to search for exchange from the detailed web page, do you get the results that I see ?

[NoeticCC]

Re: search on a grid question

Because I built only a sample of the database for posting, I didn't run the summary operation which creates the matching field (Key) in the detailed.

Thanks for that - I should have realised that! I think I can see what the problem is, although I have no idea why it works on the server in the first place! I bet if you add the key field to the search on the detail page, and pass in the key as an argument instead of trying to tack on a filter from the link on the summary page, it will work...

[NoeticCC]

Re: search on a grid question

OK I have tried this now - it seems to work fine: http://www.charlesworth.biz/SAMP/comm_summary.a5w

But I can see how the way the filter is used in the link on the summary page could cause some problems - I presume that when the "Has Filter?" option is used, then Alpha 5 expects the target page to HAVE a filter - which it doesn't.

If you *must* use a filter - as opposed to adding Key to the searchable fields (this would also allow you to make sure that users are aware of the fact that the details they are viewing are filtered, and it allows Clear Search to REALLY clear the search, too), try adding an argument called Key to the data source definition on the Detail Grid and then build a filter like this: "Key=:Key .or. Len(:Key) =0".

A more user friendly way of filtering the details page (if you had a read only display of just one account/entry, a filter would be great, but this is a grid with a search of its own you are linking to) would be to add Month, Year and Account to the search fields of the Detail page, and then instead of using Has Filter in the detail link, use Has Variables and specify the variables in the same way they show up in the URL if you search for them in the Details grid, e.g. comm_detail_S_MTH and comm_detail_S_YEAR for month and year.

This makes it explicitly clear to the user that the detail view they are seeing is filtered by Account A, Month X and Year Y :)

[NoeticCC]

Re: search on a grid question

OK here a sample site that allows the user to filter both the summary and the detail grid by year, account & month, uses these 3 in the link to the Detail grid and displays what has been filtered by in the search of the grid on the detail grid page:
http://www.charlesworth.biz/EDITED/comm_summary.a5w

Instead of having to rely on a summary function, it uses a calculated field that uses the month & year in both the summary and detail tables - this is used in the search fields on both pages, and also used to "filter" the detail grid in the link on the summary page.

I have attached the modified zipped database for reference, to explain the way I set up the searches etc.

[Anis]

Re: search on a grid question

I will download and learn from this, apparently it works fine from your page link.
Thank you so much for the time you spent on this, greatly appreciated.

[NoeticCC]

Re: search on a grid question

I will download and learn from this, apparently it works fine from your page link.
Thank you so much for the time you spent on this, greatly appreciated.

Glad to see it worked fine when you looked at it, having a bit of a problem trying to get two projects (SAMP and SAMP_EDITED) to run without security on our WAS which has security enabled, so hopefully the sample DB I uploaded will be enough - I don't know if both links I posted will work!

I hope the sample DB is easy to understand, I am starting to look into filtering results in grid a bit more myself & am sure I will run into similar odd results!

[Anis]

Re: search on a grid question

One of your postings didn't work because of security issues, the second one did.

Now the only issue I saw in the edited sample that the detailed page needs to have a search on the date not on the calculated date (YEAR and MONTH).
The summary is fine because you need ACCT, YEAR and MONTH.

The detailed page needs 2 search keys... EXCH and DATE THAT INCLUDES THE DAY.
So I'm just going to use the correct date field to replace the calculated date that you have.
Do you see a problem with that ?

[Anis]

Re: search on a grid question

I see you just hid the row of that search key (date.)
It works great. Thanks again