Two filters in table.external_record_content_get

[den1s]

Hi.

I want to filter this by two variables

1. "model_id="+quote("00283")
2. "unavailable_date>=date()"

What syntax do i need to use to add item 2 above to the filter?

myvar=table.external_record_content_get("[PathAlias.ADB_Path]\tbl_unavailable_dates","(unavailable_date)","unavailable_date","model_id="+quote("00283"))

Thanks in advance.

Denis

[johnkoh]

Denis

vDynamic_model_id ="00283"
vfilter = "("model_id="+quote( vDynamic_model_id ) +" ) .and. ( "unavailable_date>="+s_quote( date() ) +" )"

myvar=table.external_record_content_get("[PathAlias.ADB_Path]\tbl_unavailable_dates","(unavailable_date)","unavailable_date", vfilter )

[Al Buchholz]

vDynamic_model_id ="00283"
vfilter = "(model_id="+quote( vDynamic_model_id ) +" ) .and. ( unavailable_date>="+s_quote( date() ) +" )"

?vfilter

Use this in the interactive window

?vfilter shows what is stored in the vfilter variable.

Modify the vfilter definition until you get something that looks correct and works.
I got this...

= (model_id="00283" ) .and. ( unavailable_date>={12/18/2018} )


Then use Jon's last line.
myvar=table.external_record_content_get("[PathAlias.ADB_Path]\tbl_unavailable_dates","(unavailable_date)","unavailable_date", vfilter )

[den1s]

Perfect. Thanks Al.