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 [idstring] = [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!

Please see Record access