When I just updated new updates recently, i found that when i use quick search when Refined Search function available will make error.
Please check if this is a bug or just my bad in coding?
Thank you.
One more condition to make this error occurred: in Query, the Refined Search field is used in Where condition OR table join condition
Same problem here, I hope it will be fix soon
Usually that error is related to fields assigned as Search Fields that doesnt exists.
For example, you created a field “field1” this field is inside QuickSearch fields, but now this field doesn’t exists anymore and is not removed for QuickSearch fields. Scroll that HTML error to see exactly the error.
All the field exist, it’s working ok in production which was generated by a previous version of scriptcase. In my case if I include de “city field” the search will not work, but work fine if I remove it from the search selected field
Same as Mr.jlboutin60. The function worked fine with a previous version of Scriptcase. When I updated new version, the error occurred, with no change on the existing application.
This is the response from server when I use Quick Search with Refined Search activated:
Error
Error while accessing the database
SQLState: 42000 Error Code: 8120 Message: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Column ‘nm_sel_esp.Item_No’ is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
select Brand_description, COUNT(*) AS countTest,Item_No from (SELECT Item_No, Divisions_code, Divisions_description, Brand_description, Line_description, Sub_line_description, Beauty_category_Level_3_code, Beauty_category_Level_2_code, Beauty_category_Level_1, Beauty_category_Level_2, Beauty_category_Level_3, Invoice_Price, Currency, Gia_Von_VND, Nominal_value, Season, FG_POSID, FG_POS, LV2_POS, Category, SelfLife, Subtype, Volume, VolumeInv, Unit_pack, Manufacturer_ID, ManuFullName, Manu_Location_ID, ENGManuLoc, VIEManuLoc, Ingredients, Ingredients_1, Cach_dung, Cach_Dung_1, Bao_quan, Bao_Quan_1, Luu_y, Luu_y_1, CFSNo, PIF_Date, Licence_No_, Licence_Expiry_Date, Label_size, HSCode, Old_HSCode_10_digits, ImpTaxRate, VAT, Discontinued_Flag, Alternative_Product, Discontinuing_Date, Dis_note, Ordered_status, Width, “Depth”, Height, N_W_per_pcs, Unit_mL_g, Nguoi_yc_tao_code, Ngay_yc, Artworks, Tier1, Safety_Assessment, Certificate_of_analysis, Product_Specifications, Use_direction_To_use, Outer_package_Photo, Sub_label, Formula_code, Line_code, Sub_line_code, Beauty_category_Level1_ID, Beauty_category_Level2_ID, Beauty_category_Level3_ID, LV2_FG_POS, ProductSpecificationTestMethod, Full_Name_by_English, Full_Name_by_Vietnamese, Name_by_Vietnamese_for, Code1 ,Short_Name_by_English ,Short_Name_by_Vietnamese ,SPF ,Barcode ,Reference_code ,Unit_Price ,Unit_Price_VAT ,COGS ,FOB_price ,Last_Trans ,Stock_Store ,Stock_Warehouse FROM dbo.NAV_ItemMasterData with(nolock) where Brand_description in ( select brand_description from NAV_ItemMasterData_AuthorizationMatrix WITH (NOLOCK) where brand_code in ( select brand from openquery(“UTM_MYSQL”,‘SELECT * FROM scv_business_process.sec_users_brand_report’) where login=’’ OR login=‘admin’ ) )) nm_sel_esp where (Item_No like ‘%a%’) GROUP BY Brand_description order by Brand_description ASC
Just updated with version V9.2.012 and the problem is still present
yes. I hope Scriptcase team could fix this issue at the earliest.
Just updated with version V9.2.014 and the problem is still present
Just updated with version V9.2.015 and the problem is still present
SRIPTCASE fix this plz
In my case the error appears when i use a field in the refined search with a LOOKUP in the field propreties.
REFINED search works like it should even with fields with a LOOKUP
The error ONLY appears using QUICK SEARCH in combination with a field in the REFINED SEARCH section using LOOKUP-function
Error discovered OCT 3rd and STILL NOT fixed by SC!!!
Just updated with version V9.2.016 and the problem is still present
Bug has been fixed in v9.3. Thanks.