Number of Grid Rows displayed on E1 8.11 SP1

Do anyone know how to the change the number of rid rows on any 8.11 SP1 Find/Browse screen? Default set up is 10 records at a time. How about change it to 20? I could not find it!

Many Thanks.

It is in your JAS.INI - it is the GlobalPageSize. Set it to the number of rows you want in the grid.

Thank you for your reply. But I couldn't find it in my JAS.ini


#=======================================================================
# jdbj.ini - JDBj configuration
#
# This file contains configuration information for JDBj, which provides
# general database access capabilities on behalf of J.D. Edwards Java
# solutions.
#=======================================================================

#=======================================================================
# OneWorld specific information
#
# These sections apply only when accessing OneWorld data. These
# sections are ignored for standalone database access.
#=======================================================================

#-----------------------------------------------------------------------
# Bootstrap session
#
# This information is used to sign on to provide access to system
# tables. JDBj signs this user on via the security server at bootstrap-
# time, so if it is not valid, then no OneWorld database access is
# possible.
#
# NOTES: * This information in this section should match the
# corresponding information specified in the
# [DB SYSTEM SETTINGS] section of this installation's JDE.INI
# file.
#-----------------------------------------------------------------------

[JDBj-BOOTSTRAP SESSION]
user=DEMO
password=
environment=DEMO811
role=*ALL

#-----------------------------------------------------------------------
# Bootstrap physical data source
#
# This defines the data source where the OCM and some other system
# tables reside. JDBj uses this at bootstrap time and later to look up
# OCM entries on demand. If it is not valid, then no OneWorld database
# access is possible.
#
# Here is a description of each field in this section:
#
# ---------------- --------------------------------------- -----------
# Field Description Applies to
# ---------------- --------------------------------------- -----------
# name The data source name. This is not that All
# important for bootstrap connections,
# but it does show up in error messages
# and the log.
# ---------------- --------------------------------------- -----------
# databaseType The database type. One of the All
# following:
#
# I = AS/400
# O = Oracle
# S = SQL Server
# W = UDB
# ---------------- --------------------------------------- -----------
# server The server (i.e. the host). AS/400,
# SQL Server
# ---------------- --------------------------------------- -----------
# database The database. Oracle, UDB
# ---------------- --------------------------------------- -----------
# serverPort The server port. SQL Server
# ---------------- --------------------------------------- -----------
# physicalDatabase The physical database (used as library AS/400,
# qualifier for AS/400). SQL Server
# ---------------- --------------------------------------- -----------
# owner The owner. Oracle,
# SQL Server,
# UDB
# ---------------- --------------------------------------- -----------
# lob Supports lobs. Oracle,
#
# AS/400
# ---------------- --------------------------------------- -----------
# unicode Performs unicode conversion. SQL Server
# ---------------- --------------------------------------- -----------
#
# NOTES: * This information in this section should match the
# corresponding information specified in the
# [DB SYSTEM SETTINGS] section of this installation's JDE.INI
# file.
#-----------------------------------------------------------------------

[JDBj-BOOTSTRAP DATA SOURCE]
name=System Local
databaseType=M
server=(local)
serverPort=
database=System Local
physicalDatabase=PSSY811
owner=dbo
lob=false
unicode=true
databaseInstance=JDELocal
#-----------------------------------------------------------------------
# Bootstrap spec data source (Optional)
#
# This defines the data source where the serialized spec tables reside.
# JDBj uses this at bootstrap time and after to look up serialized spec
# objects on demand. If this section is not specified, then JDBj will
# use the OCM to find the serialized spec table. If it is not valid, no
# OneWorld database access is possible.
#
# See the description for "Bootstrap physical data source" above for
# information about which fields must be filled in for a given database
# platform.
#-----------------------------------------------------------------------

[JDBj-SPEC DATA SOURCE]
name=OneWorld Local
databaseType=M
server=localhost
serverPort=3372
database=JDELocal
physicalDatabase=PSSY811
owner=dbo
lob=false
unicode=true
databaseInstance=JDELocal
user=sa
password=

#=======================================================================
# END - OneWorld specific information
#
# The rest of the sections apply when accessing OneWorld and standalone
# data.
#=======================================================================

#-----------------------------------------------------------------------
# JDBC drivers
#
# This defines JDBC drivers and JDBC specific settings.
#-----------------------------------------------------------------------

[JDBj-JDBC DRIVERS]
ORACLE=oracle.jdbc.driver.OracleDriver
#AS400=com.ibm.as400.access.AS400JDBCDriver
SQLSERVER=com.microsoft.jdbc.sqlserver.SQLServerDriver
#UDB=COM.ibm.db2.jdbc.app.DB2Driver

[JDBj-ORACLE]
tns=tnsnames.ora

[JDBj-LOGS]
jdbcTrace=false

[JDBj-SERVER]
dbcsConversionTolerant=true

#-----------------------------------------------------------------------
# Connection pool settings
#
# These are used only when J2EE connection pooling is not available.
#-----------------------------------------------------------------------

[JDBj-CONNECTION POOL]
jdbcPooling=false
minConnection=5
maxConnection=5
initialConnection=5
poolGrowth=5
connectionTimeout=1800000
cleanPoolInterval=600000
maxSize=50
purgeCacheSize=5

#-----------------------------------------------------------------------
# JDBj Runtime properties
#
# These are all optional. They correspond to system runtime properties
# applicable to JDBj logical connections.
#
# NOTES: * In each case, the values listed are the defaults. The
# template default entries are commented out. Make sure
# and remove the pound sign (#) when changing these values.
#-----------------------------------------------------------------------

[JDBj-RUNTIME PROPERTIES]

; Data cache entry size threshold property. Sets the maximum
; size (in rows) for a single entry in the data cache. If a
; potential entry exceeds this threshold, then it will not be
; cached. -1 indicates that all eligible entries should be
; cached.
;
; Valid values: -1 or greater

# dataCacheEntrySizeThreshold=500

; Data cache entry threshold property. Sets the maximum size (in
; entries) for the data cache. If the data cache exceeds this
; size, then the least recently used entries are removed to
; make room for the new entry. -1 indicates that there is no
; maximum.
;
; Valid values: -1 or greater

# dataCacheEntryThreshold=100

; Force single data source property. Indicates whether JDBj
; should force operations involving multiple database objects to
; run against a single data source. If this is true, JDBj will
; only resolve the physical data source for the first database
; object involved in a given operation. Otherwise, JDBj will
; resolve physical data sources for all database objects and
; throw an exception if a single operation spans multiple data
; sources.
;
; Valid values: true, false

# forceSingleDataSource=false

; No where paren property. Certain TableIO system function
; queries require a long list of selections in the where clause
; without any intermediate parentheses. Specifying a composite
; selections alone for this case creates intermediate
; parentheses. If this property is set to a true then the JDBj
; will create SQL without any intermediate parenetheses.
;
; Valid values: true, false

# noWhereParen=false

; Result set timeout property. Sets the the number of
; milliseconds for the result set timeout. A result set will
; timeout if it has not had any operations for a period of time.
;
; Valid values: -1 or greater

# resultSetTimeout=60000

; Retry interval property. Sets the interval (in milliseconds)
; to wait before retrying idempotent database operations. -1
; means not to retry, 0 means retry immediately.
;
; Valid values: -1 or greater

# retryInterval=0

; Retry maximum property. Sets the number of times to retry
; idempotent database operations. -1 means to retry
; indefinitely.
;
; Valid values: -1 or greater

# retryMaximum=5

; Spec consistency check property. Sets the level of spec
; consistency checking. Set this property to a higher level to
; improve exception messages relating to spec inconsistency
; problems. Set this to a lower level when it is not needed
; since it may degrade performance.
;
; Valid values: full, minimal, none

# specConsistencyCheck=minimal

; Spec generate on demand property. Indicates whether JDBj
; should generate specs on demand if it can not find them
; in the persistent cache.
;
; Valid values: true, false

specGenerateOnDemand=true

; Transaction isolation property. Sets the isolation level to be
; used for transactions.
;
; Valid values: default, none, read uncommitted, read committed,
; repeatable read, serializable

# transactionIsolation=default

; Transaction timeout property. Sets the number of milliseconds
; for the transaction timeout. A transaction will timeout if it
; has not had any operations for a period of time. If this
; timeout is set to a -1 then the transaction timeout feature
; will be disabled. (This currently only happens when JDBj is
; run as part of a JAS transaction.)
;
; Valid values: -1 or greater

# transactionTimeout=120000

; Trigger auto fetch property. Indicates whether JDBj should
; automatically fetch rows to be changed in order to pass them
; to OneWorld triggers. This is needed for certain triggers to
; work properly.
;
; Valid values: true, false

# triggerAutoFetch=false

; Updatable result set timeout property. Sets the the number of
; milliseconds for the updatable result set timeout. An
; updatable result set will timeout if it has not had any
; operations for a period of time. -1 indicates that updatable
; result sets should have the same value as RESULT_SET_TIMEOUT.
;
; Valid values: -1 or greater

# updatableResultSetTimeout=-1

; Usage execution threshold property. Sets the expected maximum
; time (in milliseconds) for a single database operation to
; execute. If a single database operation takes longer than this
; threshold, then the statement and time will be logged as part
; of usage tracking.
;
; Valid values: 0 or greater

usageExecutionThreshold=20000

; Usage fetch size threshold property. Sets the expected maximum
; fetch size (in rows) for a single fetch to return. If a single
; fetch returns more than than this threshold, then the actual
; fetch size will be logged as part of usage tracking. -1
; indicates that any fetch size is valid.
;
; Valid values: -1 or greater

usageFetchSizeThreshold=500

; Usage result set open threshold property. Sets the expected
; maximum time (in milliseconds) for a result set to remain
; open. If a result set is left open longer than this threshold,
; then the result set and time will be logged as part of usage
; tracking. This does not automatically close the result set. A
; usage result set open threshold value of -1 indicates that no
; such usage tracking will occur.
;
; Valid values: -1 or greater

# usageResultSetOpenThreshold=60000

; Usage tracking property. Enables or disables usage tracking.
; This provides additional tracking and logging to use during
; testing. Usage tracking does incur a performance penalty so it
; should be disabled for production code.
;
; Valid values: true, false

# usageTracking=false

; Usage tracking output property. Specifies the destination of
; usage tracking output.
;
; Valid values: log, exception

# usageTrackingOutput=log

; Usage transaction active threshold property. Sets the expected
; maximum time (in milliseconds) for a transaction to remain
; active. If a transaction is left active longer than this
; threshold, then the transaction and time will be logged as
; part of usage tracking. This does not automatically rollback
; the transaction. A usage transaction active threshold value of
; -1 indicates that no such usage tracking will occur.
;
; Valid values: -1 or greater

# usageTransactionActiveThreshold=120000

#=======================================================================
# END OF FILE
#=======================================================================

Thank you very much for your reply. But I could not find it in my JAS.ini
Can you tell me where it is?


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

# Please refer to the JAS Installation Guide for detailed information on
# this file.
#
#

[SECURITY]
DataSource=System Local
SecurityServer=localhost
UseLogonCookie=FALSE
CookieLifeTime=7
SSOEnabled=FALSE
SSOUserIDOnly=FALSE
# set password only if SSOUserIDOnly is set to TRUE
Password=

[OWWEB]
PathCodes=('DEMO')
MO QUEUE=C:\E811\system\oc4j\j2ee\home\applications\webclient.ear\webclient\moqueue
ProxyPoolSize=50
F0005Prefix=DR
F0004Prefix=DT
#ProxyHost=
#ProxyPort=
MAXUser=100
FtpPort=21
FtpUsr=anonymous
FtpPwd=anonymous
UseMOWinNTShare=TRUE
PrintImmediate=FALSE
KeepUBE=TRUE
UBEQueue=QE811
SystemDateFormat=MDE
SystemDateSeparator=/
VirtualClientTimeOut=300000
InYourFaceError=TRUE
WAN=FALSE

# The HelpPath key determines where JAS looks for help files.
# Syntax: "http://[machine]/[path]/".
# Note, if you specify "/jde/owhelp/", this machine is assumed.
HelpPath=/jde/owhelp/


[CACHE]
# These intervals are in milliseconds. For example, 60000ms = 1 minute
UserSession=2400000
UserProfile=1200000
CacheCheck=60000
Menu=3600000



[SERVER COMPONENTS]
#
# Do not modify this section
#
com.jdedwards.jas.UserManager
com.jdedwards.jas.JDBCProxy
com.jdedwards.jas.JDEORB
com.jdedwards.jas.DDValidation
com.jdedwards.jas.security.SecurityBroker
com.jdedwards.jas.UDCJDBC
com.jdedwards.jas.JDEUDCText
com.jdedwards.jas.JDEUpdates
com.jdedwards.jas.JDEQueries
com.jdedwards.jas.JDEOWDirect
com.jdedwards.jas.ServerQuery
com.jdedwards.jas.JDESignon
com.jdedwards.runtime.virtual.MAFComponentLoader

[JDENET]
# Enterprise Server JDENET port
serviceNameConnect=6012

# JAS Server JDENET Listening port
serviceNameListen=6011

# Maximum number of dedicated kernel types
maxKernelRanges=1

# Time out value for requests sent to the Enterprise Server
enterpriseServerTimeout=90000

# JDENET socket connection pool size
maxPoolSize=50

# Directory for JDENET temporary file
tempFileDir=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp

# Clustered logical datasource retry interval
ClusterRetryInterval=60000

# Dedicated Kernel Definitions
[JDENET_KERNEL_DEF1]
krnlName=XAPI Kernel
processClassName=com.jdedwards.runtime.virtual.xapi.PublishedMessageProcessor
startMessageRange=15001
endMessageRange=15250
maxNumberOfThread=3


[SERVER]
# Enterprise Server and port providing Glossary Text information
glossaryTextServer=

# Encoding scheme
# 1252- English and Western European
# 932- Japanese
# 950- Traditional Chinese
# 936- Simplified Chinese
# 949- Korean
codePage=1252

[LOGS]

# JDBC Trace (in stdout)

rtdebugTrace=FALSE
rtlog=log\rt.log
rtdebug=log\rtdebug.log
rtlogType=All
#or =BSFN|TableIO|SYSFUNC|MISC|ER|EVENT|THREAD (any combination).


# The STDERR and STDOUT keys must point to the same directory that was supplied for the
# STDERR and STDOUT fields when defining the WebSphere Application Server.
# This is usually the INTERNET directory under B7333.
#
stderr=log\stderr.txt
stdout=log\stdout.txt

[JAS INSTANCE]
# This is for JAS redirector only
# RoundRobin will be used as default if ther is no entry in [JAS WEIGHT].
# If redirect based on JAS instance weight, then each instance's weight must specified,
# otherwise, weight 0 will be assumed, which means the server will not get
# any redirected request
# example: JAS1=http://127.0.0.1/jde
# Note: in this example, "JAS1" is the key, if weight will be given,
# this key must be used in [JAS WEIGHT] section to match this JAS instance

[JAS WEIGHT]
# The key must match the key in [JAS INSTANCE] section
# example: JAS1=2
# The weight is ratio based, for example:
# JAS1=2
# JAS2=1
# That means JAS1 will take as twice load as JAS2


[REDIRECTOR]
# interval unit is milliseconds
Interval=5000
# This is the location that Redirector will redirect to, if no server is available.
# If it is empty, redirect will display a simple page tells user that no server is available
# example: NoServerAvailableURL=http://servername/path/noserver.html
NoServerAvailableURL=

[TRANSACTIONS]
# Configuration settings to customize transaction processing within JAS.

# ReapInterval : Interval in minutes of how often the TransactionReaper
# should check for abandoned transactions.
# Valid values: Integer from 1 to n
# Default: 5 minutes
# MaxAge : Maximum age in minutes of a transaction. Transactions
# older than this will be rolled back by the
# TransactionReaper.
# Valid values: Integer from 1 to n
# Default: 10 minutes
#

ReapInterval=5
MaxAge=10

[WEB DEVELOPMENT]

# This setting is to map multiple virtual clients to a single JAS session by reusing the same NetConnection for same user
# True = reuse, else = create a new jas usersession for each virtual client
ReuseNetConnection=TRUE

# Flag for denoting whether web client is a development client
WebDevelopment=TRUE

[LOGIN]

# The default decryptor is the XOR decryptor. more could be added by appending
# e.g decryptors=name1|class1|name2|class2....
decryptors=X|com.jdedwards.base.util.encryption.XORDecoder

[ERPINTERACTIVITY]
#interactivity level. valid values are: LOW, MEDIUM, and HIGH
InteractivityLevel=HIGH
# whether multiple browsers fetch is enabled
MultipleBrowserEnabled=TRUE
# the maximum number of open browsers for each user
MaxOpenBrowsers=10
# the number of records fetched for each database fetch before getting a system warning
DBFetchLimitBeforeWarning=2000

#Specify the Mail Merge Location on Web Server, it should be under the webclient (or webclient.war) dir.
[MAIL MERGE AND DOC GEN]
MailMergeLocation=C:\E811\system\oc4j\j2ee\home\applications\webclient.ear\webclient\mailmerge

[INSTALL]
#ClientType=mobile

The JAS.INI you posted looks like a local development client jas.ini which is different than the JAS.INI installed from the tools release to the actual HTML server.

The GlobalPageSize does not exist in the client web. Never tried it but you can try adding it to the [OWWEB] section:

GlobalPageSize=20

---------

Brendan,

There are a slew of parameters that are NOT going to be found by default, so if you don't see it, just add it, and restart your JAS instance. The method of default number of grid rows has flip flopped between hard coded, .INI setting, to within each application, to now, either per application and/or .INI.

Add the setting to the appropriate section of your file.

Yes, it works. Thank you very much.

jstooge,

Thank you for your reply. Do you know where I can find those non-default parameters? I just want to know more about it as for my references.