Can not make Postgres connection work

[AhmedBytesBits]

Hi Lowdefy team,
I am struggling to populate postgres lookup table to a selector following the dynamodb example
here is my page:

id: add_professional_drawer
type: Drawer
properties:
  title: Add a new professional
  width: 400
layout:
  contentGutter: 16
requests:
  - id: statuses_selector
    type: KnexBuilder
    connectionId: postgres
    properties:
      query:
        - select:
            - value
            - label
            - disabled
        - from:
          - professionals_statuses

events:
  onEnter:
    - id: fetch_statuses
      type: Request
      params: statuses_selector
blocks:
  - id: first-name
    type: TextInput
    required: true
    layout:
      span: 12
    properties:
      title: First name
  - id: last-name
    type: TextInput
    required: true
    layout:
      span: 12
    properties:
      title: Last name
  - id: status
    type: Selector
    properties:
      title: Status
      placeholder: Assign Status
      options:
        _request: statuses_selector
  - id: reset_button
    type: Button
    layout:
      span: 12 # Set the size of the button (span 12 of 24 columns)
    properties:
      title: Reset
      block: true # Make the button fill all the space available to it
      type: default # Make the button a plain button
      icon: ClearOutlined
    events:
      onClick:
        - id: reset
          type: Reset
  - id: submit_button
    type: Button
    layout:
      span: 12
    properties:
      title: Submit
      block: true
      type: primary # Make the button a primary button with color
      icon: SaveOutlined
    events:
      onClick:
        - id: validate
          type: Validate

And here is my table professionals_statuses structure:

• label
• value
• disabled

Finally hereunder my connection:

id: postgres
type: Knex
properties:
  client: postgres
  connection:
    _secret: PG_CONNECTION_STRING
  searchPath:
    - knex
    - public
   

[Gervwyk]

Hi @ahmedrshdy
The onEnter event is only available for context blocks, the Drawer block is a container block. Try adding the Request action to the context block in which the Drawer is placed.

For more detail on how this works, the first block of a page must be a context block type. This creates a state and all the scaffolding required to execute requests, actions, etc. All child blocks of a context share the same state. Since actions fire sequentially, there is only one onEnter event per context and it is defined on the context block.

For most purposes, one context per page is all you need. Also, see Context and State and Events and Actions for more details.

I have not tested it, please let us know if this does not resolve your issue.

[AhmedBytesBits]

@Gervwyk
Thanks for your prompt and detailed help. I have moved the requests block to the parent page ad it worked as expected.
I am willing to contribute some examples to community, how can I do this?
Thanks again

[Gervwyk]

Glad it worked!

Examples are most lacking! That would be super ⚡️
Perhaps it would be easiest to discuss some ideas regarding this, send us a mail at hello@lowdefy.com and we'll set something up?

[AhmedBytesBits]

sure