On Nov 24, 2009, at 2:49 PM, Jacques Le Roux wrote: > From: "David E Jones" <d...@me.com> >> >> On Nov 24, 2009, at 3:51 AM, Jacques Le Roux wrote: >> >>> Hi Bilgin, >>> >>> Just one question >>> From: "Bilgin Ibryam" <bibr...@gmail.com> >>> [big snip] >>>>>>> 2. There is no way of indicating what field you actually want to >>>>>>> search against. >>>>>> >>>>>> This would typically be a search on whatever the description is made up >>>>>> of (ie that's what users expect). >>>> Searching on one field is not useful for most of the cases. For example to >>>> search for a party, it is good to search in partyId, firstName, >>>> middleName, lastName, groupName fields. >>>> With other entities it would be good to search at lease in ID and >>>> description fields. >>> >>> But partyId is unique, so searching on only one field makes sense, or ? >> >> A partial partyId isn't unique though... > > I don't get it, Party has only partyId as primary key, isn'it ?
It depends on the UI. You can assume that what was entered was the complete value and requires an exact match, or a partial value and can match multiple records. For example: If you specify a partial value, like only 3 characters, and you have coded it to not assume those 3 characters are the entire PK value, then you can query for all PK values that include those 3 characters. -David
