How to add extension fields to standard queries [C4C ONLY]
1. Create your fields on the business object extension.
2. Create a “Process Extension Scenario”, and check the “Query” services.
3. Add the “Scenario” tag to your fields.
Result: you can now query using your extension fields as parameters via ABSL or UI Designer.
Fantastic! So now I can create a Custom Query for Customer/Account with a indicator from a Custom BO??
Can I use SADL Query in UI Designer for the above thing! because we need SADL query for Basic filter
You don't need to do it. All extension fields are available by default on a SADL query. If you create a SADL query for Opportunity in my example, you wouldn't need the PES file.
Make sense?
Yes, Sorry my mistake. it is an extension BO. Now the issue I want to filter out Accounts if that indicator is Checked / ticked from Standard Screen of Account OWL is it feasible via above steps?
For example : I have an indicator isBuilding. Hence I know that that customer is NOT an accoutn but a Building so dont want it to be appear in Account OWL.
I hope i am clear sorry for my mistake 🙂
You can add the field to the find forms and filter manually:
🙂
what if i dont want user to display the paramater i want that field should be by default selected when firing query...
I don't think this is possible. I'd be surprised (and happy) in case it is.
Sorry! 🙁
Fernando
yes even i think it is not possible i tried for few days then i left 😀 bt it was very important for customers so we used saved searches 🙁
You can basically add your extension fields to standard queries.. no custom BO involved here. For custom BOs you can create your own queries.
Hi Fernando,
I cannot find any Query service in Sales Order when I create a process extension scenario. I want to add my extension field to SalesOrder.QueryByElements.
I find Sales-General Information (Service name QuerySalesOrderIn).
I checked it in my process extension scenario. But I cannot find my extension field in Sales Order's QueryByElements and I cannot query with my extension field.
Best Regards
Fred
Hello Fred,
I've checked in our systems here and unfortuately Fernando`s suggestion works only in C4C, but not in ByD. 🙁
But you may use this approach.
Sorry,
Horst
Hi Horst,
Thanks for the suggestion but I want to use the query in PDI.
Best Regards
Fred
Hello Fred,
The query extension parameters are part of the backend query.
But of course only for the BO which is directly used in the UI.
In many cases this is an Enhanced Controller BO (ECO), which does not help you as those ECOs are never PSM released. 🙁
Sorry,
Horst
Nice blog! Very useful to know.
Just a little remark.
When you already have your Process extension Scenarion created and assigned to your extension field, do not forget to activate your extension field again to make the changes to your PES effective.
Have a great one everybody.
Best regards.
Jacques-Antoine Ollier
gracias por tu ayuda, necesito extender un Lead, es decir, debo agregar dos campos, podrias brindarme algo de tus conocimientos?
Saludos,
Hi ,
I have been able to extend query for standard Customer BO and added 2 fields successfully. I can use them in my query as parameter. but I have an issue, when I try to read these fields as result. result do not acknowledge them. any help or pointer would be much appreciated.