2 Search Pane for same row

antoniocib

It seems strange but it is not, I try to be as clear as possible I need to use the same panes for the same column but only using the if condition I have to sort the data

Eg:

searchPanes:{
columns:[5,3,2 ]
option:[ if (rowData[5] == "Vercelli"){
.draw(); } ]
},

kthorngren

Can you build a simple example representing what you want to do?

Kevin

antoniocib

Kevin if u want i can do a photo, example is impossible cause idk how to do this,okay?

sandy

Hi @antoniocib,

It sounds like you want to implement SearchPanes with custom options. Take a look at this example showing how to set a variety of different custom options.

Take a look at this page for more details on how to set these up.

If this is not what you are after then a photo would be great to try and understand the problem further.

Hope this helps,
Sandy

antoniocib

its same man!

antoniocib

http://damoratraffico.netsons.org/webing/scrivania1.html

@kthorngren and @sandy look this doesnt work, where i wrong

kthorngren

Looks like you have a few issues.

1. You have targets: [5] twice in columnDefs with both having the option searchPanes. Only one will be used the others are duplicates and will be dropped. The second set you have will not be used.
2. You have object based data using columns.data but you are trying to access the row data using array syntax. Instead of this:

                       {
                            label: 'VERCELLI',
                            value: function(rowData, rowIdx){
                                return rowData[5] == 'VERCELLI';
                            }
                        },

You need to use this:

                       {
                            label: 'VERCELLI',
                            value: function(rowData, rowIdx){
                                return rowData.scarico == 'VERCELLI';
                            }
                        },

1. The columns.searchPanes.options in the second searchPanes is not correct as it expects label/value pairs as shown in the docs.

Kevin

antoniocib

Kevin, i need to see the panes with same column how to do?
Btw works ur way for the first problem.

kthorngren

So you want two search panes for one column?

I don't know of a builtin way to do this. @sandy my be able to provide some options. The only option I can think of is to create a second scarico column and use columns.visible to hide the column. For the second pane use the hidden column.

Kevin

antoniocib

i thinks is the right way this.. i try it, can u do let me a example in live.datatables?

antoniocib

        {
                visible: false,
            "data": "scarico"
        },
        {
            data: null, render: function ( data, type, row ) {
            return data.scarico+' '+data.scarico_m;
        },
        {
            visible: false,
            "data": "scarico_m"
        },

i used this way but doesnt work

kthorngren

Here you go:
http://live.datatables.net/luwafeqi/1/edit

Kevin

antoniocib

Ty kevin, works, u r the best as always,now I need to do another thing, i need to change the count column in the pane,so i want to change in with data in my column (EPAL,IND,PERD) can i do this?

Attack the photo :

kthorngren

Are you talking about the Cascade Panes feature?

Kevin

antoniocib

Mh,no Kevin, the count of column in the searchpane i want to change with my data

antoniocib

same:

searchpane:{
countColumn: function(row, data){
return data.epal, data.ind, data.perd
}
}

i improvise the code..

sandy

So you want two search panes for one column?

You are correct Kevin - there is not built in way to do this. We couldn't see why you would need to have two panes for the same column as the functionality would be exactly the same, only taking up more real estate on the page. I would say that if for some reason you want to have two panes for the same column where SearchPanes generates the options then the solution you have given is probably best. If you are going to be adding custom options however, I would suggest that you make use of the documentation I linked above. This will remove the need to duplicate the column and hide it.

i need to change the count column in the pane

I think from what I am seeing in the picture you want to change the count column to display the totals of the cells in red, is that correct?

Thanks,
Sandy

antoniocib

yes @sandy

antoniocib

For the question 2 serchpanes for the same column i create this:

    {
            "data": "scarico",
                visible: false,
        },
        {
            data: null, render: function ( data, type, row ) {
            return data.scarico+' '+data.scarico_m;
         }},
    {
            "data": "scarico_m",
            visible: false,
        },

and

searchPanes:{
columns:[5,7]
},

sandy

No, I'm afraid you can't do that when it comes to the count column.

antoniocib

mhh, so i need to create a mini table with column 5 and column 7, can u help me?

antoniocib

@kthorngren Kevin ii think only u can help me, i have this 2 query

select scarico, sum(epal + perd), Sum(ind) From scrivania1 where dlinea !==" " GROUP BY scarico

select scarico_m, sum(epal + perd), Sum(ind) From scrivania1 where dlinea !== " " GROUP BY scarico_m

and i need to stamp this in a mini table in a page where already exist the complete table with all data in