Autolookup to SQL Database with mutiple filter conditions

Comments

6 comments

  • Avatar
    Alexey Shmelkin (ABSC.de)

    Hi Gwen,

     

    can you verify what are the values for the dropdowns? For customer i understand the Value is the ID, and for Location? Can you also tryonly location as a filter?

    Regards,

    Alexey

    0
    Comment actions Permalink
  • Avatar
    Gwen Wilson

    Hi Alexey,

    Correct, the value for Customer is Customer_ID. Location is simply Location. I don't have an ID field for it. It's format is "City, State". I wondered if the comma in the data could be messing it up.

    I tried Location as the only filter and it doesn't work.

    0
    Comment actions Permalink
  • Avatar
    Alexey Shmelkin (ABSC.de)

    If only Location doesn't work, then the problem is there. Perhaps comma indeed makes problems. Can you try to make this lookup with SQL formula? Just to be sure, that it works with location? Alternatively with JavaScript make the call with only Customer ID as filter and look in the location column to know, what exactly coming in?

    Regards,

    Alexey

    0
    Comment actions Permalink
  • Avatar
    Gwen Wilson

    I had tried to do a SQL statement before and it didn't help any.

    I just removed the commas from all of one customer's locations in the data and it worked. So commas in the data are the issue. It doesn't look awful, not having commas. But do you know any fix to get around it if my business owner has to have commas? I guess I could add an ID field to the locations and use it with "City, State" being only for display purposes.

    0
    Comment actions Permalink
  • Avatar
    Alexey Shmelkin (ABSC.de)

    As far as i know there were some limitations for commas in AgilePoint. Perhaps now in V7 SU1 some of them is already fixed. ID is always best practise to work with. Normaly one should create another table with locations and ids and reference it in your table.

    0
    Comment actions Permalink
  • Avatar
    Gwen Wilson

    Ok, thanks! I appreciate all your help!

    Gwen

    0
    Comment actions Permalink

Please sign in to leave a comment.