Hello,
Amos Bird <amosb...@gmail.com> writes:
>> - what are you trying to export?
>
> an Org table like this:
>
>
> | QueryID | SQL Text
>
> | Query Time (Seconds) | Query Time
> Hot (Seconds) |
> |---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+--------------------------|
> | Q0 | SELECT cab_type, count(*) FROM trips_log GROUP BY cab_type;
>
> | 10.14 |
> 11.57 |
> | Q1 | SELECT passenger_count, avg(total_amount) FROM trips_log GROUP BY
> passenger_count;
> | 12.00 |
> 6.27 |
> | Q2 | SELECT passenger_count, toYear(pickup_datetime) AS year, count(*)
> FROM trips_log GROUP BY passenger_count, year;
> | 10.45 |
> 7.23 |
> | Q3 | SELECT passenger_count, toYear(pickup_datetime) AS year,
> round(trip_distance) AS distance, count(*) FROM trips_log GROUP BY
> passenger_count, year, distance ORDER BY year, count(*) DESC; |
> 13.03 | 10.80 |
OK.
>> - to what back-end?
>
> ODT and HTML
OK.
>> - what is the exact problem?
>
> I'd like to export this table with *:nil ^:nil options while exporting other
> subtrees with *:t ^:t.
This is not my question. You are explaining me how you are trying to
proceed. I want to know what it the problem you are trying to solve.
Anyway, it seems you are conflating fontification in the Org buffer and
export. I guess there is no issue related to export in this thread.
> I tried surrounding the table with example block and src block but
> both look bad after exportation.
Of course. I didn't know you were exporting an Org table.
However, you could add verbatim markup
=SELECT cab_type, count(*) FROM trips_log GROUP BY cab_type;=
but, again, since I don't know exactly what the issue is, I may be wide
of the mark.
> characters when exporting.
I never suggested that.
> I also tried changing _ to \under{} and * to \asc{} but it doesn't look well
> in the Org buffer.
>
> I did turn on org-toggle-pretty-entities but it changes the appearance
> of other subtrees which I don't want to.
Maybe Org mode is not the appropriate mode for the task?
Regards,
--
Nicolas Goaziou
