What exactly is the max length for filter on page?

sage · 2017-01-25

Hi,

I saw many topics about the max length of filter textbox on page, most of them said it is 1024 but I tested it and append input data with '|' character and can input more than 2000 character.

Anybody know what is the exactly length for input in this field?

Thank you.

zohaibu95@hotmail.com · 2017-01-25

@sage , as per my understanding you can input an infinite (unlimited) characters in the text box. But the actual thing is when you bind that textbox to the field or a variable of type 'text' it has a limitation of 250 characters.
So suppose you enter 2000 characters in a text box only 250 will be stored in that field/variable and rest will be discarded.

RockWithNAV · 2017-01-25

I believe if you go and deliberately declare the length of the variable then its 1024. If you want to save it in a Table field then it should be with 250 characters other you will have to trim it down. If you just want that variable to get it displayed on the screen without getting it saved anywhere then could be unlimited.

Kishorm · 2017-01-25

It's limited by the length of your text variable so if it's defined as Text (with no length) then it's "limited" to 2147483647 - so in reality we could say it unlimited. If you define a variable with a specific length then it's limited to that length.

Regarding the 1024 you've seen in many posts/topics - it used to be that this was the maximum length of a Text variable and it's only in recent versions of NAV (from 2013 inwards I think) that this limit has been removed.

What exactly is the max length for filter on page?

Answers

Categories