I have a top 5 Items saved search which is i'm sorting in descending order by Count so I can see Highest bought item top 5 items. I want to show that same saved search in a suitelet using Search.create. How I can sort it and show in the suitelet. I'm trying to add the sort.desc thingi but it is not working !! My Code:

var itemSearchObj = search.create({

type: "item", filters: [ ["transaction.type","anyof","VendBill"], "AND", ["displayname","isnotempty",""], "AND", ["displayname","doesnotcontain","arcutover"], "AND", ["subsidiary","noneof","17"], "AND", ["vendor.internalid","anyof",vendorName] ], columns: [ search.createColumn({ name: "displayname", summary: "GROUP", label: "Display Name" }), search.createColumn({ name: "salesdescription", summary: "GROUP", label: "Description" }), search.createColumn({ name: "custitem_company", summary: "GROUP", label: "Manufacturer" }), search.createColumn({ name: "tranid", join: "transaction", summary: "COUNT", sort: search.Sort.DESC, label: "Document Number" }) ] }); var searchResultCount = itemSearchObj.runPaged().count; log.debug("itemSearchObj result count",searchResultCount); var i=0; itemSearchObj.run().each(function(result){ if(i<5){ if(result.getValue({name: "displayname"})!='') outstandingOppoSublist.setSublistValue({ id : 'sublist_item', line : i, value : result.getValue({name: "displayname", summary: "GROUP"}) }); if(result.getValue({name: "salesdescription"})!='') outstandingOppoSublist.setSublistValue({ id : 'sublist_des', line : i, value : result.getValue({ name: "salesdescription", summary: "GROUP"}) }); if(result.getValue({name: "custitem_company"})!='') outstandingOppoSublist.setSublistValue({ id : 'sublist_make', line : i, value : result.getText({ name: "custitem_company", summary: "GROUP"}) }); if(result.getValue({name: "tranid"})!='') outstandingOppoSublist.setSublistValue({ id : 'sublist_count', line : i, value : result.getValue({name: "tranid", join: "transaction", summary: "COUNT",sort: search.Sort.DESC}) }); i++; } return true; });

not working can mean too many things, narrow it down with a more detailed explanation on what its doing

not working means, I'm not getting the top 5 items for the vendor which are bought highest. ex. if x item is bought 10 times from vendor v and y items is bought 7 times then x items should show first then y and then others which have less count!! right now I'm showing 5 items using i variable but those items are not having highest count!

You need to take a look at channel's description/topic. It just takes CTRL + SHIFT + ENTER . Code becomes more readable with that.

outstandingOppoSublist.setSublistValue({
		  id : 'sublist_count',
		  line : i,
		  value : result.getValue({name: "tranid",
         join: "transaction",
         summary: "COUNT",sort: search.Sort.DESC})

try this bit without the sort?

outstandingOppoSublist.setSublistValue({
		  id : 'sublist_count',
		  line : i,
		  value : result.getValue({name: "tranid",
         join: "transaction",
         summary: "COUNT"})

I would recommend to build the search in the UI and then load it via code, then all your sorting and info is separate from your code

probably need to look closer at what its doing

Yes it is ignoring the sort

Or is the sorting not what you expect, like doing lexicographical order vs numeric sort

In the search we can directly select the field and select sort by Descending... So it gets sorted but that is not working in code... I'm trying to show it on Suitelet! The Sort should be numeric! Since I want to show highest count row at top...

If you load the search via code the sort order should be maintained, no?

I think so... I'll be checking that..

the search module is not quite as good at the mimicking the ui as the other modules

If the Loading search does not work... Any one have any idea for making it work??

nilesh says the sort is ignored, and not lexigraphical, so thats probably not the problem

you can see the search top count on right side of the search!

That looks the actual saved search, i meant the suitelet

here

One of the statements you told us is false

Untitled

vendor.internalid is not the name of a column

Loading of saved search is also not working

its not your problem

my results are not sorted mate

sorted

I mean it should give me highest count at the top right?

go through my previous responses, thats not the behavior of the search module

so I need to develop a logic to get what I need , search module can't do it right?

it can

how? search.sort.desc?

do you understand the behavior?

yah

of the script module concerning sorting and column types?

thats not going to do anything more than what you have already done

i really don't understand how to sort it then I think😅

you mean search module doesn't support it I have to use my coding logic to sort it right?

the message after that one

i got that but I couldn't get how to resolve it now?

tranid is a text column

ohk you mean the count column is a text column ? if I convert that to numeric then it will work right?

i mean that tranid is a text column, so the search module will sort it as text

what if I use internal id of that tran id?