Forum Discussion

srmorrison's avatar
srmorrison
Ideator I
3 years ago

How do I use "Like" with declared properties in Query Builder?

I would like to use Query Builder to get Plant declared Manufacturing Parts who's item numbers have a Root that are Engineering Part number.

Example:

Engineering Item Number: 1122345

Manufacturing Item Numbers: 1122345 (ABB), 1122345 (GFD), 1122345 (PLO)

In SQL I could use

   1) Where [Part].item_number like '1122345%'

   2) Where [Part].item_number like CONCAT([Part].item_number,'%') and [Part].classification = 'Manufacturing'

I tried the following in the following order as Query Definition Conditions:

1) [Part Number] like '@[Part Number]%'    -- This did not work.

2) [Part Number] like '1122345%'    -- This did not work

Can anyone make a suggestion here?

Are there any documents that cover/describe examples of Query Builder Condition Statements?

Thanks for the help!

Scott

Query Builder

3 Replies

  • srmorrison's avatar
    srmorrison
    Ideator I
    3 years ago

    As an update ... I am using 11SP15. I know that Query Builder is not very stable in 11SP15.

    • AngelaIp's avatar
      AngelaIp
      Ideator I
      3 years ago

      Hi,

      your second variant should work. Guide says the same: 

      Check if your [Part Number] is really called [Part Number]. Maybe you have a custom label?

      Best regards

      Angela

      • srmorrison's avatar
        srmorrison
        Ideator I
        3 years ago

        The second variant does not work.

        I am going to move to R22 in the next few days and I will try it in that version.

        Thanks for confirming.

        Scott