⟵ hearthere ⟶
  • Workshops
  • External connections
  • Tableau и PowerBI
  • Knowledge base
  • Reference to the data of a temporary table
  • Loss of connection to the database during high data traffic
  • Save file in the field by external url link
  • Generating a list of rows marked with checkboxes and sending it to print
  • Adding a loop to the cycle table using a button from the temporary table
  • The TryCatch function and data transfer after a rollback
  • Access error when navigating to the cycle if the first table is unavailable to the user
  • The architecture of a system calculating balances for a cash register or warehouse
  • Sorting during selection based on the display of the Select field rather than its underlying value
  • Blocking the entry of duplicate values
  • Tabular display in the contextual panel
  • Sorting rows in a table using a button
  • How to retrieve a value based on a condition from a list of nested arrays?
  • Reset the ID counter in the table
  • Hiding a field in the table based on a condition
  • Action confirmation when clicking a button in a contextual window
  • Recalculation of a large table
  • How to sum values in `rowList` by one of the keys (one of the columns)
  • Field sets based on conditions when opening via `linkToTable`
  • How to delay the execution of an action and perform it in the background
  • Creating and deleting rows when selecting values in a Select or Select-tree
  • `selectRowListForSelect` with a condition where the current value is displayed as strikethrough
  • Not all external requests to Remotes are executed, causing the ID counter to break
  • Sorting Calculated Tables in a Cycle
  • How to pass data as numbers when making a POST request to a third-party API (must be an "integer")
  • How to create a chart when there are multiple parameters
  • Saving the initial values in a field when the field is calculated by code
  • Auto-filling the values of subsequent fields based on the selection in the first field
  • How to use a button in a temporary table to write data into a field in a calculated table within a cycle?
  • Display values from two fields of another table in a single Select field
  • #$ndts does not add seconds to a field of type Date
  • Calculator button in a field
  • Export CSV without technical data
  • Send an HTML list of field values via email
  • How to send multiple files via email in a single message
  • Action triggered by clicking a button in a sent email
  • Quick form and passing information to it from the DOM
  • Retrieve the pinning (pin) or locking (hand) status for a cell
  • Columns are displayed with incorrect sizes
  • Rebuild a multidimensional array into a one-dimensional array
  • Configuring the system's global search to search by a part of the entered number, not just from the beginning
  • How to remove artifacts from the global search across the system
  • Is it possible to launch a temporary table from a tree?
  • Output the values of multiple fields as text separated by a "separator"
  • Filter a list by the key `value`
  • Select all values belonging to a category in a field of type Select-tree
  • Hide the "eye" and "print" icons for users
  • Line break in text when sending an email
  • Sending a file via email without saving it in the database
  • Transferring files from a temporary table to a regular table
  • Codes in fields only work in a specific order, but I need to move the field to the front
  • Data format in PostgreSQL when accessed from an external BI system
  • Composite conditions in `WHERE` parameters
  • Uniqueness check during addition plus removal of extra characters
  • Replacing empty values in dates within `rowList`
  • Blocking the update of calculations in fields based on a condition
  • An anonymous table calls remotes, but data is not returned to the anonymous table even when a hash is passed
  • Back button
  • Working with a value from a pre-filter in `linkToInputSelect`
  • The absence of the three-dot button in an iframe
  • Block file deletion in a field of type File
  • How to enable preview for PDF files
  • Changing the `name` of an already created table
  • Checking field relationships in a table within a project
  • User IDs considering their roles for `notificationSend`
  • Adjusting access settings for Meilisearch results based on roles
  • Personalized sorting in a table
  • Editing a field of type File
  • Send a file from the panel without saving
  • How to alternate colors for days of the week in a table
  • Client registration/authentication through a form
  • LDAP ("ERROR: Operations error")
  • selectRowList: How to collect all data from the list
  • How to add an image to a print template?
  • Is it possible to remove field header titles and the space they occupy?
  • How to pass a pre-filter parameter when creating a cycle?
  • Saving passwords from a form into the Users table
  • How to validate a login in a quick registration form?
  • Missing keys in the response from an external API
  • Restrict a specific user’s access to only the row in the table linked to them
  • How to make a user see only the table inside a cycle but not the cycle table itself?
  • Display only unique values in the selection list of a pre-filter with a select
  • How to restrict a user from changing their password?
  • How to enable navigation to different tables in a cycle based on roles during its creation?
  • Additional information in a cycle table field from inside the cycle
  • How to determine if a row is the last one in a column?
  • Return a list of only those values from the original list that are unique (appear only once)
  • Open a string as a link starting with `https://`
  • The `panelImg` function: How to set an image as a preview from another table?
  • The system slows down with more than 10 users online
  • Row numbering based on the date in the Date field
  • Send files from multiple table rows via email
  • How to display the name or order number in the Tree instead of the cycle ID when opening a cycle?
  • The order of tab display in a cycle
  • Strict filtering in a field of type Select when selecting a value
  • Getting the ordinal week number of a month for a given date
  • Tracking changes in multiple fields
  • Select based on data created in another field of the same table
  • Replacing values in a list with new composite ones
  • Optimization of calculations in a table when the computation is duplicated between code and formatting code
  • Do not execute action code if the change is triggered by a script
  • Do not change the value in a cell if the action is not completed

    • Composite conditions in `WHERE` parameters

    Question

    I can't understand why the following code isn't working. Please help me figure it out.

    =: setList(table: 'main_table'; field: 'status' = 5; where: cond`'date' < $#nd && 'status' != 5`; log: true)

    Answer

    The fact is that the cond syntactic construction does not work in the where parameters of functions. In where, a special qrow construction can be used, which allows you to set various search conditions for the database.

    =: select(table: $#ntn; field: 'id'; where: qrow`'field_1' > 100 || 'field_2' = true`)

    qrow supports operators:

    • && — AND

    • || — OR

    • () — grouping

    Comparison operators are similar to the operators of the rest of the system.

    Name parameters are specified in single quotes 'field_1'

    In the comparison 'field_1' > 100, one name parameter must be used.

    Name parameters can be used on both sides of the comparison 'field_1' > 'field_2' — select rows where field_1 > field_2.

    Example with grouping:

    =: select(table: $#ntn; field: 'id'; where: qrow`'(field_1' > 100 && 'field_3' = true) || 'field_2' = true`)

    field_1 is greater than 100 and field_3 = true or field_2 equals true

    At the same level, operators must be the same!

    Together with qrow, several where can be used, they work in AND mode:

    =: select(table: $#ntn; field: 'id'; where: qrow`'(field_1' > 100 && 'field_3' = true) || 'field_2' = true`; where: 'filed_4' = false)

    (field_1 is greater than 100 and field_3 = true or field_2 equals true) and filed_4 = false

    If you use id in comparisons in AND mode, the query will execute much faster if you put this condition in a separate where first

    =: select(table: $#ntn; field: 'id'; where: 'id' != #id; where: qrow`'(field_1' > 100 && 'field_3' = true) || 'field_2' = true`)

    id is not equal to the current row id and (field_1 is greater than 100 and field_3 = true or field_2 equals true)

    In your case, the code with qrow will look like this:

    =: setList(table: 'main_table'; field: 'status' = 5; where: qrow`'date' < $#nd && 'status' != 5`; log: true)

    But for such simple conditions, it is better to use several where parameters:

    =: setList(table: 'main_table'; field: 'status' = 5; where: 'date' < $#nd; where: 'status' != 5; log: true)