need help to read the data Quarter wise from year qvd.

Raya — Thu, 06 Mar 2025 18:55:59 GMT

Hi Experts,

I looking for a help on one of the Requirement. As of now I have one year of data in my qvd Jan24 to till date.

due to huge volume of data we are implementing Document chaining where 4 apps having quarter wise data.

extractor will run daily and takes only updated records and getting appended on the history qvd.

i need some assistance how to keep condition in where class in app so that only specific quarter data will be loaded into app dynamically on daily apps refreshed like below

jan25-mar25 -- first app

dec24- oct24 -- second app

jul24- sep24 -- third app

apr24- jun24 -- fourth app.

Regards,

khadar

Re: need help to read the data Quarter wise from year qvd.

Ben_P — Fri, 07 Mar 2025 10:57:53 GMT

It depends on where your data is coming from. If you have one year of historic data in your QVD, plus new records from some other data source, then I'd say something like the below might be a good approach:

1) load from QVD where date>=jan25 and <=mar25.

2) append 'new' records from your other data source where date>=jan25 and <=mar25 and not exists(date) ... i.e. the data is in the required range but does not already exist in data loaded from the QVD.

3) store the combined table of historic+new data back to QVD.

topic need help to read the data Quarter wise from year qvd. in App Development

need help to read the data Quarter wise from year qvd.

Re: need help to read the data Quarter wise from year qvd.