Skip to content

Odd SQL Grid Functionality Tricks

Jump to bottom
sdougwillo edited this page Jul 16, 2018 · 5 revisions

The NLS SQL Grid is useful for anyone who doesn't know how to write an SQL statement, like a normal floor manager, but is very limited in comparison to writing an actual SQL statement. This page is for any interesting quirks people may find that will help expand on the grid's use.

Tables

loanacct

Unlisted Fields

  • loan_group_no - Enables campaigns by loan group rather than portfolio

Criteria

  • = TODAY will not work, but TODAY does, as well as >= or <= TODAY, and < TODAY+1 works
  • status_code_no: 0,1, and 2 are reserved for Active, Closed, Restructured. Beyond that are the status codes you have added to your system.

Hello NLS (Just another Collaboration site for fellow NLS users)

"Learning Together"... "Developing Together"... "Testing Together"... "Building Together"

Clone this wiki locally