Uploaded image for project: 'In-Portal CMS'
  1. In-Portal CMS
  2. INP-785

Wildcard "%1$s" isn't processed during total calculation in calculated fields

    XMLWordPrintable

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.1.1
    • Fix Version/s: 5.1.2-B2
    • Component/s: Data Management
    • Labels:
      None

      Description

      In-Portal uses kDBList class for database table data retrieval and display. It can display:

      • database fields (fields from current table)
      • calculated fields (field expressions, that even could data form JOINed tables)

      For example based on this database query:

      [b]SELECT main.FieldName, %1$s.FieldName AS OtherField, joined.FieldName2 AS FieldNameX
      FROM table1 AS main
      LEFT JOIN table2 AS joined ON joined.FieldA = main.FieldB[/b]

      In example above FieldName is field from this table and FieldNameX is field name from joined table.

      Wildcard "%1$s" can be used to reference main table (instead of specifying "main" each time). This works too.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alex Alex
                Reporter:
                alex Alex
                Developer:
                Alex
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: