How to limit qbe results based on a field value

[sitadba]

First we are using Service Center V5.01 with A9901.

When at the apm.quick form opening a problem ticket, we have a field called 'site'. We open problem tickets for sites and not contacts. There is a link record from the 'site' field to 'site.code' field in the 'siteinfo' file.

For each site in the siteinfo file, there is an array field called 'site.products' that list all the services we provide at that site.

What I need to do is when opening a problem ticket I need the site fill button to be filtered to show only the sites that have the site.products that the ticket is being opened for. In a nutshell I need the following;

If category = "BagMessage" then pull sites where "BagMessage" is in site.products.

If category # "Component" then pull sites where "CUTE" is in site.products.

If category = "BagManager" then pull sites where "BagManager is in site.products.

I could do it so that where site.products = category, but in the case where the category begins with Component, I need to find the site.products = "CUTE"

Any help would be appreciated.

Brgds,
Denise

 

[rji1124]

Hi... I would try a two column table that would contain the category entries in one column and the site products in the other... like:

Category Product
BagManager A123
BagManager B234
Component C456
Component D789.... etc.

Hope this helps some...

Bob