Category Archives: Miscellaneous

Using Filters in Navision

Here is the breakdown of filters available.  When you enter criteria, you can use all the numbers and letters that you can normally use in the field. In addition, you can use some special symbols or mathematical expressions. Here are the available formats:

Symbol Meaning Sample Expression Records Displayed
= Equal to 377 Number 377
    BLUE Those with the BLUE code, for example, the BLUE warehouse code
    22 A datetime: from 22-current month-current year 0:00:00 to 22-current month-current year 22:59:59
    22 10 An exact datetime: 22-01-01 10:00:00
.. Interval 1100..2100 Numbers 1100 through 2100
    ..2500 Up to and including 2500
    ..12 31 00 Dates up to and including 12 31 00
    P8.. Information for accounting period 8 and thereafter
    ..23 From the beginning of time until 23-current month-current year 23:59:59
    23.. From 23-current month-current year 0:00:00 until the end of time
    22..23 From 22-current month-current year 0:00:00 until 23-current month-current year 23:59:59
| Either/or 1200|1300 Those with number 1200 or 1300
& And <2000&>1000 Numbers that are less than 2000 and greater than 1000.

The & sign cannot be used by itself with numbers because no record can have two numbers.

<> Not equal to <>0 All numbers except 0

The SQL Server Option allows you to combine this symbol with a wild card expression. For example, <>A* meaning not equal to any text that start with A.

> Greater than >1200 Numbers greater than 1200
>= Greater than or equal to >=1200 Numbers greater than or equal to 1200
< Less than <1200 Numbers less than 1200
<= Less than or equal to <=1200 Numbers less than or equal to 1200
* An indefinite number of unknown characters *Co* Text that contain “Co”
    *Co Text that end with “Co”
    Co* Text that begin with “Co”
? One unknown character Hans?n Text such as Hansen or Hanson
  Calculate before rest 30|(>=10&<=20) Those with number 30 or with a number from 10 through 20 (the result of the calculation within the parentheses)
@ Ignore case (either uppercase or lowercase allowed) @location Text such as LOCATION, location or Location

You can also combine the various format expressions:

5999|8100..8490 Include any records with the number 5999 or a number from the interval 8100 through 8490.
..1299|1400.. Include records with a number less than or equal to 1299 or a number equal to 1400 or greater (all numbers except 1300 through 1399).
>50&<100 Include records with numbers that are greater than 50 and less than 100 (numbers 51 through 99).
*A*&*B* Text containing both A and B.
@*No?* Text containing no, NO, No, nO, such as cot, cope and incorporated.

NO, nO, No or no must be present, followed by at least one character, but there can be an indefinite number of characters before and after these, and case is unimportant.

Leave a comment

Posted by on January 25, 2016 in Miscellaneous


Using WhatsApp on your Computer

For me, scrolling too much and typing long text on mobiles is very irritating but I love using WhatsApp for chatting and sharing whatever junk I have to share.

I was searching for ways as to how I can use WhatsApp on my computer.  I found a Chrome application ‘WhatsChrome’ that replicates my WhatsApp ID to my computer.

To install it on your computer just open and type  ‘WhatsChrome’ or ‘WhatsApp‘ in search box and hit Enter.

It will display some related apps.  I have tested ‘WhatsChrome’ and ‘WhatsApp Web Wrapper’.  Both are almost same apps developed by different developers.

To use them, you just need to click on ‘+ Add to Chrome’ button and rest everything will be done automatically.  On every run after installation, it asks to scan the barcode displayed on your computer screen.  For scanning this bardcode, open WhatsApp on your phone.  Go to Menu -> WhatsApp Web option.  It will open phone’s camera.  Place the phone in front of the screen to capture the barcode.

Scanning is quick.  Once scanned, it will open WhatsApp on your computer screen.  You may use this app to send and read the messages.

It will keep your phone in sync and for that, phone must be connected to internet.  If you are not connected to internet, you may not use WhatsApp on your computer.




Tags: ,

Chrome All in One Desktop

LG Chromebase 22CV241 - B All-in-One (4th Gen CDC / 2GB/ Google Chrome)

LG Chromebase 22CV241 – B All-in-One (4th Gen CDC / 2GB/ Google Chrome)

Recently I bought LG Chromebase 22CV241 for testing whether it may be useful for a normal user who usually works on browser, does a little word processing and uses spreadsheet a little.

It has been tested by several users and the feedback is very good.  Performance is excellent, big 21.5 inch Full HD display, built-in camera and mic etc attracts every user.  I personally feel that it can replace Windows PCs easily.  Some of the features are:

  • BRILLIANT 21.5(54.61 CMS) 1920X1080 FULL HD IPS DISPLAY
  • POWERED BY CHROME OS (100 GB of Google Drive space for 2 Years)

In my opinion it the best All In One Desktop for home users.

Leave a comment

Posted by on July 28, 2015 in Miscellaneous


Using PING command in Chrome OS

For using PING command in Chrome you will need to open Crosh. To open the Crosh, press Ctrl+Alt+T anywhere in Chrome OS. The Crosh shell will open in a browser tab.

  • CTRL + ALT + T will open Crosh tab with Crosh> command prompt.
  • Type ‘PING <IP Address>’.  In may case it was PING
  • Press ‘Enter’.  The command will start executing and will continue till CTRL+C is pressed.
  • Type EXIT and press Enter to go back.
Leave a comment

Posted by on July 28, 2015 in Chrome, Miscellaneous


Tags: , , , ,

Block or allow pop-ups for a specific site in Google Chrome

To manually allow pop-ups from a site:

  1. At the end of the address bar, click the pop-up blocker icon.
  2. Click the link for the pop-up window you’d like to see.
  3. To always see pop-ups for the site, select “Always show pop-ups from [site]” The site will be added to the exceptions list, which you can manage in the Content Settings dialog.

To always allow pop-ups from a particular site:

  1. In the top-right corner of Chrome, click the Chrome menu Chrome menu.
  2. Select Settings.
  3. Click Show advanced settings.
  4. Under “Privacy,” click the Content settings button.
  5. Under “Pop-ups,” click Manage exceptions.

Tags: , , , ,

Block or Allow Pop-Ups in Google Chrome

Turn Pop-Ups on or off

To block or allow pop-ups on your mobile device:

  1. Open the Chrome menu Menu.
  2. Touch Settings.
  3. Touch Site settings.
  4. Touch Pop-ups and then turn them on or off.

To block or allow Pop-Ups on your computer:

  1. In the top-right corner of Chrome, click the Chrome menu Chrome menu.
  2. Select Settings.
  3. Click Show advanced settings.
  4. Under “Privacy,” click the Content settings button.
  5. Under “Pop-ups,” select Do not allow any site to show pop-ups (recommended) or Allow all sites to show pop-ups.
Leave a comment

Posted by on July 15, 2015 in Internet, Miscellaneous


Tags: , , , ,

Samsung Galaxy Grand – Secret Codes

*#06# Show IMEI Number

*#2222# HW Version

*#34971539# Camera Firmware settings

*#9900# Sysdump (Logfiles etc.)

*#0228# Battery diagnostics

*#7353# Function testing

*#197328640# Service Mode Menu

*2767*3855# Factory Reset (not tested)

*#34971539# Camera Firmware Menu

*#197328640# – Service mode for testing

**05***# – Execute from Emergency dial screen to unlock PUK code

*#1234# View SW Version PDA, CSC, MODEM

*#03# — NAND Flash S/N

*#350# — Reboot

*#0011# — ServiceMode [1]

*#0228# — Battery status

*#0283# — Audio packet loopback test

*#0782# — Real Time Clock Test

*#0842# — Vibration Test

*#2663# — Touchscreen FW and version

*#7284# — Phone Utility (USB Settings) // WASNT ABLE TO UNDERSTAND-if u can please advise.

*#7353# — Self Test (Menu of 12 tests to use)

*#7594# — Factory mode >>>>Enable shutdown on long press

*#8888# — Service Mode (Read FTA hw version)

*#232338# — WLAN MAC address & PS mode

*#22558463# — Reset Total Call Time

*#12580*369# — Main Version (AP, CP, CSC, RF cal, HW Rev) (similar to 9999)

well this work on indian firmware too– i havent tried though

1. Dial *#197328640#
2. Now options 5 &6 are for Band Selection.  Option no.5- is for Sim1 and Option no-6- is for Sim2
3. Choose the one in which u want to make 3g only… in my case it was sim 2.. so i chose option no.6
4. Select wcdma band
5. Select wcdma all band

Leave a comment

Posted by on August 6, 2014 in Miscellaneous