how can i link a filter to a grid?

Applications Grid / Reports
#1

Hi,

i want to create a filter which is linked to a grid with all results, but this is not possible… i am just able to link it to a form.
in the form i can click the arrows to navigate to the other datasets, but it would be better if i could see it in a grid…

is that possible?

thanks a lot,

mati

#2

Re: how can i link a filter to a grid?

Not sure I follow.

You want to call a filter app using link from a grid app… and have the grid display the results?
Is the filter that is built into the grid not working as needed?

Can you be more detailed?

Regards,
Scott

#3

Re: how can i link a filter to a grid?

Hi Scott,

thank you for your quick reply.

I have a filter and i want to view the results of the performed filter in a grid, not in a form.

i have linked the filter-application to a form-application so i can view all results in my form and navigate from one to another with the arrows…

i’d like to have the results shown in a grid, so i have a quick overview forthe datasets matching my filter.

but its not possible to link a filterapplication to a grid. only forms are working…

do you understand what my problem is?

thanks a lot,

Mati

#4

Re: how can i link a filter to a grid?

Hi Mati,

you can use check boxes from Grid to Forms after filtering records and by using sc_redir() you can jump to form for specific record in detail, refer the below link

http://scriptcase.net/phpgenerator/samples/tutoriais/grid/grid44.php

Regards
Dhana

#5

Re: how can i link a filter to a grid?

Do you that grid applications already has filter?
Just create an Grid application, set the filter as the initial module and link the grid with a form.

You’ll have a filter -> grid -> form

#6

Re: how can i link a filter to a grid?

Thanks guys for your answer.

diogo helped me the most, because i didnt know, that a search is built-in in grids :slight_smile:

so thanks a lot.

Mati

#7

Re: how can i link a filter to a grid?

Filter application was made specifically to filter form datas, since grid already has search :slight_smile:

#8

Re: how can i link a filter to a grid?

Hi,
I think I have a smilar problem but I couldn’t get it :confused:

I want to link 2 grids.

for example: there are two grids. 1) users 2) user’s friends.
at the grid_users, each row shoud have a user’s friends field that has “show the user’s friends” link.
when clicked to the link, grid_user’s friends list will list the friends of the user.

but I can’t pass the user id parameter and filter user’s friends due to that.

thanks.

#9

Re: how can i link a filter to a grid?

kiminkibu ,
It can be done…! create sc_link in the main gird of OnRecord event, with parameter…!

sc_link(Mom_code, form_mom_master_read,v_momcode={MOM_code};v_username=[v_username], 'Preview this Record, ‘_parent’);

regards
Dhana

#10

Re: how can i link a filter to a grid?

Or you can use nested grid …
or you can use a join to to everything in one SQL … and use group by.

there a lot of examples:
http://www.scriptcase.net/phpgenerator/basesamples/basesamples.php

check the topic Group By, Sum and Resume
and check the topic Link - Nested grids using treeview

#11

Re: how can i link a filter to a grid?

thanks so much for the help.
I did with sc_link and I’m gonna check the rest soon.
thanks again.