Why don’t MS Teams apply Truncation Search Algorithm?

Image for post
Image for post
https://tryshift.com/blog/apps-hub/microsoft-teams-vs-slack/

Search

Both MS Teams and Slack allows searching through all chat sessions, putting an end to the nightmare of trying to find one comment among thousands. If you’ve opted for the free version of Slack, however, the search function only applies to the 10,000 most recent messages.

Microsoft’s WhoBot tool helps with search in MS Teams. This search bot crawls your entire company intranet to surface the data you’re looking for. It also helps you access subject matter experts within your organization so you can find the best person for what you’re looking for.

Anyway Slack allows you to search through 10,000 most recent messages by using Truncation Search Algorithm while MS Teams doesn’t allow this. …


Using Case Sensitivity (alternative to ILIKE)

Image for post
Image for post
Photo by White.RainForest ∙ 易雨白林. on Unsplash

LIKE

The LIKE conditions specify a test involving pattern matching. Whereas the equality operator (=) exactly matches one character value to another, the LIKE conditions match a portion of one character value to another by searching the first value for the pattern specified by the second.

The following query finds the salaries of all employees with the name ‘SM%’. Oracle interprets ‘SM%’ as a text literal, rather than as a pattern, because it precedes the LIKE keyword:

SELECT salary 
FROM employees
WHERE 'SM%' LIKE last_name;

ILIKE

There are noILIKEcondition in Oracle SQL, but you still can have alternative way to do it.

Using Case Sensitivity (alternative to ILIKE)

Case is significant in all conditions comparing character expressions that the LIKE condition and the equality (=) operators. You can use the UPPER function to perform a case-insensitive match, as in this condition:

UPPER(last_name) LIKE 'SM%'

REF : https://docs.oracle.com/cd/B13789_01/server.101/b10759/conditions016.htm


this command line enables you to copy the standard input from terminal window to your clipboard enabling you to paste it to other applications.

Image for post
Image for post

pbcopy on a mac enables you to copy the standard input from terminal window to your clipboard enabling you to paste it to other applications.

You can replicate pbcopy on ubuntu by utilising a similar tool called xclip which does exactly the same. However its syntax is a little too verbose and I prefer to use OS X pbcopy command.

how to configure pbcopy on ubuntu

If you haven’t previously installed xclip simply run the following command in your terminal window:

sudo apt-get install xclip -y

Edit your BASH settings file using your favorite text editor.

nano ~/.bashrc

Then create an alias for pbcopy and pbpaste:

alias pbcopy=’xclip -selection clipboard’
alias pbpaste=’xclip -selection clipboard -o’

Close and save the file then just refresh your bash to import your new settings

source ~/.bashrc

Usage

pbcopy < /etc/resolv.conf

About

Cheav Sovannarith

👩‍💻

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store