Using wildcards in queryvalue

(0) Share

Report

Posted on by Community Member

Hi all

I have made a query and I want to pass some wildcards as '*' and '?' in the queryvalue. But when I use one of these wildcards and prompt the QueryRun, I can see that a backslash is being added to the queryvalue, why?

Here is an example for ItemIdMatrix value:

while select documentTypeEmailMatrix
        order by Priority
        where   documentTypeEmailMatrix.DocumentType == _docType
        &&      documentTypeEmailMatrix.IsDefault    == false
    {
        query = new Query();
        qbd = query.addDataSource(TableNum(NCEmailMatrixTmp));


        qbr = qbd.addRange(FieldNum(NCEmailMatrixTmp, PostalCode));
        qbr.value(queryValue(documentTypeEmailMatrix.PostalCode));

        qbr = qbd.addRange(FieldNum(NCEmailMatrixTmp, PostalCode));
        qbr.value(queryValue(''));

        qbr = qbd.addRange(FieldNum(NCEmailMatrixTmp, Id));
        qbr.value(queryValue(documentTypeEmailMatrix.Id));

        qbr = qbd.addRange(FieldNum(NCEmailMatrixTmp, Id));
        qbr.value(queryValue(''));

        qbr = qbd.addRange(FieldNum(NCEmailMatrixTmp, JobCode));
        qbr.value(queryValue(documentTypeEmailMatrix.JobCode));

        qbr = qbd.addRange(FieldNum(NCEmailMatrixTmp, JobCode));
        qbr.value(queryValue(''));

        qbr = qbd.addRange(FieldNum(NCEmailMatrixTmp, ItemId));
        qbr.value(queryValue(documentTypeEmailMatrix.ItemIdMatrix));

        qbr = qbd.addRange(FieldNum(NCEmailMatrixTmp, ItemId));
        qbr.value(queryValue(''));
        
        qr = new QueryRun(query);        
        qr.prompt();
        
        while (qr.next())
        {

           qr.setRecord(emailMatrixTmp);
           return documentTypeEmailMatrix;
        }

    }

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Community Member on at

Like (0)

Report

Hi Crispin,

Thanks for your response.

But it doesn'r give me the right answer.

When I delete the backslash from the query value, it comes with the right result.

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

What exactly did you do when you "used one of these wildcards"? How did you set the range value?

Was this reply helpful? Yes No
Verified answer

Rohin 4,624 on at

Like (0)

Report

Hi Mahyar,

Sorry if i am getting wrong to you , you want to avoid backslash in query right ?? if so , To do a filter with wild card, you can use SysQuery::valueLikeAfter(). have you tried below code :

qbr.value(sysQuery::ValueLikeAfter("your range value");

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Martin

I have a string field where I enter the range value for ItemIdMatrix. When I debug through the code I can see that queryvalue for ItemIdMatrix is the value I entered. But when I prompt the QueryRun I see a backslash added in front of the wildcard.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Visvash

Thanks :) that was exactly what I needed.

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Aha, I see. You asked AX to look for a specific item ID (containing a special character), but then you somehow expect something else and you're surprised when you get the right result. Namely you ask AX to find an item called FV47001-*, which is what happens. But for some reason, you thought that AX would not look for item FV47001-*; you want it to look for items with ID starting with FV47001-, which is something completely different. That would be wrong result when looking for the value "FV47001-*".

Also, the value is escaped because you put it into your code. That's what queryValue() does.

It seems that your field isn't an item ID, it's a query criteria. You should name your fields according their contents.

Was this reply helpful? Yes No