Uploaded image for project: 'ui-data-import'
  1. ui-data-import
  2. UIDATIMP-1204

Improve CQL queries for profiles retrieving

    XMLWordPrintable

Details

    • Folijet Sprint 143
    • 2
    • Folijet
    • Morning Glory (R2 2022)

    Description

      After upgrading RMB to v34.1.0 in the data-import-converter-storage module MODDICONV-249 it is necessary to change the CQL queries for profiles retrieving during linking them to other profile.

       

      It is needed to change the existing value for the query parameter "query" on the following pages:

      1. For the job profile create/edit page:
        request to get match profiles:
        /data-import-profiles/matchProfiles?limit=30&query=cql.allRecords=1 NOT incomingRecordType=STATIC_VALUE AND (id="" NOT id=="d27d71ce-8a1e-44c6-acea-96961b5592c6") AND (id="" NOT id=="31dbb554-0826-48ec-a0a4-3c55293d4dee")  sortBy name 
        
        should be changed with:
        /data-import-profiles/matchProfiles?limit=30&query=cql.allRecords=1 NOT incomingRecordType=STATIC_VALUE AND id<>(d27d71ce-8a1e-44c6-acea-96961b5592c6 AND 31dbb554-0826-48ec-a0a4-3c55293d4dee) sortBy name 
        

        request to get action profiles:

        /data-import-profiles/actionProfiles?limit=5000&query=cql.allRecords=1 AND (id="" NOT id=="d0ebba8a-2f0f-11eb-adc1-0242ac120002") AND (id="" NOT id=="cddff0e1-233c-47ba-8be5-553c632709d9") AND (id="" NOT id=="6aa8e98b-0d9f-41dd-b26f-15658d07eb52") AND (id="" NOT id=="f8e58651-f651-485d-aead-d2fa8700e2d1") AND (id="" NOT id=="f5feddba-f892-4fad-b702-e4e77f04f9a3")  
        
        should be changed with:
        /data-import-profiles/actionProfiles?limit=5000&query=cql.allRecords=1 AND id<>(d0ebba8a-2f0f-11eb-adc1-0242ac120002 AND cddff0e1-233c-47ba-8be5-553c632709d9 AND 6aa8e98b-0d9f-41dd-b26f-15658d07eb52 AND f8e58651-f651-485d-aead-d2fa8700e2d1 AND f5feddba-f892-4fad-b702-e4e77f04f9a3)
        
      2. For the action profile create/edit page:
        request to get mapping profiles:
        /data-import-profiles/mappingProfiles?limit=5000&query=cql.allRecords=1 AND (id="" NOT id=="d0ebbc2e-2f0f-11eb-adc1-0242ac120002") AND (id="" NOT id=="862000b9-84ea-4cae-a223-5fc0552f2b42") AND (id="" NOT id=="f90864ef-8030-480f-a43f-8cdd21233252") AND (id="" NOT id=="991c0300-44a6-47e3-8ea2-b01bb56a38cc") AND (id="" NOT id=="e0fbaad5-10c0-40d5-9228-498b351dbbaa")  sortBy name
        
        should be changed with:
        /data-import-profiles/mappingProfiles?limit=5000&query=cql.allRecords=1 AND id<>(d0ebbc2e-2f0f-11eb-adc1-0242ac120002 AND 862000b9-84ea-4cae-a223-5fc0552f2b42 AND f90864ef-8030-480f-a43f-8cdd21233252 AND 991c0300-44a6-47e3-8ea2-b01bb56a38cc AND e0fbaad5-10c0-40d5-9228-498b351dbbaa) sortBy name
        
      3. For the mapping profile create/edit page:
        request to get action profiles:
        /data-import-profiles/actionProfiles?limit=5000&query=cql.allRecords=1 AND (id="" NOT id=="d0ebba8a-2f0f-11eb-adc1-0242ac120002") AND (id="" NOT id=="cddff0e1-233c-47ba-8be5-553c632709d9") AND (id="" NOT id=="6aa8e98b-0d9f-41dd-b26f-15658d07eb52") AND (id="" NOT id=="f8e58651-f651-485d-aead-d2fa8700e2d1") AND (id="" NOT id=="f5feddba-f892-4fad-b702-e4e77f04f9a3")  sortBy name
        
        should be changed with:
        /data-import-profiles/actionProfiles?limit=5000&query=cql.allRecords=1 AND id<>(d0ebba8a-2f0f-11eb-adc1-0242ac120002 AND cddff0e1-233c-47ba-8be5-553c632709d9 AND 6aa8e98b-0d9f-41dd-b26f-15658d07eb52 AND f8e58651-f651-485d-aead-d2fa8700e2d1 AND f5feddba-f892-4fad-b702-e4e77f04f9a3) sortBy name
        

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                Mariia_Aloshyna Mariia Aloshyna
                ruslan_lavrov Ruslan Lavrov
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases