4Site
Support Request System
View Request #03414
Description
Title:
Request Type:
Request for paid enhancement
Request for information
Training
Data Investigation
Bug
Other
Description:
When doing equipment lookups by "Type", only the "%" wild card works. Using the "*" as a wild card does work. On all other lookups, either wild card works.
Priority:
Aliases:
High
Medium
Low
conversion
equipment
execution
format
lookup
wildcard
Application:
Application Option:
Accounting
Accounts Receivable
All - system wide change
Appropiations
Asset Performance
Background Crystal Job
Background Job Requestor
Background PM Workorders
Background Queue
Background Schedule Print
Background Service
Bank
Bids
Build Picture Clips
Buyers
Check Writer
Cheque Reconciliation
Codes
Contractor Management
Control Center
Document Routes
Employees
Equipment
Filings
Financial Reports Generator
Fixed Asset Register
Format
FRx Data Refresher
GST Reports
Hotspot Editor
Installation
Interface Run Control
Journal Vouchers
Messages
Meter Readings
Mobile
New
Not Applicable
Organization
Performance Indicators
Persons
Picking
Picking Background
Preventative Maintenance Program
Price Book
Projects
Purchase Order Batch Handler
Purchase Orders
Purchase Requisitions
Query Accounts
Query Appropriations
Query equipment
Query Financial Transactions
Query Persons
Query Preventative Maintenance
Query Price Book
Query Projects
Query Purchase Orders
Query Purchase Requisitions
Query Stores Setup
Query Suppliers
Query Tool
Query Vouchers
Query Work Orders
Receipts
Receivables
Recipient Created Tax Invoice
Register
Reorder Requests
Run Job
Scheduling
Security
Service Accruals
Spares and Turnarounds
Sql Patch Script
Standing and Reallocation JV
Statistics
Stores Quick Pick
Stores Requests
Stores Setup
Suppliers
Tax Codes
Templates
Timesheets
Training
Transaction Posting
VO Approvals
VO Review
Voucher Query
Vouchers
Web Purchase Requisitions
Web WO
Wo Backlog Report
Work Orders
Work Requests
Add
Batch
Browse
Change
Close
Copy
Create
Custom entries
Delete
Detail
Email
Export
Fax
Find
Grid
Import
New
None
Open
Other
Post
Print
Query
Reopen
Reorder
Report
Save
Tree
Workflow
Current Status
Status:
Status Date:
New
In FSC Approval
In Quotation
In Customer Approval
In Analysis
In Programming
In Quality Assurance
In Documentation
In Installation
In Shipment
In Billing
Closed
Cancelled
Reference Documents:
Disposition:
Development
Request for information
Installation and Training
Data Investigation
Support
Scheduled this release
Scheduled next release
Other
Sales Support
Resolution:
Stephen June 25, 2010 ===================== In the "By Type" case, the wildcard was not being formatted properly for SQL execution. '%' is the proper wildcard character for SQL so '*' must be converted to '%' to work properly. This conversion is now being done in the "By Type" case to match the other lookups.
Associated Patches:
50.506.021 -
Equipment: Find "By Type" does not work using "*" wild cards
50.040.003 -
Equipment: Find "By Type" does not work using "*" wild cards
History
Status:
Status Date:
Reference Doc:
New
June 23, 2010
In Programming
June 25, 2010
In Quality Assurance
June 25, 2010
In Installation
July 21, 2010
Closed
July 26, 2010
Browse Requests
Find a Request
Return to Request System Menu
