GeeKs Blogging @ dotCOM

Let's share…
  • Home
  • About
  • Contribute
  • How To – FAQs
  • Disclaimer
  • Terms & Conditions
8 Jun 2009

Siebel – EAI Siebel Adapter Search Spec

by Vikas Luthra


Hi,

I can bet that for anybody who has worked on Siebel EAI, ‘EAI Siebel Adapter’ is not an Alien term. This post is about EAI Siebel Adapter’s Query method.

How to restrict the number of Child records returned in Siebel adapter’s Query.

Scenario – Order and related Order Line Items

The way EAI Siebel Adapter’s Query method works is that, you specify the name of the IO in ‘OutputIntObjectName’ argument and row id of the parent record in ‘PrimaryRowId’ argument. However this way the query method will fetch all the Line Items for that Order.

So here, to restrict the number of Line Items returned (at the child Line Item level) in the EAI Siebel Adapter Query, we can use another input argument of Query method, which is ‘SearchSpec’.

The value for the ‘SearchSpec’ argument is an expression based on any field from the IC’s of the integration Object, with the dot notation. Not all of us would know that we can use it to restrict the number of child records returned.

Sample Expression: [Order Entry - Line Items.Source] = ‘Testing’

This expression means only the line itemitems where the field ‘Source’ of ‘Order Entry – Line Items’ BC has value ‘Testing’, will be retrieved in the output Siebel Message.

Just creating the expression for the ‘SearchSpec’ argument is a trick here.

In our requirement the user can select multiple line items, say out of 14 line items he has selected only 5 and clicks on ‘Sync Selected’ button. Now we have to create an expression based on selected line items and then pass it as a process property to the workflow where we are using the Siebel Adapter. The sample script for creating expression is pasted below:-

(Note: Here the variable SearchSp is an expression string which will be passed as an input to the workflow)

RecExists = this.BusComp().FirstSelected();
      while (RecExists)
        {
         rec[i] = this.BusComp().GetFieldValue(“Id”);
          RecExists = this.BusComp().NextSelected();
            i++;
           }
           SearchSp = “[Order Entry - Line Items.Id]=’” + selrec[0] + “‘”;
         
           for(x = 1; x < selrec.length; x++)
           {
            SearchSp = SearchSp + ” OR ” + “[Order Entry - Line Items.Id]=’” + selrec[x] + “‘”;
           
           }

That’s it! We hope this helps somebody someday.

Tags: EAI, Siebel, Tips, Tricks, Tutorials, Workarounds, workflows



For regular updates, enter your email address below. We don't spam, we don't share with others!




This entry was posted on Monday, June 8th, 2009 at 1:13 PM and is filed under Siebel CRM. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Siebel – EAI Siebel Adapter Search Spec”

  1. Ankur Saxena says:
    June 8, 2009 at 4:56 PM

    Nicely explained…
    Keep it up…

Leave a Reply

Click here to cancel reply.

You must be logged in to post a comment.


« Siebel Sales Wireless on Google Android
Siebel EIM – Custom table mapping »



  • Admin Controls

    • Log in
  • Talk to us

    • Bouquets, brickbats, suggestions, complaints?

    • Click here...
  • Authorships

    • We are currently looking out for active authors. Are you willing to contribute?

    • Please click here

    • Everyone's invited..
  • Subscribe by Email


    • For regular updates, enter your email address below. We don't spam, we don't share with others!

  • Sponsors

  • Subscribe

    • Entries (RSS)
    • Comments (RSS)
  • Siebel Bookshelf

  • Daily Dilbert

    •          
  • Categories

    • Admin Notifications (9)
    • Business Intelligence (2)
      • Actuate (2)
    • CRM (118)
      • CRM News (6)
      • Sage Software / ACT! (1)
      • Salesforce.com (2)
      • Siebel CRM (106)
    • EAI (2)
    • Events (1)
    • FUN 'n' FROLIC (6)
    • Hot Technologies (7)
    • IT News (47)
    • Meet the Author (9)
    • ORACLE (15)
      • Database (2)
      • Oracle Fusion Applications Stack (8)
      • Oracle Policy Automation (1)
    • Product Demostrations (5)
    • Uncategorized (4)
  • Tag Cloud

    Admin Admin Notifications Applet Author Introductions Business Component Calculated Function Certification CFG file Client Configuration Critique CRM Database Debugging EAI EIM eScript Fundamentals Fusion Middleware Google IT News License Login Microsoft ORACLE Oracle Fusion Applications Performance problems Product Defect Product Demostrations Salesforce Scriptless solutions Security Server Siebel Siebel Secrets SOA Tips Tools Tricks Tutorials Upgrade User Property Workarounds workflows



  • Archives

    • May 2013
    • February 2013
    • January 2013
    • August 2012
    • August 2011
    • July 2011
    • June 2011
    • May 2011
    • April 2011
    • November 2010
    • August 2010
    • May 2010
    • April 2010
    • March 2010
    • February 2010
    • January 2010
    • December 2009
    • November 2009
    • October 2009
    • September 2009
    • August 2009
    • July 2009
    • June 2009
    • May 2009
    • April 2009
    • March 2009
  • Authors

    • Ankit Bhardwaj
    • Ashish Kaul
    • brijesh
    • Himanshu Bajpai
    • Madhvi Arora
    • nanpats
    • Nitin Jain
    • Prachi Sharma
    • Renuka Ankam
    • Vikas Luthra
  • Administrators

    • geeksblogging@gmail.com
    • admin@geeksbloggingat.com

Fresh Ideas

  • How long do you think Siebel CRM will be around ?
  • Still confused about the Oracle roadmap for Siebel CRM ?
  • Oracle VM 3.2 Now Available
  • Oracle Policy Modelling (OPM) - Unable to compile Excel documents
  • Login Failed in Dedicated Web Client : MVF Issue
  • Oracle Fusion Applications price list
  • Research to Development - Fusion Apps Series
  • Oracle ACE Program
  • HCM user Experience through UI - Fusion Apps series
  • "Managing Oracle Fusion Applications"

Just Said

  • Abhay on Siebel – SIA BC Utility Service – Loop multiple records
  • SriRam Sudarsan on Siebel – Installer hangs midway
  • Joey on Oracle Policy Modelling (OPM) – Unable to compile Excel documents
  • chandra on Siebel – Unable to login to mobile client
  • Varun P M on Siebel – Installer hangs midway
  • Mat on Siebel – EAI Siebel Adapter – Looping Multiple Records
  • Nitin Jain on Siebel – EAI Siebel Adapter – Looping Multiple Records
  • Nitin Jain on Siebel – EAI Siebel Adapter – Looping Multiple Records
  • Mat on Siebel – EAI Siebel Adapter – Looping Multiple Records
  • Sheldon on Siebel – EAI JMS Transport

Most Commented

  • Siebel - SIA BC Utility Service - Loop multiple records
  • Siebel - Installer hangs midway
  • Siebel - Adding License Keys to Sample
  • Siebel - Reading data directly from Siebel SRF
  • Siebel - Popup Update Only
  • Siebel - Automatic User Logout
  • Siebel - EAI Queue - Usage
  • Siebel - Looping multiple records - Update records
  • Siebel - SIS OM PMT Service
  • Siebel Tools hangs when checking out objects

Old Favourites

  • Highrise Customer Relationship Management
  • Siebel - Autosave Opportunity data - Sample Code
  • Siebel - Autosave Opportunity data - The concept
  • Renuka Ankam
  • Siebel - Merge Records - Checklist
  • Siebel - Fetch Active view properties - III
  • Oracle 11g Certification coming soon
  • Siebel - Fetch Active view properties - II
  • Siebel - Fetch Active view properties
  • Siebel - Automating Merge Records by script - II

If you also want to write on GeeksBlogging@dotCOM, click here. Area of Specialization no constraint. Become Famous!


Entries (RSS) and Comments (RSS).