I’m looking for a way to filter the View of Submission Register to only show the latest revision. My original submission register will have every detail but for this view, i wanted the user to only see the latest revision and it related info.
See also: first(), last(), nth(), find(), created(), modified(), sort(), and maybe others that might be useful here.
In one way or another, the revisions must have metadata by which logic can conclude which is the most recent version, however you define that. There are multiple ways to do this, each with its own pros and cons (text string coding in the revision abbreviation, date, numeric value, array order, etc).
@Ander Thanks man. Could you elaborate a little on this requirement to manage it manually in a few sentences or outline it even in a few points how do you see that? I’ve got stuck a little when was working on that lately.
@Kris_Murawski I just made a more thorough pass through all the formulas in your doc, and realize that I was addressing a different problem than the one you’re solving for (above reply edited accordingly).
That said, my thoughts on manual management of ordering wouldn’t apply to your technique of allowing the user the option to manually adjust ordering by dragging rows into desired positions when needed.
Hi @Ander, i think i get your point. Probably need to use different type of indexing and sorting method to rank which revision is higher than the other.
@Kris_Murawski, the WF no is a unique number and won’t be repeated.
FYI in my case, normal revision number [00,01,02] applied to a typical document/report, while the one with [P00,P01,W01,W02] is used specifically for drawing.
Thanks guys for your ideas, i’ll try to experiment with it first then if solved i will posted it in this thread.