How to sort dropdown dynamic entries list?

[Former Member]

Hi All,

I can't find a way to sort dropdown dynamic list values in VC 7.2.

Visual Composer 7.0 has functionality for sort dropdown dynamic list according to help.sap.com documentation

http://help.sap.com/saphelp_crm60/helpdata/en/e3/00db4269b2f340e10000000a1550b0/frameset.htm

But I can not find sort checkbox for Dynamical Entries List in VC 7.2.

And in 7.3 as well.

Does SAP remove this functionality from versions 7.1, 7.2, 7.3?

[former_member202465 · Accepted solution]

Hi Renat,

I think in this case we need to "model" the sorting. We could create a Service Component model that contains the Data Service + Sort Operator. Then we consume this model in the Entry List.

1. Create the Service Component:

2. Model it this way:

Make sure you keep the same interface as in the Data Service, e.g. drag from the input port of the service to create the Data In element (here called in1). Connect a Filter Operator and then a Data Out element. In the Filter define the conditions needed.

3. In the Entry List definition select the new Service Component to be consumed. You could use the advanced search option.

Hope this helps.

Thanks,

Udi

[Former Member · Accepted solution]

Hi Udi

Thank you for reply.

Yes It works good..

But one more question. 

We can't test this way in data source with huge number of records.

We have data source with 500 records only.

So, we can not estimate the impact to performance in case of this way.

Can you make a supposition about the impact of this way on performance in the case of several million records in the data source?

Regards...
Renat

[former_member202465 · Accepted solution]

Hi Renat,

About compare with VC 7.0:

I guess that using the check box to sort the list has to activate some kind of sort algorithm that takes time. So the sorting work needs to be done there as well.

If using huge number of records is still an issue:

I guess this is not relevant for the Dropdown List control, but only for the Combo Box (actually opens a popup). I could suggest to use one of the following, where getting the data (and thus the sorting) is done once:

- Using a Table inside a popup. this table is populated once. the popup is opened on button press for selecting the value for a field (I could show an example if needed).

- If the Drop Down is located on some input form (now recordset with multiple records), then a cache for the Entry List could be used. see http://scn.sap.com/docs/DOC-33533 for more detail.

Finally, if you use your own backend then having the backend code return a sorted data using SQL "order by", is always fastest (-:

Thanks,

Udi

[former_member203185 · Accepted solution]

Hi,

The article by the following link http://scn.sap.com/docs/DOC-33533 has been wonderful.

But where have pictures disappeared to?

I haven't managed to understand anything without them.

Sincerely,

Anton

[former_member202465 · Accepted solution]

Hi Anton,

Could it be a matter of browser? In IE it looks OK...

Thanks,

Udi

[former_member203185 · Accepted solution]

Hi,

surprisingly, but I have used IE exactly. Version of 9.0.8112.16421

It lookas as in the screenshot below:

As well, I have tried sume other browsers such as Google Chrome and Mozilla and the picture is the same.

I would like to ask you if it isn't complicated for you, could you plase make a couple screenshots of your absolutely useful article an place them here to see VC model flow and views?

The pictures are very important.

Thank you in advance.

Sincerely,

Anton

[anja_engelhardt2 · Accepted solution]

Hi Anton,

Did you try to reload by pressing 'F5'? I have this with the first picture as well. Maybe it just takes some more time.

Best regards,

Anja

[former_member202465 · Accepted solution]

Hi Anton,

I have now experienced the same as Anja. Also right click => show image did the job.

So if this works for you - great.

In any case, I asked someone from the company about this so I hope this is soon solved, or at least that we know more about what to expect.

Thanks,

Udi

[former_member203185 · Accepted solution]

Oh, nothing mentioned helps me.

Finally I revealed that the host https://wiki.wdf.sap.corp/ isn't available from my side.

But screenshots are placed there.

Maybe it is internal corporate resource which is unavailable outside?

Before I asked some my colleagues to try to load the article and result is the same, pictures are unavailable.

Can you help me to get access to the screenshots ?

Sincerely,

ANton

[anja_engelhardt2 · Accepted solution]

You might be correct - our corp adresses shouldn't be visible outside.

[former_member203185 · Accepted solution]

Hi Anja,

thank you for joining or discussion and clarifying the situation.

If so, I would like to ask Ehud to upload the screenshots which are so important for the article.

Sincerely,

Anton

[former_member202465 · Accepted solution]

Hi Anton,

I was given this link about known issues / bug reporting:

http://scn.sap.com/community/support/scn-bug-reporting

Could you please see whether it's a known issue / report it?

thanks,

Udi

[former_member203185 · Accepted solution]

Hi,

thank you for the link especially I didn't know yet about such reports. Thanks.

I have posted the question. It is still for approval.

Will see.

I will inform you about the results.

Best Regards

[former_member203185 · Accepted solution]

Hi Ehud,

as I promised you I am happy to provide you information related the issue, I am about missed images in your article.

It has been fixed today.

By the following link below you can find the real cause of the problem:

http://scn.sap.com/thread/3350953

Thank you for your tolerance.

Best Regards,

Anton

[former_member202465 · Accepted solution]

Hi Anton, thanks for the update! Heppy to here it's OK now. I talked to the technical SCN guys to see if I should have done something differently... seems not (-:

[former_member203185 · Accepted solution]

Hi,

than I suppose that it was an SCN issue which has been resolved by technical support. Seems OK.

Best Regards,

Anton