# Data grid in content view

# Show the top builder pane

Datagrid Builder click SQL builder tools icon in the lower left corner of workspace, then Builder pane will show on the top Datagrid toolbar

# Select columns

  • step 1: click Column button to switch to column tab
  • step 2: select columns you want
  • step 3: click Apply button(right most) on the toolbar

# Add where statement

  • step 1: click Where button to switch to where tab
  • step 2: click the plus button to add conditions
  • step 3: then you could click bracket button to add bracket(left or right)
  • step 4: add more conditions as you need.
  • step 5: click Apply button(right most) on the toolbar

# Add sort column

  • step 1: click Order button to switch to order tab
  • step 2: click the plus button to add order columns
  • step 3: then choose column name and order method
  • step 4: click Apply button(right most) on the toolbar

# Add dataset limit

  • step 1: click Limit button to switch to limit tab
  • step 2: input page rows limit number in the entry
  • step 3: click Apply button(right most) on the toolbar

# Change edit mode

  • step 1: click mode icon on the datagrid toolbar
  • step 2: then choose mode on the pop over gui;