SageScottsdalePlatform/argos-saleslogix — Issue #30: Hash Tag Search Queries
Author: rjsamp
Created: 2011-12-11 15:00:38+00:00
State: open

I like this capability....although this should be USER Friendly, not programmer friendly (or should be both).
I'm liking this:

#!(AccountName like ‘Abbott%’)

Another

#!(Type like ‘%Cust%’)

This too:

#!(AccountName like ‘Abbott%’ and Type like ‘%cust%’)

However the queries need to be LOCALIZED Display name based (User Friendly), not simply Property Based (Programmer Friendly) (I'm assuming you want # queries to be used by User's correct? or is that not their purpose?)

So
#!(AccountNameDisplayName like 'Abbott%')
Another
#!(TypeDisplayName like '%Cust%')
This too:
#!(AccountNameDisplayName like 'Abbott%' and TypeDisplayName like '%cust%')

And maybe the spaced display names need to be in " " or [ ] to handle spaces in Display Names.

This should NOT be in Programmer Property stuff only....

ALSO is this going to be a SQL Injection Security breach? Anytime I see non-parameterized SQL Server Queries you scare the heck out of me.....