parts

Server hostname:
www.avtechpulse.com

Dbname:
office

Username:
demo

Password:
demo

Database Type:
PostgreSQL

Table:
parts

Allow list all:
No

Key field:
id

List fields:

Query fields:
supplier,productcategory,manufacturer,partnumber,notes,id

Prepopulate fields:

Auto-increment fields:
id

List Order:
supplier ASC, productcategory ASC, sortingoverride ASC, partnumber ASC, qty DESC

Where clause:

Foreign Keys:
supplier,suppliername AS supplier FROM suppliers_table,productcategory,productcategory from productcategorylookup,manufacturer,manufacturer from manufacturer_table

Regexp Translation Condition Field:
supplier

Regexp translation Field:
partnumber

Regex Pattern:

Value	Pattern	Transformation	Flags
NEWARK	(\d\d[A-Z]\d{3,4})(\W\|$)	<a href="http://canada.newark.com/$1">$1</a>$2
DIGI-KEY	([A-Z0-9\-\./]+\-ND)	<a href="http://search.digikey.com/scripts/DkSearch/dksus.dll?Detail?name=$1">$1</a>

URL match:

There are currently no items in this folder.

Document Actions

Send this
Print this

Sections

Personal tools

parts

Document Actions