Wildcard Across Fields?? Is it possible.

[bnelson111]

Here is a strange request, I am currently trying to select a wild card match which is working on a single field.

if(wildmatch(PSADATA.tech1 ,'*'&getfieldselections(Defect)&'*'),PSADATA.tech1,null())

I select the wildcard via a list, its working 100% but i what to search across

PSADATA.tech1

PSADATA.tech2

and

or PSADATA.tech3

Any ideas? Thanks Brett

[MK_QSL]

Use

GetCurrentSelections() with no parameter..

instead of GetFieldSelections()

[Anonymous]

Can you post your sample QVW file. That way we can provide you the right solution.

[bnelson111]

Pulling all fields its a large presentation wanted to limit to

PSADATA.tech1

PSADATA.tech2

and

or PSADATA.tech3

[bnelson111]

worked around it, con(PSADATA.tech1)&(PSADATA.tech2)&(PSADATA.tech3) as Tests

then used the wildcard.

if(wildmatch(Tests ,'*'&getfieldselections(Defect)&'*'),Tests,null())