K Knowledge Base
K Knowledge Base
Breadcrumbs

Code Search

K can help you identify measures, procedures, and other code objects that match a specific search criteria.

The Code Search application searches a source object's code for content that matches your criteria. Common scenarios where Code Search is helpful include:

  • Identifying measures that use hard-coded logic requiring a change

  • Identifying procedures that use a specific variable or filter condition

  1. Navigate to K Applications → Code Search

  2. Enter your search keyword or expression

  3. Submit the search — K will generate an extract of all code objects matching your criteria

  4. You will be taken to the results page where the extract will be available to download after a short wait

Code Search extract

The extract includes the following details for each matching object:

Column

Description

Example

object_type

Type of object

dataset_field

object_name

Name of the object

fy_flag

sub_type

Sub-type of the object

measure

source_type

Source system of the object

powerbi

location

Location of the object in K

Power BI / My Workspace

code

The code recorded for the object

IF(REF_DATE[FISCAL_YEAR] = YEAR(TODAY()) + TRUNC(MONTH(TODAY())/7), 1, 0)

total_usage

Total usage count for the object

10

code_url

URL of the object in K


active

Current state of the object in K

true

Helpful tips

  • Code Search extracts are only available for 7 days. Download a copy for future reference before the extract expires.

  • If you click Rerun without changing any criteria, the current extract will be overwritten.