Get search results of occurrences

Hi,

thanks for your question, and sorry for the trouble.

I see what you mean, but I don’t have plans to extend the Row Filter Extension for this. I also don’t think that this is needed by very many people, so that using a custom solution is probably better.

For the Chartist Extension: That was not developed by me, so I can’t help with that, I’m afraid. You should get in touch with Per, its developer, for questions.

Yes, I do have plans to show better documentation and live previews of the Extensions. It’s mainly just an issue of finding time, as this is just a hobby for me.

Regards,
Tobias

Hello, Tobias.
I was happy with the speed of their response.

I wonder if I can help in any way to the development of the live preview site. If you need to be here to collaborate.

As for my question, I’m sorry to hear that there is a solution right now.

My project:
My State where I live in Brazil (Pernambuco – Brazil). has had high crime rates. And there is a report every 15 days, provided by PDF, in state security secretariat with valuable information. So I became the PDF Excel XML and use successfully.

I believe that the contribution of my project will help the police and the government, and the public to understand the cities with the most critical points, finding the best solution to the problem, through my information, my project.

Because I asked you that?
Because each row is a death. And the columns specify the types of death, types of weapons, day of week, etc.
Exemplo:
03.10.2015 | Maria José da Silva | Murder | Gun | Monday | Female

Thus, with each line, I can say through searches, how many deaths there were in a city and if male or female. As each row is an instance, the result of occurrence is the total value of the events.

Deaths in the city: Recife
23 Male
10 Female.

How am I becoming?
I changed the string by placing a <span> in the result. <span> _TOTAL_ </ span>

And I added this in CSS:

.box_numero  .dataTables_paginate.paging_simple, .box_numero .dataTables_length, .box_numero .dataTables_filter,.box_numero div#tablepress-5_length, .box_numero .dataTables_wrapper .tablepress{
display:none!important;
}
.box_numero .dataTables_info{
visibility:hidden;
}
.box_numero span{
visibility: visible!important;
font-size: 61px;
font-weight: 100;
letter-spacing: -0.07em;
margin: 0px 59px;
text-align: center!important;
}

<div class=”box_numero”>[table id=5 filter=”Recife&&FEM”]Homicide</div>

Then he gives me a unique result for each line without entering sums within the table, since I update constantly.

There is no way to show you the project now because it is messy, but I promise to show you when you are ready.

If you’ve got a way to at least do it in a simplified way I would appreciate it too.

At least a simple way to show _total_ of my searches.

What do you think of my project? When you are ready I will be mentioning you in a page for all the Brazilian State know that you are the author of the wonderful plugin.

Hugs and once again congratulations for the plugin.

Hi,

thanks for the detailed explanation. I see what you are trying to do, and this is a really nice idea for a project!

Unfortunately, I can’t really think of a good and quick way to do this with TablePress ?? The way how the Row Filter Extension works is that it removes all rows that don’t match the filter from the result set. However, at no time does it deal with the number of rows in that set, and therefore, there’s no direct way to print the number of results ??

I think you should consider a custom PHP/mySQL solution, with a database table, here. There, you can use mySQL queries to retrieve the statistics that you want. TablePress can’t really do this, because this is far outside of the scope of the plugin.

Regards,
Tobias

Hello again, Tobias.

As impossible as it may seem, by the previous example I showed you I get successful results, and believe not need to leave the plugin scope.

I understand that I could use other ways how to create multiple tables to get the desired result. However, I need at least 10 results for each 185 cities. That is, 1,850 tables. The way I explained above, I can get what I quoted, creating only one table.

As I do not want to create graphics on these results, and only the number of occurrences, I will follow my work successfully. Soon show you how it’s getting. ??

If at any time think of a different idea of mine, please let me know.

Once again thank you!

Hi,

yes, but you are using the DataTables JS library here, to show the _TOTAL_ result, from what I can see.
What I meant is that I don’t know a way to do this without that JS library.

And with a custom PHP/mySQL solution, you could still have everything in one big mySQL table. You would simply have to adjust the SQL query.

Regards,
Tobias

Yes. I used the data from the DataTable JS library.

I’m sorry if I left you upset. I thought they had other ways to work with the results _total_ in a [shortcode]

My insistence happened for wanting to facilitate the work to make my big project

Hugs and thanks for listening ;).

Hi,

oh, no worries ??
Yes, it would be great if the Row Filtering Extension would be more powerful, and if it could return something like _TOTAL_ as well, but unfortunately, it’s simply just very basic and does not have features like this ??

Regards,
Tobias

I’m finding a solution:

Is there any way to insert a css class within a shortcode to affect the entire table, or something?

Example:
[table id=123 style_table=”.mystyle”]

???

Hi,

yes:

[table id=123 extra_css_classes="mystyle" /]

Regards,
Tobias