StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8603755
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-12-22T12:17:39.173
FavoriteCount
0
LastActivityDate
2011-12-22T12:17:39.173
LastEditDate
LastEditorUserId
0
OwnerUserId
1071402
ParentId
7715902
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
To answer your last question first... you can't. Solr does not have the functionality to do leading and trailing wildcard searches. But depending on your schema setup (how individual terms are generated) combined with how you're querying the index, you may be able to do a decent approximation. I'm making quite a few assumptions here because the question doesn't describe your set up very well. Assumptions: <ul> <li>The field you're querying contains unique values (this enables us to do a simple query. Otherwise, we'd have to do facet queries to return unique values which is a bit more complex)</li> <li>The version of solr you are using supports the eDismax query parser</li> </ul> Schema: In order to match "Adam E" and "Adam Gray" to "Adam E Gray" you will need two fields, say fullName (e.g. "Adam E Gray") and firstNameLastName (e.g. "Adam Gray") These fields should both be indexed and whichever your wish to populate your filteringSelectBox should be stored with a text data type (i.e. using the "solr.WhitespaceTokenizerFactory" tokenizer). Using this tokenizer will allow "E Gray" to match "Adam E Gray" Query String q={!edismax qf='fullName firstNameLastName'}$name*&fl=fullName&rows=$count&start=$start where: - $name is string to match. It doesn't have to be a complete name, but the string must begin with the beginning on a search term. I.e. "Adam E Gr" is OK (the asterisk allows trailing wildcard search), "dam E Gray" is not. - $count and $rows are set by your readStore
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PODijit.form.Combobox QueryExpr
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USAlan Kay
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.