Showing results for 
Search instead for 
Did you mean: 

Formatted Search in Matrix

Former Member
0 Kudos

How to create a query for formatted search if my variable is in the matrix(some column and some row).

I would like the SAP user get a list of all Workorders for a Job, and Job is a cell in matrix.

Workorder value should be shown in another cell in the same row.

Thanks a lot,

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Pavel,

The document 'How to Define and Use Formatted Search' on the Service Market Place goes through defining and using formatted searches with queries. It also explains how to use fields in an active form in a formatted search, look at the section called 'Search by Saved Query' in the document.

To find this document go to -> Channel Partner Portal -> Solutions - SAP Business One -> Support -> Additional Information - Documentation Resource Centre -> SAP Business One 2005 A SP 01 -> How to guides -> 'How to Define and Use Formatted Search'

This document also gives some examples of the types of queries which are used in formatted searches.

Hope this helps


Active Contributor
0 Kudos

Please go through this thread