How to filter records that have backslash in a field using x++?

(0) Share

Report

Posted on by Community Member

Hi,

I have a requirement to filter packingslip records that have backslash or no backslash in packingslipid. I could not able to filter the backslash records for the belwo code. Please let know how to filter backslash value as well no backslash value.

this.query().dataSourceTable(tablenum(VendPackingSlipJour)).clearRanges();

this.query().dataSourceTable(tablenum(VendPackingSlipJour)).addRange(fieldnum(VendPackingSlipJour, PackingSlipId)).value(con2str(contPackingSlip));

Thanks and Regards,

Kuppusamy S

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (3)

Verified answer

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi Kuppisamy,

In x++ some special characters are marked with a backslash. E.g. a return is '\n'. If the value of the packingslip contains this character you can try to add quotation marks around the query value in x++ code.

A second attempt could be to find the position of the backslash and add a second backslash. E.g. "2013\0244" will be formatted to "2013\\0244" for the query value.

Was this reply helpful? Yes No
Verified answer

Jonathan Halland 11,310 on at

Like (0)

Report

Hi Kuppisamy

A couple of options for you to also look include the built in method "queryValue" to ensure that the string is properly escaped. E.G. queryRange.value(queryValue(myString));

if you are building up your string in code you could also use a string literal e.g. value = @"2013\02\02"

Was this reply helpful? Yes No
Verified answer

MukeshHirwani 1,180 on at

Like (0)

Report

Hi,

U can use LIKE keyword inside queryBuildRange and supply "\" OR "\\"

mukesh-ax.blogspot.in/.../query-ranges-in-x.html

Was this reply helpful? Yes No