Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The convention for storing the primary key in a database custom field is to mark the primary key field in the query using "as pk".

Example 1:

Let's use a nested select in a dynamic query for an example:

...

Info
If the parent field does not have associated a child custom field, there is no need to use to search by primary key.

Example 2:

For those fields, the query should look like:

...