Yes, great idea. That would work as well. I keep track of some other data like
when it was assigned and by whom.
The QUERY BY ATTRIBUTE command would allow one to query on multiple criteria in
an object.
Hopefully, at some point, objects get support for commands like SQL EXPORT
DATABASE.
> On May 19, 2017, at 12:49 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> I'll just add you don't actually need to put the keywords in a separate
> table anymore. You can add a text field to your table. Populate the field
> with the keywords (or tags) using a space as the delimiter. Then set that
> field to have a keyword index and query it using the keyword operator.
>
> I've used this approach since v13 for things like Contact or Partner
> records to simplify doing queries for names, for example. In this case a
> handy benefit is you can mix in things like the soundex or metaphone codes.
> JPR also mentioned this technique in a 4DWT session.
>
> On Fri, May 19, 2017 at 8:04 AM, Guy Algot via 4D_Tech <4d_tech@lists.4d.com
>> wrote:
>
>> Eric,
>>
>> I’ve used this for years and called it Keywords. A separate related table
>> stores the Contact Key and the Keyword. You can search on the Keywords and
>> then relate that selection to Contacts. This was before objects. But like
>> Koen said, objects would work as well. Depends on how flexible you want to
>> be.
>>
>> Did you go to the World Tour? JPR demo’d something like this on Day 1.
>>
Later,
Guy
--
Guy Algot, Solutions Specialist
Edmonton, Alberta
(780) 974-8538
hardware, installation, training, support, programming, internet
specializing in 4th Dimension
=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************
