Sql Help....

[CheGuevara]

try this:

 

 

UPDATE AKDC_DYNAMIC_CONTENT
SET last_modified_date =
  (SELECT (SYSDATE - TO_DATE('01-01-1970 00:00:00', 'DD-MM-YYYY HH24:MI:SS')) * 24 * 60 * 60 * 1000
  FROM DUAL
  )
WHERE EVA_DYNAMIC_ENTITY_ID IN
  (
  WITH parents AS
  (SELECT adc.id                    AS entity_id,
    adc.type_id                     AS published_id,
    em_parents.migratable_reference AS content_id
  FROM AKDC_DYNAMIC_CONTENT adc
  INNER JOIN
    (SELECT em.ENTITY_ID,
      em.migratable_reference
    FROM EVA_MIGRATABLE em
    WHERE em.migratable_reference IN
      (SELECT edefv.field_value
      FROM eva_dynamic_entity_field_value edefv
      WHERE edefv.DYN_ENTITY_FIELD_ID =
        (SELECT edef.id
        FROM eva_entity_definition eed,
          eva_dynamic_entity_field edef
        WHERE eed.id  = edef.ENTITY_DEF_ID
        AND eed.name  = 'KnowledgeBusinessFAQED'
        AND edef.name = 'bfaqparentId'
        )
      AND edefv.FIELD_VALUE IS NOT NULL
      AND edefv.field_value LIKE 'KB%'
      )
    AND em.IS_DELETED = 'N'
    ) em_parents
  ON EM_PARENTS.ENTITY_ID = ADC.ID
  )
  SELECT eva_dynamic_entity_id
  FROM EVA_DYNAMIC_ENTITY_FIELD_VALUE
  WHERE FIELD_VALUE IN
    (SELECT content_id FROM parents
    )
  );

[4Vikram]

Née saaman koskeltadanta

[andhravodu]

try this:

 

 

UPDATE AKDC_DYNAMIC_CONTENT
SET last_modified_date =
  (SELECT (SYSDATE - TO_DATE('01-01-1970 00:00:00', 'DD-MM-YYYY HH24:MI:SS')) * 24 * 60 * 60 * 1000
  FROM DUAL
  )
WHERE EVA_DYNAMIC_ENTITY_ID IN
  (
  WITH parents AS
  (SELECT adc.id                    AS entity_id,
    adc.type_id                     AS published_id,
    em_parents.migratable_reference AS content_id
  FROM AKDC_DYNAMIC_CONTENT adc
  INNER JOIN
    (SELECT em.ENTITY_ID,
      em.migratable_reference
    FROM EVA_MIGRATABLE em
    WHERE em.migratable_reference IN
      (SELECT edefv.field_value
      FROM eva_dynamic_entity_field_value edefv
      WHERE edefv.DYN_ENTITY_FIELD_ID =
        (SELECT edef.id
        FROM eva_entity_definition eed,
          eva_dynamic_entity_field edef
        WHERE eed.id  = edef.ENTITY_DEF_ID
        AND eed.name  = 'KnowledgeBusinessFAQED'
        AND edef.name = 'bfaqparentId'
        )
      AND edefv.FIELD_VALUE IS NOT NULL
      AND edefv.field_value LIKE 'KB%'
      )
    AND em.IS_DELETED = 'N'
    ) em_parents
  ON EM_PARENTS.ENTITY_ID = ADC.ID
  )
  SELECT eva_dynamic_entity_id
  FROM EVA_DYNAMIC_ENTITY_FIELD_VALUE
  WHERE FIELD_VALUE IN
    (SELECT content_id FROM parents
    )
  );

 

 

work kadu. WITH eppudu paina undali

[andhravodu]

nuvvu parents ani with vadavu, Update appudu referring inner query lo. adi issue, update kottinappudu join parents ane table not found ani Oracle neeku cheptundi

[PLANATRONICS]

nuvvu parents ani with vadavu, Update appudu referring inner query lo. adi issue, update kottinappudu join parents ane table not found ani Oracle neeku cheptundi

 

ardham kaledhu bhayya...

[PLANATRONICS]

nuvvu parents ani with vadavu, Update appudu referring inner query lo. adi issue, update kottinappudu join parents ane table not found ani Oracle neeku cheptundi

 

dheeniki solution enti bhayya?

[CheGuevara]

work kadu. WITH eppudu paina undali

Wrong perception... I have used several times and it worked

[CheGuevara]

dheeniki solution enti bhayya?

Meeda cheppindi try chesava

[PLANATRONICS]

Meeda cheppindi try chesava

 

no change in the date even after running the command

[andhravodu]

idi try cheyi, kani performance doubt naku

 

MERGE INTO AKDC_DYNAMIC_CONTENT chld
USING (
select eva_dynamic_entity_id prnt_dynamic_entity_id
 from EVA_DYNAMIC_ENTITY_FIELD_VALUE where FIELD_VALUE IN
(
select content_id from(
 select
   adc.id as entity_id,
   adc.type_id as published_id,
   em_parents.migratable_reference as content_id
 from AKDC_DYNAMIC_CONTENT adc
 inner join
     (select em.ENTITY_ID, em.migratable_reference from EVA_MIGRATABLE em
       where em.migratable_reference in
         (select edefv.field_value from eva_dynamic_entity_field_value edefv
           where edefv.DYN_ENTITY_FIELD_ID =
             (select edef.id from eva_entity_definition eed, eva_dynamic_entity_field edef
               where
                 eed.id = edef.ENTITY_DEF_ID
                 and eed.name = 'KnowledgeBusinessFAQED'
                 and edef.name = 'bfaqparentId')
             and edefv.FIELD_VALUE is not null
             and edefv.field_value like 'KB%')
       and em.IS_DELETED = 'N') em_parents
   on em_parents.entity_id = adc.id
) prnt
on ( chld.EVA_DYNAMIC_ENTITY_ID = prnt.prnt_dynamic_entity_id )
WHEN MATCHED THEN
UPDATE SET last_modified_date =
                (SELECT (SYSDATE - TO_DATE('01-01-1970 00:00:00', 'DD-MM-YYYY HH24:MI:SS')) * 24 * 60 * 60 * 1000 FROM DUAL) ;

[CheGuevara]

no change in the date even after running the command

Output zero rows updated ani vachinda... Aite check the logic... Query crt gane undi logic chusuko once

[arshad]

please kncham telugu lo chepava

Velli 1go

[4Vikram]

Velli 1go

vuuuu