Hi,
Thank you all for your replies. I am using 64-bit Windows 10 and Microsoft Edge
browser. I have done some more tests and came into conclusion the download
button only works when I use less than 4 aliases in the query. If there are
more then 4 aliases in the query the button won’t work. I enclose the example
of a simple query, it doesn’t matter which aliases of the 5 below I use but it
will only accept 3 aliases. Hope that makes sense.
SELECT ins.insurer,
ib.branch,
ib.ins_br_index,
fe.invoice_total,
fe.fee_date,
fe.unpaid_amount,
CASE
WHEN ('now'::text::date::timestamp without time zone - fe.fee_date)
<= '30 days'::interval THEN fe.unpaid_amount
ELSE 0::numeric
END AS c30,
CASE
WHEN ('now'::text::date::timestamp without time zone - fe.fee_date)
>= '31 days'::interval AND ('now'::text::date::timestamp without time zone -
fe.fee_date) <= '60 days'::interval THEN fe.unpaid_amount
ELSE 0::numeric
END AS c60,
CASE
WHEN ('now'::text::date::timestamp without time zone - fe.fee_date)
>= '61 days'::interval AND ('now'::text::date::timestamp without time zone -
fe.fee_date) <= '90 days'::interval THEN fe.unpaid_amount
ELSE 0::numeric
END AS c90,
CASE
WHEN ('now'::text::date::timestamp without time zone - fe.fee_date)
>= '91 days'::interval AND ('now'::text::date::timestamp without time zone -
fe.fee_date) <= '120 days'::interval THEN fe.unpaid_amount
ELSE 0::numeric
END AS c120,
CASE
WHEN ('now'::text::date::timestamp without time zone - fe.fee_date)
> '120 days'::interval THEN fe.unpaid_amount
ELSE 0::numeric
END AS c120plus
FROM fee fe,
claim cl,
insurer ins,
insurerbranch ib
WHERE cl.claim_ref::text = fe.claim_ref::text AND ib.ins_br_index =
cl.ins_br_index AND ins.ins_index = ib.ins_index AND fe.fee_type = 'I'::bpchar
AND fe.fee_status = 1
And ins.ins_index=82
ORDER BY ib.ins_br_index;
Regards
Ela Mytko
Woodgate and Clark Limited
Tel: 01732 520281
Email: [email protected]<mailto:[email protected]>
Web: www.woodgate-clark.co.uk<http://www.woodgate-clark.co.uk/>
From: Calle Hedberg <[email protected]>
Sent: 02 March 2019 13:03
To: Akshay Joshi <[email protected]>
Cc: Elizabeth Mytko <[email protected]>;
[email protected]
Subject: Re: pgAdmin Download as CSV
Elizabeth,
You must be doing something wrong, or else your computer has an incorrect
configuration of some sort.
I'm importing and exporting from/to CSV several times a day, and it has
generally always worked (exceptions are cases where the CSV file to be imported
contains e.g. non-UTF8 characters).
I run any select query and then press the download icon - and the query result
downloads with a file name like "data_xxxxxxxx.csv" where xxxxx is some random
number. Using windows 10-64, latest Chrome
Regards
Calle
On Sat, 2 Mar 2019 at 11:07, Akshay Joshi
<[email protected]<mailto:[email protected]>> wrote:
Hi Elizabeth
I have tried with pgAdmin4 v4.2 and able to download the query result. Please
refer the attached screenshots. Can you please provide following information:
* Browser and their version
* Any error in browser when click on download button? Please attached the
screenshot.
On Sat, Mar 2, 2019 at 6:06 AM Elizabeth Mytko
<[email protected]<mailto:[email protected]>> wrote:
Hi,
It seems the Download as CSV button doesn’t work anymore for the last few
versions. I upgraded from version 3.3 (didn’t work here) to version 4.2 and it
still doesn’t work. It used to work before version 3.3 and downloaded the
current query results to the c:\Downloads folder which was very handy. Just to
clarify it works for the table list but not for a query results. Not sure if I
am doing something wrong?
Regards
Ela Mytko
Woodgate and Clark Limited
Tel: 01732 520281
Email: [email protected]<mailto:[email protected]>
Web: www.woodgate-clark.co.uk<http://www.woodgate-clark.co.uk/>
Woodgate and Clark Limited, Registered Office, The Red House, King Street, West
Malling, Kent, ME19 6QT No. 02090698 England.
This message is sent in confidence for the addressee only. It may contain
confidential or sensitive information. The contents are not to be disclosed to
anyone other than the addressee. Unauthorised recipients are requested to
preserve this confidentiality and to advise us of any errors in transmission.
Thank you.
Our privacy policy is available at
www.woodgate-clark.co.uk<https://www.woodgate-clark.co.uk/privacy-policy/>
--
Akshay Joshi
Sr. Software Architect
[Image removed by sender.]
Phone: +91 20-3058-9517
Mobile: +91 976-788-8246
--
Carl-Anders (Calle) Hedberg
HISP
Researcher & Technical Specialist
Health Information Systems Programme – South Africa
Cell: +47 41461011 (Norway)
Iridium SatPhone: +8816-315-19119 (usually OFF)
E-mail1: [email protected]<mailto:[email protected]>
E-mail2: [email protected]<mailto:[email protected]>
Skype: calle_hedberg
