• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

XE Who's who (phone) search

Frosty the Coder

Legendary Poster
XE Who\'s who (phone) search

An XE site wants to be able to key a PHONE# (or leading characters of
a phone#) and bring up matching Who's Who records.

The specs suggest using the P01800 (Addr Book Name Search) via a
form interconnect and forcing the phone# (or leading digits) into the QBE.
However, this app is NOT based on a bsvw that has the phones available
to it and that prevents the QBE.

I also looked at P0111S (Who's Who Search Select), this does not
have phone#s available to it.

There IS a bsvw (V0111C) which is made up of F0111 and F0115,
but I can't seem to find a Search/Select based on this.

IS there an existing JDE Search/Select, or bsfn that allows for a
PHONE SEARCH, or do I need to code custom to create this


Gene Piekarski, Jr

AS/400, B733, SP11.2, NT client
AS/400, B733, SP14, W2000 client
XE, SP13


Legendary Poster
Re: XE Who\'s who (phone) search

Hi Gene,
I think so that not a complicated task to create a new BSVW for your need and create a custom form (APPL) based on it as Search and Select or Find/Browse to accomplish the task exactly you wish if you have a minimum experience in BSVW and FDA designer tools.
Maybe you will need to define a new index over the phone number in F0115 for better perfomance.


B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)