June 10, 2008, 09:40 AM
TravMeasure loader problem/limitation with filters
I ran into a sort of strange problem today while loading a measure that had a filter on it. I could apply the filter, preview it and it would look fine -- but when I hit the "load" button, it wouldn't work. No error, no message that the load completed, nothing.
I also noticed on these same measures that each time I went back into the measure loader screen, part of the filter value had been truncated. I finally realized that it was cutting off the filter value after 25 characters and that was what was causing my loading problems also.
A couple of questions on this:
- I'm assuming there actually is a real limit at 25 characters?
- If so, can we get that extended?
- Can we also get the error trapping to be a little more robust on this screen so that it will either warn me, not allow me to save and/or preview, or something?
Obviously, I can log a case on this if you think that's the best course of action -- just wanted to pose it here first since the behavior was a little odd.
June 10, 2008, 05:46 PM
Michael PaulHi Trav,
Thanks for notifying us of this limitation. This has been changed in PMF for version 421 going forward. You will now be able to input 254 characters in the value field.
As an alternate workaround you could change the "Source" drop down to "Code" and in the Edit text you can reference columns in the measures master file and the length of this can be extremely large (1024A). Just use the syntax "WHERE FIELD_NAME EQ 'FIELD_VALUE'" in the Edit field. I would probably recommend this when the field value becomes very large as you can view the entire contents better.
Let me know if this helps.
Mike