Which Action + setup for creating a Button

[#1]

Good day,

I have the following issue. I made a chart, containing the script below.

TRACE ### Verzoeken Verplichting Type 204;

SQL SELECT FreeguidField_01 as Verplichting_ID_Verzoek,

FreeBoolField_01 AS Verplichting_204,

Case when FreeBoolField_01 = '1' Then 'Lopende Verplichting Afgeboekt' ELSE 'Openstaande Verplichtingen' END as Verplichting_PV,

RelatedRequestID as Verplichting_Aanvraag_ID

FROM Synergy.dbo.Absences

Where type in (204)

;

It works perfect and I can select 'Lopende Verplichting Afgeboekt' or 'Openstaande Verplichtingen'

Instead of the selection box, I would like to create a button with only the selection of 'Openstaande Verplichtingen'

I tried several Actions in the setup of a new button, but somehow none works.

Can someone help me with this?

Thanks in advance!

Regards,

Kees-Jan

[Agis-Kalogiannis · Accepted solution]

Try the action

Selection -> Select in Field

And then for

Field type Verplichting_PV

and for

String type Openstaande Verplichtingen

Thanks

Agis

[#3]

Dear Agis,

It works! Thank you very much.

Regards,

Kees-Jan