Jeff Gerbracht

Ahhh, that makes sense based on what I'm seeing. In our case I want to use the start date of a project in a report and allow the person running the report to pick the project from a pic list. And as you see, different projects can have the same start date. So definitely not redundant in our case.

Below from pg_stat_activity (note I've been tweaking the order by to see if I can find some pattern, to no avail) UI still shows results different from the query response itself. SET application_name = 'ART - ro_ebird-sw2' select obs_begin_dt, description from cur.proj_period where proj_id like 'EBIRD_ATL%' and is_current = '1' order by 1

Something I'm a bit unclear about, do these LOV queries run every time the related report run screen is loaded ? Or are the results cached.

Something I'm a bit unclear about, do these LOV queries run every time the related report run screen is loaded ?

Running ART 4.16. I have several LOV dynamic reports which all query from a single postgres table. They query different values mapped to the same 'display' column. The issue only arises with the ones selecting from one of the twoa timestamp fields (obs_begin_dt and obs_end_dt). There are 8 rows which match the where clause but with the two timestamp based queries, only 6 rows appear in the parameter dropdown and they are not ordered by 'description' . Another oddity is that depending on the order...

I have several LOV dynamic reports which all query from a single postgres table. They query different values mapped to the same 'display' column. The issue only arises with the ones selecting from one of the twoa timestamp fields (obs_begin_dt and obs_end_dt). There are 8 rows which match the where clause but with the two timestamp based queries, only 6 rows appear in the parameter dropdown and they are not ordered by 'description' . Another oddity is that depending on the order by clause, a different...

Each job has a 'log' file. We're running ART in docker and I'd like to configure how and where these individual job logs are stored. I can't find anything in the documentation about these so I'm hoping someone here can tell me how these work.

https://sourceforge.net/p/art/wiki/Installing/ under Configure ART.