Skip navigation
Don Kerr
Don Kerr
Currently Being Moderated

ArrayCollection all items in string

Jan 2, 2013 9:59 AM

I'm trying to find all vehicles that have a string of accessories.

 

I have a comma sep string of optioncodes that represent selectedItems from an options List

optionsString:String = leather,stripes, ...

 

I have an ArrayCollection called vehicleOptions that contains a list of vehicle options one row per option

VIN1,optioncode

VIN1,optioncode

VIN2,optioncode

VIN2,optioncode

VIN3,optioncode

...

 

I need to retrieve all vehicles (VINs) that have, not one, but ALL of the optioncodes contained in the selected optioncodes string. 

 

Any recommendations on how to do this?

 

Once I have a list of VINs, this will allow me to filter down another List of vehicles on the lot by only the vehicles that have ALL the selected options.

 

Thanks!

 

Don

421 Views   4 Replies   Latest reply: Don Kerr, Jan 3, 2013 10:09 AM
 
Replies
  • Flex harUI
    Currently Being Moderated
    1. Flex harUI,
    Jan 2, 2013 9:15 PM   in reply to Don Kerr
    Report

    I think you can just brute force check it if there is < 1000 cars.  Use indexOf to test each option against the option string.

     

    If you had 1000’s of cars to test, I would probably convert each option to a bit in a bitmask.

     
    |
    Mark as:
  • Don Kerr
    Currently Being Moderated
    2. Don Kerr,
    Jan 3, 2013 6:16 AM   in reply to Flex harUI
    Report

    Thanks Alex.

     

    indexOf should be fine for checking if one option exists.  I was just struggling with how to track/store only vehicles that  have ALL the items in the option string, not just one.

     

    I'm thinking a VIN array to store only the VINs that have all the options.  And basically removing the VIN if one of them is not found.  If all of the options are found, keep it.  Not sure if that will work.  I'm planned to try this today.

     

    Don

     
    |
    Mark as:
  • Flex harUI
    Currently Being Moderated
    3. Flex harUI,
    Jan 3, 2013 7:26 AM   in reply to Don Kerr
    Report

    If I understand your data, you would loop through the array remembering the last VIN you saw.  If you get through all the options for the VIN without a miss then it does have all of the options.

     
    |
    Mark as:
  • Don Kerr
    Currently Being Moderated
    4. Don Kerr,
    Jan 3, 2013 10:09 AM   in reply to Flex harUI
    Report

    Thanks Alex.  This approach will do the trick.

     

    Appreciate the help.

    Don

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points