If you open a table in LISA you will get a graphical representation, similar to how it will look in Lime CRM. Once the table is opened, click anywhere in the header on the table and you can choose properties for the table to the right. Besides the properties you specified when you created the table, you can also choose for example where in LIME the table should appear (“Table Order”) and which actionpad should be the default (the html-area to the left when you open an object for this table in LIME).

You can also add a descriptive expression, which is used to specify which information should be printed out when using an object of this table. An empty descriptive expression will return the id number of the object. See example below

As described, Descriptive Expressions are SQL code. When typing them, the format is that you write the following

SELECT --This is predefined and not visible

[company].[name]–this is what you modify

FROM [tablename] WHERE [idTABLENAME]= THE_ID_OF_THE_CURRENT CARD –This is predefined and not visible

If you need to do a subquery, you should have it within (). An example could be when getting something from the string table, to get the text from an option field. See the example below as well.

SELECT --This is predefined and not visible

(SELECT [da] FROM [string] WHERE [idstirng] = [company].[buyingstatus] -- this is what you modify

FROM [tablename] WHERE [idTABLENAME] = THE_ID_OF_THE_CURRENT_CARD -- This is predefined and not visible

In the above example we get the Danish text from the option field Buying Status.

If you need to combine multiple things, you can do it by using the + sign. Just remember that you need to add whitespaces manually.

[company].[name] + ' - ' + [company].[city]

The above example simply adds the Company name, then a whitespace a - another whitespace and then the city.

Here you can find code to descriptive expressions that we use often. This code can be a start point that you can modify when creating your own descriptive expressions.

Company name as descriptive on an other card

Set company name as descriptive expression on a Role table (not on the company card, if you have an other table just change role to your table name):

(Select[name]from[company]where[company].[idcompany]=[role].[company])

An option from a option list as descriptive

If you want to have a option from a option list as a dresciptive expression use the following code. This eg. gets the TypeOfRole from a Role table to be used as a descriptive expression. If you want to get an other language change sv to correct language.

(Select[sv]from[string]where[string].[idstring]=[role].[typeofrole])

Two fields as descriptive expression

If you also want to have the company name and role as a descriptive expression, eg. "Lundalogik - Supplier" (Supplier is a 'typeofrole') use the following code:

(Select[name]from[company]where[comany].[idcompany]=[role].[company])+' - '+(Select[sv]from[string]where[string].[idstring]=[role].[typeofrole])

Don't forget the brackets!

With the record access functionality it is possible to filter records the users have access to in a specific table. For example a salesman in Denmark will only have access to Danish companies while a salesman in Sweden will only have access to Swedish companies.

There are two different ways of setting record access. The first one involves building a query and the second one writing an SQL function. Building a query is the easiest way of setting record access, but when you need additional functionality or when you want to optimize performance a writing an SQL function is usually a better choice. To activate record access on a table the property Record Access must be set to Function or LIME Access Query. If it is set to None record access will be deactivated even if a query is built and/or a function is created.

company.office.region = activeuser.office.region