metafresh logo and link to homepage

IT FRESH-280

Period sorting in all Dropdowns where uses year-month numeric

Testcase to check if the period sorting is the same in all dropdowns where year-month numeric is used.

  1. To find all windows where the year-month numeric is used, use the following query (e.g. in PgAdmin):
select t.name as tablename,tab.name as tabname,w.name as windowname, ad_reference_value_id, c.* from ad_column c
join ad_table t ON t.ad_table_id = c.ad_table_id
join ad_tab tab on tab.ad_table_id = t.ad_table_id
join ad_window w on w.ad_window_id = tab.ad_window_id
left join AD_Reference r ON r.AD_Reference_ID=c.ad_reference_value_id       
where c.AD_Element_ID=206 and c.isactive='Y' 
  1. To find all reports where the year-month numeric is used, use the following query (e.g. in PgAdmin):
select p.name,ad_reference_value_id, pp.* from ad_process_para pp
join ad_process p ON p.ad_process_id = pp.ad_process_id
left join AD_Reference r ON r.AD_Reference_ID=pp.ad_reference_value_id        
where AD_Element_ID=206 and p.isactive='Y'
=> AD_Element_ID=206 = period sorting is used!
=> the query will also give the specific tab / subtab of the window where period sorting is used
  1. Open all the windows, one after one

  2. In the respective window (or tab), search for period

  3. Open all reports, one after one

  4. Check the filter for period

  5. If there is a filter for year, set that (e.g. 2015)

  6. Check the filter for period again

  7. Note: for some reports / windows, you can only search for the periods of existing data!

  8. Also note: you can have different calendars for the same year (e.g. for accounting), so you will be able to select the year for each calendar!

  9. If there are different calendars for the same year, you can select the periods for each one:


Zur Quelldatei auf github.com