Adding a data field to a Birst Query Object

These instructions describe how to add a new field to a Birst Query Object using the ism_fs_contract_mst_extension query object as an example.

  1. In Birst, select the [Tenant]-ISM-Dimension-Extension space.
  2. Select Modeler > Connect > ISM Infor Data Lake.
  3. Hover your mouse over the ism_fs_contract_mst_extension object, click on the down arrow and select Edit.
  4. In the Query text box, add a comma after the last field in the query's SELECT statement.
    Each new field must be added as the last field in the SELECT statement.
  5. Press Enter.
  6. Specify the new field name on the blank line.
    Field names are case sensitive.
    Example:
    SELECT
/* Required Attributes */
"ism_fs_contract_mst"."CreateDate",
"ism_fs_contract_mst"."CreatedBy",
"ism_fs_contract_mst"."DLDeleteIndicator",
"ism_fs_contract_mst"."InWorkflow",
"ism_fs_contract_mst"."NoteExistsFlag",
"ism_fs_contract_mst"."RecordDate",
"ism_fs_contract_mst"."RowPointer",
"ism_fs_contract_mst"."UpdatedBy",
"ism_fs_contract_mst"."VariationNumber", 
"ism_fs_contract_mst"."site_ref", 
"ism_fs_contract_mst"."contract", 
"ism_fs_contract_mst"."lastModified" 

/*  User Attributes Below (Don't forget comma after 
	last attribute above)  */

FROM "ism_fs_contract_mst"
WHERE "ism_fs_contract_mst"."lastModified" >=  'V{InforISM_fs_contract_ExtractDate}'
  7. Click Save.
  8. A preview of the newly modified query is displayed. If the preview does not display, or the newly-added fields are not included, check your edits and save again.