Forum Discussion

srmorrisonearthlink-net's avatar
srmorrisonearthlink-net
Creator 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

3 Replies

    • angela's avatar
      angela
      Catalyst II
      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

      • srmorrisonearthlink-net's avatar
        srmorrisonearthlink-net
        Creator 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