How to check a value exist in List Object on CPQ?

[sbslmhmt]

Hello,

I have written this below code to check if a value exist in list object but It's always return as false. Where do I do wrong?

G = SqlHelper.GetList("SELECT Attr FROM TAGTABLE WHERE PRODUCT ='" + Product.PartNumber + "' AND ACTIVE ='X'")
if 'Pallet Capacity' in G:
   #some coding

[former_member776742]

Hi Mehmet,

You can use this check: (in your case)

G = SqlHelper.GetList("SELECT Attr FROM TAGTABLE WHERE PRODUCT ='" + Product.PartNumber + "' AND ACTIVE ='X'")


for attr in G:
    #Trace.Write(attr.Attr)
    if attr.Attr == 'Pallet Capacity':
        Trace.Write('Value Exists')

[Stevica]

Hi

Try with "SqlHelper.GetFirst" instead of "GetList".

Regards