topic Re: Efficient Data Storage Method for Monthly Codes in Product Forum

Efficient Data Storage Method for Monthly Codes

sandeshtope — Wed, 20 Mar 2024 10:24:31 GMT

I'm seeking advice on structuring a data storage system for the last 6 months' worth of codes. Each code follows a consistent pattern: GOV followed by a number representing the month (e.g., GOV3, GOV2, GOV1, GOV12, GOV11, GOV10). What would be the most efficient method to organize and manage these codes as separate data items while ensuring easy access and retrieval?

Re: Efficient Data Storage Method for Monthly Codes

Daniel_Sanhueza — Wed, 20 Mar 2024 13:43:04 GMT

Hello Sandy!

I would have 6 Data Items named according to the month to be searched for;

[M-1]= Month -1
[M-2]= Month -2
[M-3]= Month -3

And so on... at the beggining of the process flow I'll put a Multicalc Stage that send the values to each Data Item with a simple function;

"GOV"&ToNumber(FormatDate(AddMonths(Today(); -1),"MM"))

And ensure that checkbok "hide from other pages in the process" is unchecked to make them Global so you can use those Data Items anywhere on the process flow.

Hope this helps

Re: Efficient Data Storage Method for Monthly Codes

LeonardoSQueiroz — Wed, 20 Mar 2024 14:13:35 GMT

Hello,

I have already been through a project with a similar requirement, because in our scenario we needed to consult both the complete value and just the code, what we did was create an auxiliary column that contained only the code, and a second column with the value suffix, according to the requirement we could have other suffixes, we abstracted the logic through a view in the Database (I don't know if this is your case), and we transposed the data to the collection later for reasons of performance and execution duration (high volume);

Regards