Skip to main content
Question

IAL - cannot use "CR"."OBJVERSION"

  • April 7, 2026
  • 1 reply
  • 8 views
M
Sidekick (Customer)
Forum|alt.badge.img+7

Hello,

I have following query in IAL:

SELECT
            pf.project_id
        FROM
                 &AO..contract_revision cr
            INNER JOIN &AO..sales_contract_cfv c ON cr.contract_no = c.contract_no
            INNER JOIN &AO..project_forecast   pf ON cf$_mci_project_id = pf.project_id

and WHERE:

      cr.objstate = 'Active'
            AND pf.forecast_type_id = 'BUD'
            AND pf.active_budget_db = 'TRUE'
            AND pf.latest_snapshot_date > TO_DATE(cr.objversion, 'YYYYMMDD HH24:MI:SS')

When save I have the error

cr.objversion ins not a valid object

1 reply

InfFilipV
Hero (Partner)
Forum|alt.badge.img+12
  • InfFilipV
  • Hero (Partner)
  • April 10, 2026

Hi,
SQL queries are analyzed from the end, so error shows incorrect cr.objversion, but actually whole Where Clause is incorrect.

When you are using field Where Clause you can reffer only to attributes included in Select Statement.

Do not split it, leave whole select together.

SELECT
   pf.project_id
FROM
   &AO..contract_revision cr
INNER JOIN &AO..sales_contract_cfv c ON
   c.contract_no = cr.contract_no
INNER JOIN &AO..project_forecast pf ON
   pf.project_id = c.cf$_mci_project_id
   AND pf.forecast_type_id = 'BUD'
   AND pf.active_budget_db = 'TRUE'
   AND pf.latest_snapshot_date > TO_DATE(cr.objversion, 'YYYYMMDD HH24:MI:SS')
WHERE
   cr.objstate = 'Active'

 

Filip | Developer | InfoConsulting.com
Terms & ConditionsCookie settingsAccessibility statement