The LiveSite Content Services Technical Reference Guide is very sparse on examples of how to query the lscs. I would like to see some examples of queries others have written that are not immediately obvious from reading the manual.
An example of the metadata on one of our location dcr's
[HTML]
<metadata>
Central
true
06222010 03:19:59 PM
www/location
Information about the Scott & White Killeen Clinic.
31.086373
scott & white healthcare;scott & white;scottandwhite;killeen; family medicine; clinics; locations
Killeen Clinic
gap13smc
06182010
97.702824
Clinic
31
Patients
[/HTML]
The field "TeamSite/Metadata/staffLocationId" is used to map an ID from an old legacy location database. Our staff members can float between sevral locations and I needed to get a list of these from lscs based on this ID. There are records with the following values in lscs 31,6,62, and24
I had a staff member who floats between locations 31 and 6. So I wanted to grab thoes from lscs. The query I ended up writing is not documented in lscs.
I tried this and it did not work:
(TeamSite/Templating/DCR/Type:www/location AND TeamSite/Metadata/staffLocationId:31,6)
It returned locations with the ID of 31, 6, and 62.
This did the same as above
(TeamSite/Templating/DCR/Type:www/location AND (TeamSite/Metadata/staffLocationId:31 OR TeamSite/Metadata/staffLocationId:6))
If I added a third item to the OR section like
(TeamSite/Templating/DCR/Type:www/location AND (TeamSite/Metadata/staffLocationId:31 OR TeamSite/Metadata/staffLocationId:6 OR TeamSite/Metadata/staffLocationId:=120))
I received the following error
[HTML]
Multiple boolean operators must be fully parenthesized. ?q=(TeamSite/Templating/DCR/Type:www/location%20AND%20(TeamSite/Metadata/staffLocationId:31%20OR%20%20TeamSite/Metadata/staffLocationId:6%20OR%20TeamSite/Metadata/staffLocationId:=120))
[/HTML]
Which was confusing as it returned results with two arguments in the OR portion but not three.
Adding parentheses around the portion before the AND allowed it to run but still it pulled to many records.
((TeamSite/Templating/DCR/Type:www/location) AND (TeamSite/Metadata/staffLocationId:31 OR TeamSite/Metadata/staffLocationId:6 OR TeamSite/Metadata/staffLocationId:=120))
That was not explained well in the manual at all.
To finally get it to work I ended up with
((TeamSite/Templating/DCR/Type:www/location) AND (TeamSite/Metadata/staffLocationId:=31 OR TeamSite/Metadata/staffLocationId:=6))
:= is not even mentioned as an option in the manual I had to guess that it would work based an an example that had
in it.
What are some other undocumented query tricks for lscs? Better still is there any good documentation on this query syntax?
