WITH_STATUS

A data.world specific function for controlling the formatting of query results. Cells with WITH_STATUS specified will be displayed with the selected status color in data.world query results. WITH_STATUS is intended to be used with the STATUS function for pre-defined colors for particular highlighting needs. For any other uses (e.g. export to CSV or API access), the WITH_STATUS specification is ignored

Parameter	Type
`value`	string, formattedtext
`status`	color

Returns: formattedtext

Example

query:

SELECT WITH_STATUS("dave", STATUS("info")) as name

siyeh/sql-crm-example-data Run query Copy code

results:

name
dave