on 11-14-2007 6:58 PM
Hi Sapers,
I want to create a new field called "TIMEZONE" on icw on identify account. Based on this new field or combination of fields, I want to search the Accounts.
I know we have the BOL Entity "BuilHeaderSearch", but this "Timezone" is not EEWB field.
I can see the TIME_ZONE field in the children entity of "BuilHeaderSearch", i.,e "BuilStandardAddress".
I am able to just add the new field on ICW though workbench, but my query is not working. I didnt add any code to include the logic for this new field.
i dont know where I have to add the logic.
Could you please tell me, what I am trying to achieve is legal?
If so, please could anyone explain with a sample example .
I really appreciate it.
Thnks in advance all.
SR
Hi Sreesanth,
The search is performed in
class CL_BUIL_HEADER, method Get_Result_Table
you might think of to create your own class and redefine the above method.
and assign it to BuilHeader in spro...->generic interaction layer/object layer -> component specific settings.
But in this method, the real search is performed using TREX_BUPA_SEARCH.
I checked the function module definition, there is no timezone field defined as one of the searching criteria.
You might have to think of another way to filter the search result returned by TREX_BUPA_SEARCH in your own class/method.
Hope this could do help!
Hongyan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Shao,
Sorry for late reply.
Ya I got it, But It works with the combination of other standard fields and my new field. What If user searches with only newly created field "timezone". It should return the records.
I understand your solution, but in single value (new field) search, it fails to get records by "TREX_BUPA_SEARCH" FM.
Kindly reply me .
Thanks again.
SR
(this is for CRM 5.0)
Hi SR,
I know this might be too late already. Just want to put some feedback when possible.
Yeah, you are right, if "timezone" is the only criteria put, the previous suggestion will not work.
You mght have to go bit further into TREX_BUPA_SEARCH to check whether
CL_TREX_BP
method TREX_ADD_QUERY
is ready for this new field or not.
and also enhance
CL_TREX_BP
method TREX_FILL_QUERY_TABLE
and
FM TREX_BUPA_SEARCH
a lot of work necessary. 😛
Hongyan
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.