Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
0 Kudos

SLX Mobile Hash Queries with Property based Queries need to be User Friendly

Status: New
by Silver Contributor RJSamp on ‎12-11-2011 08:10 AM

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 by sData Entity Property...

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.....

Comments
by Gold Super Contributor RJLedger
on ‎12-11-2011 03:33 PM

The query setup (in the mobile web) is based completely on the SData Query specs. However,  the latest changes in the dojo code (still not yet beta ;-)  have a"hooks" that let you implement your own Where Clause query bypass/shortcuts... (not talking hash tags here.. but the "back end where they get processed). Just remember, it all has to finally become pure SData query based.

 

Do you really want to have yet another query processor.. w/another syntax?

We want to hear your cool ideas for enhancing Saleslogix products and services. So add your own ideas or kudo (vote) on the ideas of others here! Watch the most valuable bubble to the top!

I have an idea! How do I get started?

One
Read our submission guidelines.

Two
Search for your idea. If you don't see it, submit a new one!

Three
Provide feedback on the ideas of others by voting with kudos and adding comments.
For more information about using ideas, read this thread.

Four
Track your ideas and those you like. Once you've posted or kudoed and idea, subscribe to be notified via email of the latest updates to the idea. From within the idea, click "Idea Options" which appears above the idea title and choose, "Subscribe to this idea".

Be sure to check back from time to time to see new ideas and status updates!

Here is a quick list of the recent ideas for speedy browsing!
Labels