Table Box/ Straight Table

[#1]

Hi All

I have a table box consisting of fields:

[NAME]   [GUID]   [USER_ID]   [MODEL]

I only want the table to populate results if the "Model" field is not null based on the selection criteria.

How can I do this?

[simondachstr]

Think of maybe creating a straight table instead and suppressing nulls on the Model field

[MK_QSL · Accepted solution]

Instead of MODEL use below

If(IsNull(MODEL) or LEN(TRIM(MODEL))=0,NULL(),1) as MODEL

Now create a table box and go to presentation tab...

SELECT MODEL and tick Omit Rows Where field is NULL

[#4]

Hi Manish

I'm pulling the MODEL field from a SQL table so therefore I can't use the QV expresion.

Or should I first get it from SQL then write the expression to recreate the field?

[#5]

Tabla:

SQL

SELECT *

FROM TABLE;

then in the resident load use the expression given by Manish.

LOAD

If(IsNull(MODEL) or LEN(TRIM(MODEL))=0,NULL(),1) as MODEL

RESIDENT Tabla;

Hope it helps!

Regards