jkrjamias Posted August 13, 2012 Share Posted August 13, 2012 Good Day!We would like to seek help on managing multiple values within a single XML attribute. <Row> <title>type Title here</title> <description>type Description here</description> <stage>Development</stage> <platform>Java, .NET, Mainframe</platform> <lifecycle>Custom Development</lifecycle> <servicegroup>System Integration (SI), Technology Consulting (TC)</servicegroup> </Row> With the above sample xml, as you may notice, <platform> does have 3 values; (1) Java, (2) .NET and (3) Mainframe. We were able to load them separately. NOTE: We have 4 filters; (1) stage, (2) platform, (3) lifecycle and (4) servicegroup. PROBLEM: When we try to filter the platform and servicegroup. Scenario#1, we selected "Java" in the platform filter and use "where" condition. RESULT: It loads those items that has <platform>Java</platform> only and does not include <platform>Java, .NET, Mainframe</platform>. [bAD RESULT] Scenario#2, we selected "Java" in the platform filter and use "like" condition. RESULT: It loads all items that has <platform>Java</platform> and include <platform>Java, .NET, Mainframe</platform>. [GOOD RESULT] But the catch in using "like" condition is that it conflicts with platform values for "Oracle"... <platform>Oracle</platform> <platform>Oracle - PeopleSoft</platform> <platform>Oracle - Retek</platform> <platform>Oracle - Siebel</platform> Oracle - PeopleSoft, Oracle - Retek and Oracle - Siebel are different to each other. So, what if I selected "Oracle" for platform filter? We expected items which only have <platform>Oracle</platform> and not all of those items that has "Oracle".Any help appreciated. Link to comment Share on other sites More sharing options...
JamesB Posted August 14, 2012 Share Posted August 14, 2012 how about splitting the sub entries into tags within the tag, like changing: <platform>Java, .NET, Mainframe</platform> to something like: <platform> <subentry>Java</subentry> <subentry>.NET</subentry> <subentry>Mainframe</subentry></platform> and <servicegroup>System Integration (SI), Technology Consulting (TC)</servicegroup> into: <servicegroup> <subentry>System Integration (SI)</subentry> <subentry>Technology Consulting (TC)</subentry></servicegroup> and the code which searches for the text could perform this on each filter: - if there are sub entries, do a "where" on each sub entry's value- if there are no sub entries, do a "where" on the single value Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now