cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to sort saved query displayed in product cockpit based on there creation time instead of name?

Former Member
0 Likes
177

I have created a two saved query using impex.

 #1st saved query
 INSERT_UPDATE CockpitSavedQuery;code[unique=true];label;user(uid);selectedTypeCode;selectedTemplateCode;defaultViewMode;
 ;offMyDummyFlag_OnMyFlag;bbbb;admin;MyProduct;MyProduct;LIST;
 # catalogVersions pk is required 
 INSERT CockpitSavedParameterValue;operatorQualifier;parameterQualifier;rawValue;cockpitSavedQuery(code)[default=offMyDummyFlag_OnMyFlag]; 
 ;in;selectedCatalogVersions;8796093055577,8796093088345,8796093121113,8796093153881,8796093186649,8796093252185,8796093219417;
 ;in;selectedCategories;;
 ;equals;Product.myFlag;dHJ1ZQ==;
 ;equals;MyProduct.myDummyFlag;ZmFsc2U=;
 
 INSERT_UPDATE CockpitSavedSortCriterion;criterionQualifier;asc;cockpitSavedQuery(code)[unique=true];
 ;Item.modifiedtime;true;offMyDummyFlag_OnMyFlag;
 
 #2nd saved query
 INSERT_UPDATE CockpitSavedQuery;code[unique=true];label;user(uid);selectedTypeCode;selectedTemplateCode;defaultViewMode;
 ;onMyDummyFlag_OffMyFlag;aaaaa;admin;GTProduct;GTProduct;LIST;
  
 # catalogVersions pk is required webDisplayFlag off and stocklevelflag true, 
 INSERT CockpitSavedParameterValue;operatorQualifier;parameterQualifier;rawValue;cockpitSavedQuery(code)[default=onMyDummyFlag_OffMyFlag]; 
 ;in;selectedCatalogVersions;8796093055577,8796093088345,8796093121113,8796093153881,8796093186649,8796093252185,8796093219417;
 ;in;selectedCategories;;
 ;equals;Product.myFlag;ZmFsc2U=;
 ;equals;MyProduct.myDummyFlag;dHJ1ZQ==;
 
 INSERT_UPDATE CockpitSavedSortCriterion;criterionQualifier;asc;cockpitSavedQuery(code)[unique=true];
 ;Item.modifiedtime;true;onMyDummyFlag_OffMyFlag;


I just want to display saved query having 'bbbb' label first and then 'aaaa' label saved query. but 'aaaa' is getting displayed first in product cockpit.

Accepted Solutions (0)

Answers (0)