• RELEVANCY SCORE 3.54

    DB:3.54:Unique Search Operator sp





    I know how to find alla unique values using ScripMaker, but wouldnt it be great to have a operator to choose to find all unique values in a field.

    Say for example that you have a database with all zipcodes from a country with matching city names. Say you want to find all unique city names from that database table without having to use ScriptMaker, List()-function or a value list based on that field.

    Might be something useful in next version of FileMaker.

    DB:3.54:Unique Search Operator sp


    johanhedman wrote:

    Say you want to find all unique city names from that database table without having to use ScriptMaker, List()-function or a value list based on that field.

    In version 12, you could also use the ExecuteSQL() function.

  • RELEVANCY SCORE 3.49

    DB:3.49:Difference Between Unique And Distinct 9s




    Hi,
    can anyone explain about the difference between a unique operator and a distinct operator...???

    cheere

    DB:3.49:Difference Between Unique And Distinct 9s

    They do the same. Oracle documentation :

    DISTINCT | UNIQUE

    Specify DISTINCT or UNIQUE if you want Oracle to return only one copy of each set of duplicate rows selected (these two keywords are synonymous). Duplicate rows are those with matching values for each expression in the select list.

  • RELEVANCY SCORE 3.39

    DB:3.39:Phrase Search In Xplore 1.1 zp





    Hi All,

    I conducted a search test on FAST with the following results.

    Searched 'deuce' got 3 results; searched 'tennis' got 5 results. All these search items are unique to each documents. While I searched for 'deuce tennis', it gave 3+5 =8 results. It does an 'OR' between these search items.

    i condcuted the same search test against Xplore and got the following results

    Searched 'deuce' got 3 results; searched 'tennis' got 5 results. All these search items are unique to each documents. While I searched for 'deuce tennis', it gave 0 results. It seems to do an 'AND' between these search items and provides results only if these terms are available in the same document.

    Is there a way to configure Xplore tp mimic FAST's 'OR' operator. I need xplore to display results of documents that has 'deuce' and documents that has 'tennis' and those that have both these terms in it.

    I appreciate all inputs.

    Thanks,

    Arun

    DB:3.39:Phrase Search In Xplore 1.1 zp


    Actually, the DFC Search Service (which DA use too) supports a mini-language for full-text term. So you can have: foo or (bar and "a phrase"). And in this mini-language, a space means 'and'.

    There is a description in the documentation (the exact referenc evades me).

    It is interesting that the native query is DQL. By default it should be an XQuery statement. Did you configure something special in dfc.properties ?

    You cannot configure it but it can be customized. If you use 6.7, you can plug a 'dfc search filter'. If this is the version you use, let me know, I can write it, that would be a nice example for EDN.

    If you don't use 6.7, you can still do Webtop customization by extending the search component.

  • RELEVANCY SCORE 3.27

    DB:3.27:Can I Search For A Webapp Item By It's Unique Id Number? 81



    Can I search for a WebApp Item by it's unique ID number in a WebApp search form?

    DB:3.27:Can I Search For A Webapp Item By It's Unique Id Number? 81


    I've been searching for this as well, and while you can't search for a web app item by its ID no, you can link to it directly by using a URL with the web app id in it.

    See this discussion Re: Is it possible to use a web app id in the url?

  • RELEVANCY SCORE 3.18

    DB:3.18:Wildcard Usage In Webtop Advanced Search 3f



    Hi,

    My repository is full-text enabled and I'm running an advanced search query using * wildcard on some custom attribute using contains operator.It seems that to make this work I need to use the * wither at the beginning, inside the word or at the end of the word only. e.g.

    A search for "test" using generic_name (custom attribute) and contains operator does return expected resultA search for "t*st" using generic_name (custom attribute) and contains operator does return expected resultA search for "t*t" using generic_name (custom attribute) and contains operator does return expected resultA search for "tes*" using generic_name (custom attribute) and contains operator doesn't return expected resultA search for "*est" using generic_name (custom attribute) and contains operator doesn't return expected result, butA search for "*test*" using generic_name (custom attribute) and contains operator does return expected result

    Thus it seems if I have to use wildcard * I'll only have to use it in the following ways -

    To use it at the beginning or end I'll have to mention the whole word, not part of itI can use it within the word but the start and end letter should be mentioned

    This is not clearly mentioned in the webtop user guide and hence I'm not sure if this is a standard behavopr. Can you confirm this?

    Thanks,

    Soumik Ray

    DB:3.18:Wildcard Usage In Webtop Advanced Search 3f


    If I'm not wrong, DQL wild cards are percentage symbol (%) and Underscore (_).

    % denotes a set of characters and _ denotes a single character.

    Try using them and see if you are getting desired results. One more useful hint is to use double quotes around words with embedded spaces. For e.g, if you want to search for JOHN SMITH, try using "JOHN SMITH" for exact matches.

    -Sarma.

  • RELEVANCY SCORE 3.13

    DB:3.13:Unique Identifier For Search Result m1


    Is there any result field that I can use to uniquely identify a specific search result over multiple searches?For example:Result Set for green: A, B, CResult Set for (Unique ID of B): BI would think that the URL should be unique, but I'm not sure how to search for a specific URL.

    DB:3.13:Unique Identifier For Search Result m1

    Brandon:I tried with the following search:System.ItemUrlutlookexpress://%7BS-1-5-21-1482476501-1580436667-839522115-500%7D/%7BFD1376BB-A3AC-41B2-A5B1-7CB18579931E%7D/Local%20Folders/Inbox/~2.emlBut no results are returned. The equivalent search:System.Search.EntryID:383Does return results. Am I doing something wrong?Thanks!

  • RELEVANCY SCORE 3.05

    DB:3.05:In Operator In Idfsimpleattrexpression zm


    How can we implement IN operator in IDfSimpleAttrExpression?I have situation where users want to enter more than one value with comma to search for. We have custom search using IDfSimpleAttrExpressionThanks in advance

    DB:3.05:In Operator In Idfsimpleattrexpression zm

    You don't. To get the IN operator in the WHERE clause, you should be using the addValueListAttrExpression method of the IDfExpressionSet object. The IDFSimpleAttrExpression interface does not support the IN operator, that is what the IDfValueListAttrExpression interface is for and the method I referenced above returns an instance of an object that implements the IDfValueListAttrExpression interface as well as adds the returned object to the expression set. It's all spelled out pretty clearly in the DFC Javadocs.Hope this helps,Larry

  • RELEVANCY SCORE 3.04

    DB:3.04:Advanced Search - Value Assistance Conditional By Search Operator p9


    helloI've customised the advanced search using the Advanced Search with Value Assistance component from the component exchange and it all works. However when searching a value assisted attribute, I get the dropdown list regardless of which search operator I choose (contains, is, starts with, etc). What I want is the desktop client functionality of having value assistance when search by 'is' is selected but free text when searching by 'contains' or 'starts with' etc.I noticed that the page doesn't refresh when choosing a search operator so I presume no event is being called from it anyway. But is it possible?thanksMatt

    DB:3.04:Advanced Search - Value Assistance Conditional By Search Operator p9

    Hi,Did you ever get to solve this problem according to the solution suggested. ? Would appreciate any help .Thanks,pjoshi

  • RELEVANCY SCORE 3.04

    DB:3.04:Inurl: Operator Broken? kj


    I'm issuing a small number of queries through the Search API. Whenever my search query contains the inurl: operator, I get back an empty XML document.
     
    I can reproduce this through the live search UI too. Searching for anything with the inurl: operator on live.com gives me back an empty page. Anyone else notice this?
     
    The inurl: operator used to work just fine, but some time during the past few days it appears to have broken.

  • RELEVANCY SCORE 2.99

    DB:2.99:Add Search Operators Without Using Dab sa


    Is it possible to add additional search operators within Advanced Search without using DAB for a particular attribute?I'm needing to add the operator is not nullCheers

    DB:2.99:Add Search Operators Without Using Dab sa


    Hi Doz,

    Have you got any solution for the above. I am looking for an answer to the same issue, if you know please inform me.

    Regards,

    Ravi.

  • RELEVANCY SCORE 2.97

    DB:2.97:Advanced Search Operator ( Is / In ) px


    Hi Experts,Can anybody tell me what is the differents between the search operator "is" and "is in" ? It looks like not different on the search results when i try to perform the search. Thanks in advance.Regards,May Ling

  • RELEVANCY SCORE 2.96

    DB:2.96:How To Change Default Filter Operator To 'Contains' Instead Of 'Gt;=' x1



    Hi guys,

    Thought this would be relatively simple but I can't see where to to change this. Basically we have had a fair few folks ask if it is possible to change the default operator when using the 'Go to' search function from a '=' operator to a 'contains' operator.

    This must be possible right?

    Cheers,

    Daniel

    DB:2.96:How To Change Default Filter Operator To 'Contains' Instead Of 'Gt;=' x1


    The Go to search box doesn't always have = search option. It is dynamic. It is based on the user search input.

    For eg. If you enter 815 and hit enter. It will use ends with operator,

    If you enter 'INT00123456' and hit enter, it will use = operator,

    If you enter 'INT00123456 ' and hit enter, it will use = operator,

    If you enter *815 and hit enter, it will use contains operator. etc.

    Hope this helps.

    Br,

    Reza R.

  • RELEVANCY SCORE 2.96

    DB:2.96:Using Operators With Ultrasearch c1


    how to use other operator for example "LIKE" with ultra search.
    QueryAttribute class mention "AND" and "OR" operator

    example
    select * from emp where ename LIKE '%ITH'

    DB:2.96:Using Operators With Ultrasearch c1

    Henry,

    LIKE is a SQL operator not commonly used in search engines. I guess you are looking for a way to control how
    Ultra Search "wildcards" your queries.

    In the Ultra Search query screens we provide the standard search engine query syntax, which is, for example,

    "aeroplane" +"Wilbur Wright"

    to search for aviation articles written by Wilbur.

    We expand this search engine syntax to Oracle Text queries internally through our "Query Expansion Module". If you
    want to know how Text queries look like, see the Oracle Text Manual. Now you can customize the way our expansion
    module expands queries. This should give you a way to implement your LIKE syntax. Please contact me if you
    are interested to pursue this (My email: Stefan.Buchta@oracle.com).

    Stefan

  • RELEVANCY SCORE 2.95

    DB:2.95:Equivalence Operator - Special Characters dm


    I am facing the same problem as mentioned in the thread below:

    Equivalence Operator - Oracle Text Search

    Can anybody help?

    Thanks
    -G

    DB:2.95:Equivalence Operator - Special Characters dm

    just an FYI ... printjoin does not really apply if the LEXER is anything other than BASIC.

  • RELEVANCY SCORE 2.95

    DB:2.95:How To Generate Artifically Unquie Key For Target Table kj


    hi
    i want to generate artificial key in target table . i use sequence operator but in update it generate error
    (VLD-2780: Unable to generate Merge statement)

    More Over in my target table there is no unique value column thats why i need to generate unique key so it will used when record is updated

    plz explain in detail

    thnx in advance

    DB:2.95:How To Generate Artifically Unquie Key For Target Table kj

    Hi,

    connect your incoming key to y means that the source attribute that contains the id for matching must be connected to the column y of the target table.

    If the underlying physical target table changes, you may synchronize. This will remove the attribute y, so you have to recreate it.

    Regards,
    Carsten.

  • RELEVANCY SCORE 2.94

    DB:2.94:How To Use The Or Operator In Outlook 2010 Search Folders xc


    Hi,
    How do I accomplish search criteriawhenI want toselect a certain category OR a certain string in a subject?
    Thanks!

    DB:2.94:How To Use The Or Operator In Outlook 2010 Search Folders xc

    Check whether you can find the registry subkey under HKEY_CURRENT_USER\Software\WOW 6432 Node\Microsoft\Office\14.0\Outlookand verify the status.

  • RELEVANCY SCORE 2.92

    DB:2.92:Modification Of Search Criteria Operators List In Web 3p



    Hello ,

    We have a requirement to modify search criteria operators on Account WEB search.

    For search criteria "customer" and "prospective" I need to add operator "is not".

    I entered to trn SM34 , cluster CRMVC_DQ , search query BuilHeaderAdvancedSearch.

    I marked "NE" operator For attributes : "is_prospective""' is_customer". I can see this operator in Account search screen u2013 but search works incorrectly. I get the same results for search "is - X" and "is not u2013 X" search criteria.

    Any ideas? How can I solve this problem?

    Rika

    DB:2.92:Modification Of Search Criteria Operators List In Web 3p


    Hello ,

    We have a requirement to modify search criteria operators on Account WEB search.

    For search criteria "customer" and "prospective" I need to add operator "is not".

    I entered to trn SM34 , cluster CRMVC_DQ , search query BuilHeaderAdvancedSearch.

    I marked "NE" operator For attributes : "is_prospective""' is_customer". I can see this operator in Account search screen u2013 but search works incorrectly. I get the same results for search "is - X" and "is not u2013 X" search criteria.

    Any ideas? How can I solve this problem?

    Rika

  • RELEVANCY SCORE 2.91

    DB:2.91:Advanced Search: Missing Value In Inclusion Operator 8x


    Hi,

    Sharepoint 3.0 Search Server Express on SBS 2003 SP2.

    Advanced Search inclusion operator contains only: Equals and Does not
    equal for text based property.

    Isn't suppose to have also Contains, Does not contain? Is there any workaround?

    Faruk

    DB:2.91:Advanced Search: Missing Value In Inclusion Operator 8x

    Hello, I had the same problem than you, and I have found the solution here: http://blogs.msdn.com/ronalg/archive/2008/08/19/advanced-search-contains-option.aspxIf you have the opportunity, don't hesitate take a look to our MOSS blog http://virtualservergallery.com/Best regards,Foxk

  • RELEVANCY SCORE 2.90

    DB:2.90:Adding In Operator In View Criteria ax


    Hello,

    We are using Jdeveloper 11g,

    In the View criteria by default we are having the operator like Equals, Less than, Greater than, contains etc..
    is it possible to add IN operator?

    Our requirement is select more than one value from the search criteria LOV and use the IN operator for the filtering.

    Kindly help us.

    Regards,
    Vijay.

    DB:2.90:Adding In Operator In View Criteria ax

    This thread {message:id=9465537} outlines a possible solution (not fully tested).

    Timo

  • RELEVANCY SCORE 2.90

    DB:2.90:How Can I Merge Columns/Lists Of Data Into One Column Or List? d9



    I tried this:

    CPT:

    LOAD [Unique Identifier], [CPT_1] as CPTRESIDENT Claims;CPT:LOAD [Unique Identifier], [CPT_2] as CPTRESIDENT Claims;CPT:LOAD [Unique Identifier], [CPT_3] as CPTRESIDENT Claims;All the fields would appear in one list, but the search process did not work.

  • RELEVANCY SCORE 2.88

    DB:2.88:Peopletools - Ldap (Msad) Integration 89


    I'm tooling around with creating a process to create a shell/disabled Active Directory (AD) account when a new person is hired in the HR database. I've already successfully utilized the LDAP_SEARCH and LDAP_MODIFY business interlinks to read from and update the AD accounts that are linked with a PS Operator, so I know the server and search configurations are correct. We are also using LDAP authentication with these same servers in production.

    Today I thought I'd try the LDAP_ADD Business Interlink so I loaded and executed the BI after pulling individual attributes from my own AD account. I added a "9" to the sn attribute and did a replace of the sn portion of the DN to make it unique, and appended the same "9" to the sAMAccountName to make it unique also. Then I added the attributes :
    sn, givenName, displayName, department, company, name, employeeID, and sAMAccountName
    to the Business Interlink and performed the Execute().

    The BI returned with return status 65 and return status message Object class violation.

    Someone suggested leaving the DN blank and allowing AD to format it itself, so I did that. That time the BI returned with status 64 and status message Naming violation.

    I'm not an LDAP or AD expert (in fact don't even have access to AD), so keep it simple. Any suggestions ?
    TIA!

    DB:2.88:Peopletools - Ldap (Msad) Integration 89

    Before getting to the Interlink itself, is your configuration to the LDAP server complete?

    Enterprise Components Directory Interface Definitions Directory Configurations

    ... and from the server configuration when you access the Test Connectivity page are all the tests successful?

    If so then go the the delivered utility Enterprise Components Directory Interface Search Directory and build the search you'd like to send through the interlink and run it. Then when that search is successful, look at the code behind the 'Search' button and use it to build whatever process you need.

    I've successfully used the interlinks to Search, Add, Modify, and Delete AD users from the HR system.

  • RELEVANCY SCORE 2.88

    DB:2.88:Product Status Operator For Prodadvsearchrgproducts 7d


    Dear expert,in SAP Standard Query Object ProdAdvSearchRgProducts there is a field to search for specific status. Unfortunately the only operator for this search criteria is "EQ Equals". We would need to exclude specific status in our query. So we would need to activate the operator "NE Not Equal" for the search criteria of the product Status.Any Ideas?Thanks in advance,BR Matthias

    DB:2.88:Product Status Operator For Prodadvsearchrgproducts 7d

    Hi Matthias,have a look at this documentation regarding product search enhancement:[Adding Fields to the Product Search|http://help.sap.com/saphelp_crm70/helpdata/en/1e/4fa987cc214bd39964603e657c9192/content.htm]I think you have to "invert" the query at this position. The called search API is not capable of processing the not equals operator as far as I know. But you can achieve the same if you include all status except the one search for.Best Regards,Arne

  • RELEVANCY SCORE 2.87

    DB:2.87:How To Retreive The Selected Operator From The Advanced Search Panel. jd


    Hi,

    I have a search panel in which i am displaying advanced mode by default .I have a requirement to get the selected operator(equals,,,etc) on each attribute.How to get the operator on a attribute programmatically from the query listener.

    Thanks,
    Pradeep S

    DB:2.87:How To Retreive The Selected Operator From The Advanced Search Panel. jd

    Hi,

    I have a search panel in which i am displaying advanced mode by default .I have a requirement to get the selected operator(equals,,,etc) on each attribute.How to get the operator on a attribute programmatically from the query listener.

    Thanks,
    Pradeep S

  • RELEVANCY SCORE 2.87

    DB:2.87:Re: Float And == Operator f8


    this i understand ... but how (TF) are those objects
    compared - I'd like to know theirs unique identifiers
    - if this is possible In the same way that ALL, repeat ALL, references are compared. Surely the detail is unimportant as long as the JVM can determine whether or not they are the same object.

    I would very much doubt if the unique identifiers are available.

    DB:2.87:Re: Float And == Operator f8

    Float and all other non-primitive types are reference types. f1 and f2 are variables of a reference type. They are like "pointers" if you are familiar with C++ or something. So when you use ==, it sees if they both "point" to the same object. There is no way (I think) in the Java language to directly access the memory location of the object that is referenced; in order to protect you from bad stuff.

    The .hashCode() is not relevant to this, because its contract requires that if two things are .equals(), then their .hashCode() have to be the same.

    Because a Float object is immutable, it doesn't really matter if they use the same or different objects for the same number; except that you can test it through ==.

  • RELEVANCY SCORE 2.87

    DB:2.87:Advanced Search Operator ax



    Basically our customized search contains only restricted operator. I want to include " In" operator in oeprator list. Do I have to do in DAB ?

    Please let me know.

    DB:2.87:Advanced Search Operator ax

    Yes, you can do it in DAB or Composer. Search is configured for each attribute seperately. The Is opeator is already available in the list.

  • RELEVANCY SCORE 2.87

    DB:2.87:How To Include Null Value When Using Distinct Operator xs


    How can i include NULL value when using DISTINCT operator in SELECT statement while querying to get unique values of a column?

  • RELEVANCY SCORE 2.87

    DB:2.87:Change In Advanced Search z3



    Hi Experts,

    In CRM 2007, for any search, three columns appear.

    1. For Search Criteria

    2. For the Operator (Is, isnot, contains)

    3. For the Search Value

    The requirement is to hide the middle column- the relation calumn.

    Through configuration, I could set the default operator but am not able to hide it.

    How can I hide the operator column?

    regards,

    Ravindra Valy

    DB:2.87:Change In Advanced Search z3


    Hello Ravindra,

    If you actually hide the middle column or operators then how would you search for the fields. The search should be based on the field along with the relation. In case the reason of hiding the field is because the searches are based on the IS operator by default then i would recommend to have this relation column present and default the value to 'IS' as it would be helpful in future accomodation of the requirements.

    Kindly let me know if you like to clarify anymore.

    Reward if found useful.

    Regards,

    Harish P M

  • RELEVANCY SCORE 2.87

    DB:2.87:Advanced Search - Operator "Starts With" df


    Hi,I'm trying to use the operator "starts with".I have a STRING attribute with values "0000" to "9999" and i want to find all objects that starts with "01", but it isn't working, webtop remove the "0" at left and don't make search with only one character.Why advanced search remove the "0" of string clauses?Thank's

    DB:2.87:Advanced Search - Operator "Starts With" df

    Hi,I'm trying to use the operator "starts with".I have a STRING attribute with values "0000" to "9999" and i want to find all objects that starts with "01", but it isn't working, webtop remove the "0" at left and don't make search with only one character.Why advanced search remove the "0" of string clauses?Thank's

  • RELEVANCY SCORE 2.87

    DB:2.87:Operator Calls Transfer Return Back To Him 37



    Hi all

    I have CUCM 7 and when external incoming calls to operator and he transfer the calls to part C the call will keep ring Phone C then return back to operator.

    The operator use Tansfer SoftKey dial Phone C then Transfer again.

    I tried a parameter Onhook Call Transfer to True so Operator can Transfer softkey and hang on but still call retuen to him.

    I did my search and found that this feature is only in CME (Call-Transfer Recall) and not in CUCM.

    Only incoming PSTN calls return back to Operator but Incoming Mobile calls never return to operator as after ringing for a while the call is disconnected. 

    Did anyone face this problem before, i am trying to stop calls not to return back to operator phone after he transfer it.

    DB:2.87:Operator Calls Transfer Return Back To Him 37


    Hi Ayman,

    Just for troubleshooting purposes can you please attach the requested

    screen shots for user C

    Cheers!

    Rob

  • RELEVANCY SCORE 2.86

    DB:2.86:[Search Guibb] Hide Operator ks


    Hi,Let's say that there is only 1 available operator (equals for instance) that I would like to hide to the user.Is this possible to hide operator in Search GUIBB?I though I had seen this in 7.31 or 7.4 new features but can"t find it...Administrator personalization is of no use because user can add new criteria and operator is shown on these new lines.Thanks in advance.Best regards,Guillaume

    DB:2.86:[Search Guibb] Hide Operator ks

    Hi,I have started fooling around with a post-exit Enhancement of WDDOMODIFYVIEW of the SEARCH_VIEW in the FPM_SEARCH_GUIBB with some results. DATA: lo_render TYPE REF TO cl_fpm_guibb_search_render.
    DATA: lo_input_field TYPE REF TO cl_wd_input_field,
    lo_ddlb TYPE REF TO cl_wd_dropdown_by_key.
    FIELD-SYMBOLS: ls_search TYPE LINE OF cl_fpm_guibb_search_render=t_search.
    lo_render ?= wd_assist-mo_render.
    LOOP AT lo_render-mt_search ASSIGNING ls_search.
    CLEAR: lo_input_field,
    lo_ddlb.
    " Hide operators
    lo_ddlb ?= view-get_element( ls_search-ui_id-op ).
    IF lo_ddlb IS BOUND.
    lo_ddlb-set_visible( cl_wd_uielement=e_visible-none ).
    ENDIF.
    " Activate Suggest Values for criteria values
    lo_input_field ?= ls_search-ui_inp1.
    IF lo_input_field IS BOUND.
    lo_input_field-set_suggest_values( abap_true ).
    ENDIF.
    ENDLOOP.

  • RELEVANCY SCORE 2.86

    DB:2.86:Ir Default Search Operator Change af


    HiAPEX version: 4.0I want to change the IR default search operator as 'LIKE' instead of 'CONTAINS'. but I know both are simply different by upper(). The APEX generates the IR filter query in where clause as below,In default the where clause (I selected a column and give the value in the search field)
    where (upper("COLUMN_NAME") like '%'||upper(:APXWS_EXPR_1)||'%') )

    After Editing the filter and changing the operator as 'Like',
    where ("COLUMN_NAME" like :APXWS_EXPR_1) )

    Is there any way to change the default operator in IR??Please suggest me..ThanksLakshmi

    DB:2.86:Ir Default Search Operator Change af

    HiAPEX version: 4.0I want to change the IR default search operator as 'LIKE' instead of 'CONTAINS'. but I know both are simply different by upper(). The APEX generates the IR filter query in where clause as below,In default the where clause (I selected a column and give the value in the search field)
    where (upper("COLUMN_NAME") like '%'||upper(:APXWS_EXPR_1)||'%') )

    After Editing the filter and changing the operator as 'Like',
    where ("COLUMN_NAME" like :APXWS_EXPR_1) )

    Is there any way to change the default operator in IR??Please suggest me..ThanksLakshmi

  • RELEVANCY SCORE 2.86

    DB:2.86:Advanced Search Search Operator 3k


    Hello, How can we restrict the "Search Operator" for those attributes with value assistance. I have tried doing it in Docapp but failed to see any changes reflected.

    DB:2.86:Advanced Search Search Operator 3k

    Hello, How can we restrict the "Search Operator" for those attributes with value assistance. I have tried doing it in Docapp but failed to see any changes reflected.

  • RELEVANCY SCORE 2.86

    DB:2.86:Is Xplore Support And / Or Operator For N Advanced Fulltext Search dc



    Hi all

    I am using xPlore 1.1 through D2 interface and I would like to know if xPlore support AND / OR operator for an advanced fulltext search ?

    Thanks for your answer

    DB:2.86:Is Xplore Support And / Or Operator For N Advanced Fulltext Search dc


    Hi all

    I am using xPlore 1.1 through D2 interface and I would like to know if xPlore support AND / OR operator for an advanced fulltext search ?

    Thanks for your answer

  • RELEVANCY SCORE 2.85

    DB:2.85:Index Usuage xf


    I created index on xy table of empno column.i want to search using empno column using like or in operator.which operator is useful for this?.which operator will use index?

    pls clarify.

    DB:2.85:Index Usuage xf

    You can check the index usage yourself in different (like, in etc.) scenarios by using the MONITORING USAGE clause of ALTER INDEX command.

    To enable index usage monitoring, enable it by executing

    alter index IndexName monitoring usage;

    Then run the required query for which you want to see whether the index is used or not
    Run this query to see if the index is used
    select USED from V$OBJECT_USAGE where INDEX_NAME = 'IndexName';

    It will either be Yes or No which will identify whether the index is used or not

    This index monitoring can then be stopped by executing the following statement

    alter index IndexName nomonitoring usage;

    Hope it's clear enough

    Regards

  • RELEVANCY SCORE 2.83

    DB:2.83:Scenario Session Log xf


    I am using ODi 10.1.3.6.0 I have unique issue for logging details in operator, When I run the same scenaro it delets previous log detail and all the lower level of deatils about each step, only the highest level of log entry stay in operator log. I am executing my scenario each time with log level of 5.

    Thanks
    Kaashi

    DB:2.83:Scenario Session Log xf

    I am using ODi 10.1.3.6.0 I have unique issue for logging details in operator, When I run the same scenaro it delets previous log detail and all the lower level of deatils about each step, only the highest level of log entry stay in operator log. I am executing my scenario each time with log level of 5.

    Thanks
    Kaashi

  • RELEVANCY SCORE 2.82

    DB:2.82:Advanced Search Operator a3


    Hi All,Is there a way to change the search operator "" , "=" to "Not equal" , "equal" on the advanced search screen ? so it will be easy to undersatnd for the user.ThanksHems

    DB:2.82:Advanced Search Operator a3

    It's not in the WDK, Webtop or DFC code line, so that's why I suggested the data dictionary.

  • RELEVANCY SCORE 2.82

    DB:2.82:Updating Teststand Search Directory From Operator Interface Automatically ax


    I Have A Labview Operator Interface (OI), which is usedto run one or more test sequence.I would like this LabView OI to automatically checkand update the search directory of the TestStand.Anybody know how to do this ?

    DB:2.82:Updating Teststand Search Directory From Operator Interface Automatically ax

    Hi,In TestStand 2.0.x all you can do is display the Search Directories Dialog and the user would have to manual check. This is something that is already available in the default OI.In TestStand 3.0 there are new classes which allow you to perform some of the tasks you are wanting to do. These are SearchDirectories and SearchDirectory.I have attached an example test sequence which obtains a list of search directories and records them.Hope this helpsRegardsRay Farmer



    RegardsRay Farmer

  • RELEVANCY SCORE 2.82

    DB:2.82:External Operator With Search Menu 8j



    Hi guys,

    I want to be able to set a dynamic qualification for the search menu at run-time, therefore I am using EXTERNAL operator. The problem is that as opposed to table fields the operator in menu seems to support only a field on the destination form as an operator parameter and not a field on the current form (the form where the menu is located).

    Example:

    EXTERNAL('Field On Destination Form') - works

    EXTERNAL($Field On Current Form$) - doesn't work

    What am I doing wrong?

    DB:2.82:External Operator With Search Menu 8j


    Nice one Misi, I thought I was trying to do something silly but obviously something is just not working properly. Your solution worked great Hurray for External operation search menus ^_^

  • RELEVANCY SCORE 2.82

    DB:2.82:Indexes Question p3


    Assume we have a  sales table, which contains a OrderID(char(8)) and a OrderDate(smalldatetime) field. Each day, hundreds of thousands of  records needs to be inserted into this table. We need a daily sales report, and the OrderID is not necessarilly sequentially entered (every data operator has a range of OrderID, so for each data operator, it is sequential, but globally, it is not). So, I would like to create a clustered index on OrderDate, and the Primary Key is on OrderID. I think it is good for generating the daily sales report. However, when an order is entered, we need to quickly check if the OrderID already exits, because the unique index on OrderID is built on the clustered index (on OrderDate), which means the Database Engine will search all the records on that day. This could be a slow process.Is it possible to create indexes so that I can generate daily report and search for the OrderID quickly at the same time?Thanks.

    DB:2.82:Indexes Question p3

    Create the clustered index on the orderDate and a second, unique non clustered index on orderId. When you check that the order id already exists, if you do a if exists (select orderId from sales where orderId = @orderId), then this will not need to do a clustered index lookup as the index is covered i.e. : there is no need to go back to the base table, as the only column you are asking for (orderId) is already in the non clustered index.
    The daily sales report would continue to work with the clustered index on the orderDate.
    Hope this helps.

  • RELEVANCY SCORE 2.82

    DB:2.82:Why Unique Index Cannot Be Created On A View Which Contains Union All Operator 7m


    Hello all,
    I would like to know why we cannot create unique (clustered/non clustered )index on view which uses Union All operator in its definition.
    Thanks Regards
    Samba

  • RELEVANCY SCORE 2.82

    DB:2.82:Operator Selection On View Crmcmp_Emwb/Emailwbsq jj



    Hi Experts,

    In email workbench view CRMCMP_EMWB/EMailWBSQ,I added one custom field. Based on the other field operator,the operators of newly added field should be populated.

    Example:

    In the email workbench search view I'm having two fields say field1 and field2(custom field).

    If I select field1 operator as "Is " than the operators of field2 should contain only two values "IS" and "IS BETWEEN".

    If I select field1 operator as "Is earlier than",than the operator of field2 should contain only one value "IS".

    Your inputs are highly appreciated and rewarded.

    Thanks Regards,

    S.Gangireddy

    DB:2.82:Operator Selection On View Crmcmp_Emwb/Emailwbsq jj


    Hi Gangireddy,

    You can achieve this in 2 ways:

    1. If you want to load the operators for field2 based on the operator selection of field1, you have to make a round trip before

    selecting the operator for the field2. As currently CRM Web UI doesn't make a roundtrip when you select an operator.

    A roundtrip will happen if for the field1, the input is provided using a valuehelp. In such case, a round trip will happen.

    And you can manipulate the operators by redefining the following methods in the context node class of the search node.

    ADJUST_CRITERIA_CONTEXT2UI

    GET_SUPPORTED_OPERATORS

    2. Otherwise you can do the validation of the operators when you do the search.

    This can be done by redefining the following methods

    In view controller class,

    DO_HANDLE_DATA

    DO_VALIDATE_INPUT

    In context node class of search node,

    ADJUST_CRITERIA_UI2CONTEXT

    Regards

    Leon

  • RELEVANCY SCORE 2.82

    DB:2.82:Advanced Search Custom Properties Equals Does Not Return Results But Contains Returns Results ks


    I have customized the Advanced Search web part to add custom metadata property by editing the XML. The search works fine if we use operator Contains and returns results. But the same query does not return results if I use operator Equals
    Any suggestions?
    Thanks.

    DB:2.82:Advanced Search Custom Properties Equals Does Not Return Results But Contains Returns Results ks

    Hi Sucheta,

    Did you get solution for above problem, as i am also facing the same issue.
    For me also, contains operator is working for a custom property but equals not working.
    Appreciate any suggestions.
    Thanks.

  • RELEVANCY SCORE 2.82

    DB:2.82:Like Operator 3s


    Hi All,

    can you please tell me better option to search other that like operator in SQL ?

    because using like operator is very time consuming and resource intensive given that we have millions of records in table. so i would like to know better and fast result fetching operation better than like operator ?

    DB:2.82:Like Operator 3s

    Hi,

    It depends on what exactly you want to do.

    Oracle sells a product called TEXT that is good for doing full text searches. Look at the Text Application Developer's Guide
    http://download.oracle.com/docs/cd/B28359_01/text.111/b28303/toc.htm
    especially the introductory parts, to see if it might do what you want.

    In standard Oracle:
    INSTR might be a bit faster than LIKE if you're searching for an invariable substring.
    REGEXP_LIKE (and other techniques involviong egular expredssions) are usually slower than LIKE, but if you're doing complicated searches, that involve several LIKE operations, then you mkight be able to use one regular expression instead, and that might be faster.

  • RELEVANCY SCORE 2.82

    DB:2.82:Search Not Appearing With Other Operator px


    Hi,When I am executing a search based on a repeating attribute in webtop advanced search.It works fine with IN operator but gives 0 results with like ,= operator any idea on this.The DQL works fine with like , = operator in DQL editor.

    DB:2.82:Search Not Appearing With Other Operator px

    Hi Raktim Ghosh,Did you solve this issue ?Im facing the same problem, and he drives me crazy

  • RELEVANCY SCORE 2.81

    DB:2.81:Getting Operator Methods For Basic Types? cc


     
    Is it possible to use reflection to search for operator methods on basic types?
     
    For instance, I can search for the + operator on a decimal type...
     
    method = typeof(decimal).GetMethod(op_Addition);
     
    and it returns an appropriate method.  However, this doesn't seem to work for int or double types.  Is there a another way?
     
    Thanks.
     
    Mike
     

    DB:2.81:Getting Operator Methods For Basic Types? cc

    That's what I was figured.  Bummer.  Thanks.
     
    Mike
     

  • RELEVANCY SCORE 2.81

    DB:2.81:Error 3075 While Concatenating On A Subform fp


    Hello,

    I am using http://allenbrowne.com/func-concat.html as a reference point for concatenatingdepartments againsta unique ID.

    The unique ID is part of a table. Thedepartment namesare from a linked table.

    I have the following as a control source on a subform:

    =ConcatRelated("Department","qrySearchTool","[LL_DepartmentEntry]![@EntryID] = " [EntryID],"Department",", ")

    When I click "search" on the form, I get the following error:

    Error 3075 - Syntax Error (missing operator) in query expression
    '[LL_DepartmentEntry]![@EntryID] = '

    But then, oddly enough, the correct results are returned once I click through the error message.

    There was another very similar post found here:
    http://answers.microsoft.com/en-us/office/forum/office_2007-access/error-3075-on-a-concat/a0a2f00b-868a-44ce-b2f6-ee2c29d61ca2?auth=1

    Only difference is, my table doesn't allow nulls.

    Any help is appreciated with this. I've been battling this for too many hours and have tried many things. I chose to post in this community because the people here seem friendly and I am a self-taught noob. Please be gentle. Thank you!

    DB:2.81:Error 3075 While Concatenating On A Subform fp

    The ConcatRelated function opens a DAO recordset on the table/query specified in the strTable argument. DAO doesn't know about Access forms and controls, so if your query refers to a combo box on a form, you'll get the "Too few parameters" error.
    You'll have to take the reference to the combo box out of the query, and work it into the strWhere argument of ConcatRelated.

  • RELEVANCY SCORE 2.81

    DB:2.81:Unique Id In Exchange fj


    We want to search emails with the given uniqueID like this:
    final FolderId folderId = new FolderId(container.getId().getId());
    We retrieve the uniqueId with the following statement: exchangeItem.getId().getUniqueId()

    Is the unique ID always the same? For the inbox folder I think the unique ID changes…

    DB:2.81:Unique Id In Exchange fj

    If you have the ewsID of a particular item them is no point in searching for theitem because you can just bind directly to that Item. So the first question is why are you searching for it ?. The ewsID do change for example if an item is moved between
    folders etc. Generally the best thing to store if you are trying to store in ID that you can use to later search for an Item is the pidTagSearchKey property
    http://msdn.microsoft.com/en-us/library/office/cc815908.aspx which doesn't change when an item is copied between folders.
    Cheers
    Glen

  • RELEVANCY SCORE 2.80

    DB:2.80:Advance Search Operator 3k


    Hi expert,I'm using webtop 5.2.5 SP3. The operator of advance search is only "AND" operator. How do we customize it to have "AND" and "OR" operator dropdown list?Thanks

    DB:2.80:Advance Search Operator 3k

    Hi here i am using webtop 5.3 i am able to get both the options "AND","OR". i hope the same will also come in 5.2.5 also. please check once again.

  • RELEVANCY SCORE 2.80

    DB:2.80:Sharepoint 2007 Advance Search Property Restrictions And And Or Clause f8


    I have an advance search webpart configured with Property Restrictions. I need to setup a search filter that states something like Author contains 'Bill' Or 'Mary' And Title contains 'MOSS 2007 InstallationWhen I select the OR operator for the first condition, adding another property restriction is automatically picking up the OR operator and the dropdown is no longer available. Its readonly display. I'm stuck with the OR operator now for each property restriction I add.Is this normal sharepoint behavior or I need to configure something

    DB:2.80:Sharepoint 2007 Advance Search Property Restrictions And And Or Clause f8

    It is by the design of the advanced search web part. The advanced search web part would call Search API with SQL syntax. In fact, the API support mixed AND/OR statement.
     
    For Search API SQL syntax, please refer to http://msdn.microsoft.com/en-us/library/ms544086.aspx ;
     
    You may refer to http://msdn.microsoft.com/en-us/library/ms564508.aspx if you want to create your own search web part.

  • RELEVANCY SCORE 2.80

    DB:2.80:Multiple Unique Attributes In Entity zc


    Hi

    I search the forum (as it seems to be a general issue) but I didn't find nothing.

    I'm using JDev11g (11.1.1.1.2)
    So here is my question. How can I make a pair of attributes in the entity to be unique (the pair to be unique) ?

    Thank you
    agruev

    DB:2.80:Multiple Unique Attributes In Entity zc

    Thank you Jang

    That was what I was looking for!

  • RELEVANCY SCORE 2.80

    DB:2.80:Advanced Search Logical Operator xs



    Hello,

    I am customizing webtop(6.6) advanced search page. Is there a way that I can set default logical operator as "=" rather than "contains"? Also, is it possible to hide the operators so the users won't see them?

    Thanks

    DB:2.80:Advanced Search Logical Operator xs


    Hi,

    I want to hide the whole dropdown list on the advsearch page. In other

    words, I want to show users "Name:

  • RELEVANCY SCORE 2.80

    DB:2.80:Someone Have Extended Adv. Search For Include Or Operator f8


    Someone have extended adv. search for include OR operator

    DB:2.80:Someone Have Extended Adv. Search For Include Or Operator f8

    Search is being entirely rewritten for 5.3. It will include the OR operator and be more configurable.

  • RELEVANCY SCORE 2.79

    DB:2.79:Inputlistofvalue With Viewcriteria Using Between Operator Giving Error. p8


    So i am using inputlistofvalues with ViewCriteria.In ViewCriteria i am using between operator for a date(CreDttm) field.
    when i click on search icon,it takes me to search popup and i give range of date and click search it give me result correctly and when i select a row and click ok,it take me to parent page but give error that "Credttm is required"...its Readonly Vo. If i use equal operator on same it works fine.
    Am i doing something wrong?

    Any help will be appreciated!
    Thanks

    DB:2.79:Inputlistofvalue With Viewcriteria Using Between Operator Giving Error. p8

    its better to say which jdev version you are using..
    what is 'Credttm' atttribute is associated with.. is it the inputComboboxlitof values.. is this happening when you set the autsubmit=false for the inputcombolov? whe exactly are you seeing this error..

  • RELEVANCY SCORE 2.79

    DB:2.79:Dfc Eci Search- Operators c1


    Hi all,Available ECI operators are,Field Summary:static int AFTER Date operator static int BEFORE Date operator static int BETWEEN Range of date and numerical values operator static int CONTAINS String operator static int EQUAL Numerical operator static int EQUAL_GREATER Numerical operator static int EQUAL_LOWER Numerical operator static int EQUALS_TO String operator static int GREATER Numerical operator static int LOWER Numerical operator static int NONE Invalid operator In DFC , operators are different. exprSet.addSimpleAttrExpression(
    "xxxx",
    IDfValue.DF_INTEGER,
    IDfSimpleAttrExpression.SEARCH_OP_GREATER_EQUAL,
    false,
    false,
    "14");
    Can any one give amapping of DFC operators with ECI operators? For few case I am getting [error]returned [[ECI_UNSUPPORTED_EXPR] Expression not supported by ECI.[/error]Thanks in advance.Regards,Gopinath Cnull

    DB:2.79:Dfc Eci Search- Operators c1

    Hi all,Available ECI operators are,Field Summary:static int AFTER Date operator static int BEFORE Date operator static int BETWEEN Range of date and numerical values operator static int CONTAINS String operator static int EQUAL Numerical operator static int EQUAL_GREATER Numerical operator static int EQUAL_LOWER Numerical operator static int EQUALS_TO String operator static int GREATER Numerical operator static int LOWER Numerical operator static int NONE Invalid operator In DFC , operators are different. exprSet.addSimpleAttrExpression(
    "xxxx",
    IDfValue.DF_INTEGER,
    IDfSimpleAttrExpression.SEARCH_OP_GREATER_EQUAL,
    false,
    false,
    "14");
    Can any one give amapping of DFC operators with ECI operators? For few case I am getting [error]returned [[ECI_UNSUPPORTED_EXPR] Expression not supported by ECI.[/error]Thanks in advance.Regards,Gopinath Cnull

  • RELEVANCY SCORE 2.79

    DB:2.79:Default Operator Of Free-Form Search In Sap Mdm 7.1 Sp11 fc



    How to change default operator of free-form search in sap mdm 7.1 SP11?

    By default it is 'Starts with'.

    I want to make it 'Contains'.

    DB:2.79:Default Operator Of Free-Form Search In Sap Mdm 7.1 Sp11 fc


    How to change default operator of free-form search in sap mdm 7.1 SP11?

    By default it is 'Starts with'.

    I want to make it 'Contains'.

  • RELEVANCY SCORE 2.79

    DB:2.79:Retrieve Data Using Not In Clause fm


    Hi,

    Ihave two temporal tables(temp,temp2) with two columns on each

    temp(phone,operator)
    temp2(phone,operator)the phone and operator columns are unique key in temp2

    what can i do to retrieve the data which are in temp but not in temp2?

    thanks in advanced

  • RELEVANCY SCORE 2.79

    DB:2.79:Creating A Unique Constraint On A Column Using Code-First. 1p


    I'm trying to specify that a column is unique using the code first fluent API but cannot find an IsUnique operator. Is there something else I should be using for this?Keep your head in the Clouds as you're coding .NET http://azurecoding.net

    DB:2.79:Creating A Unique Constraint On A Column Using Code-First. 1p

    Hi Brownie,
    Thanks for your post.
    It maybe a new feature in next version, you can refer here:
    http://blogs.msdn.com/b/efdesign/archive/2011/03/09/unique-constraints-in-the-entity-framework.aspx
    Have a nice day.Alan Chen[MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 2.79

    DB:2.79:Artlayers Unique Id... (Cs5) f7



    Hi,

    I want export layers names with unique ids to external file.I search a lot in documentation and also on Internet and I didnt find anything about unique ids of layers in photoshop. Each created artlayer should have own unique id, right? So, how to get that uid?

    Greeds.

    DB:2.79:Artlayers Unique Id... (Cs5) f7

    PITerminology.h in the Photoshop SDK has a bit more descriptive
    constants but it is not much help and they are sometimes inconsistent.

  • RELEVANCY SCORE 2.79

    DB:2.79:Custom Operator For Advanced Search In Oim zc


    Hi All,

    We have two operators like Equals and Begin with in Advanced users search. I want to search with new operator, Can we add any other new operators

    Regards
    user7609

    DB:2.79:Custom Operator For Advanced Search In Oim zc

    You will have to look at the canonical framework which 11g uses for such operations. Refer to article id: 1311568.1 which talks about modifying the search user page during request creation to add additional search fields.
    Also you must have done through this doc: http://docs.oracle.com/cd/E21764_01/doc.1111/e14309/uicust.htm
    Not a trivial task but not impossible either.

    -Bikash

  • RELEVANCY SCORE 2.78

    DB:2.78:Validate Unique Attribute In Override? c7


    i need to be able to validate a unique attribute within an override and regenerate it if it is not unique. i notice there is no server-side selector or search class. is there another way i can accomplish this?

    DB:2.78:Validate Unique Attribute In Override? c7

    bump...amy chance of a response from somebody at oracle?

  • RELEVANCY SCORE 2.77

    DB:2.77:Any Command Similar To 'Like' Operator Of Oracle j1



    I want to search for a word in a string and if it contains, do something.

    is there any equivalent operator in Qlikview similar to 'LIKE' operator of Oracle?

    if($(Path) like 'TEST') then

    store $(PATH)/test.qvd;

    end

    DB:2.77:Any Command Similar To 'Like' Operator Of Oracle j1


    Thank you. I just solved it using INDEX() function

    IF index('$(Path)','TEST') 0 THEN

    STORE Cust INTO $(Path)Cust.qvd ;

    END IF

  • RELEVANCY SCORE 2.77

    DB:2.77:Operator Logo Removal, 9300i 3f


    First of all, I did use search...

    Like to hide operator logo "Elisa" a Finnish operator from the small display of 9300i.

    There is a display option, "hide logo" but phone says that "no logo in memory".

    Any ideas for this? I've tried a couple of "empty logo" but no help.

    DB:2.77:Operator Logo Removal, 9300i 3f

    First of all, I did use search...

    Like to hide operator logo "Elisa" a Finnish operator from the small display of 9300i.

    There is a display option, "hide logo" but phone says that "no logo in memory".

    Any ideas for this? I've tried a couple of "empty logo" but no help.

  • RELEVANCY SCORE 2.76

    DB:2.76:Query Regarding Adding New Search Operator 89



    Hi everyone,

    We have added a new search operator 'is not' for attribute CITY in account search.We have redefined the method GET_SUPPORTED_OPERATORS.The search opeartor is coming properly in WEB UI screen. But when we are clicking on search button it is giving wrong result.

    I've checked the scenario by adding the search operator through CRMVC_DQ via SM34.The result was same.

    So could anyone please tell me shall I have to implement any other method apart from GET_SUPPORTED_OPERATORS in case of adding new search operator for a search attribute?

    We need the solution urgently.

    Thanks Regards,

    Anirban Ghosh

    DB:2.76:Query Regarding Adding New Search Operator 89


    Hi,

    Can anybody help me on the above problem?

    Thanks Regards,

    Anirban Ghosh

  • RELEVANCY SCORE 2.76

    DB:2.76:Advanced Search: Missing Value In Inclusion Operator aa


    Hi,
     
    Sharepoint 3.0 Search Server Express on SBS 2003 SP2.
     
    Advanced Search inclusion operator contains only: Equals and Does not  equal for text based property. Isn't suppose to have also :Contains, Does not contain?
    Is there any workaround?
    Faruk
     

  • RELEVANCY SCORE 2.76

    DB:2.76:Operator '≪' Undefined For Type K k1


    Hey,
    Trying to implement a binary search tree.
    I can't get the search feature working...
    I keep getting this error:

    The operator is undefined for the argument type(s) K, KBinarySearchTree/src/myPackageBSTree.javaline 35similarly for ''http://www.darkdayssoftware.com/BSTree.java
    http://www.darkdayssoftware.com/TreeNode.java
    Any Help much appreciated.

    DB:2.76:Operator '≪' Undefined For Type K k1

    Perfect! I remember now we have have to use .compareTo()
    Thanks so muchYou're welcome.

  • RELEVANCY SCORE 2.75

    DB:2.75:Atg Search Treequeryrequest Within Operator jp


    Hi I am using ATG Search in CSC and I am using treeQueryRequest to search.I want to filter the order search based on the order types and i found the WITHIN operator in ATG search query guide.But I am unable to find the syntax and the delimiter. please share the syntax for within operator thanks in advance.

    DB:2.75:Atg Search Treequeryrequest Within Operator jp

    Hi Gautam,Thanks for your reply.I am using tree query request do you know how to use the operations (or,and,not) in tree query request

  • RELEVANCY SCORE 2.75

    DB:2.75:Federated Search - Bing Lookup Operator mj


    Hi,
    Trying to perform federated search with Bing lookup operator through Fast Search designer. Every time i get following error:
    Error code - 407 ISA Proxy authentication required
    Please help.

    DB:2.75:Federated Search - Bing Lookup Operator mj

    How to setup the proxy information for bing operator

  • RELEVANCY SCORE 2.75

    DB:2.75:In Operator In View Criteria jk


    Hi all,I have a small classical question.Is it possible to use the "IN" operator in a view criteria?After search i found that this operator is not natively supported in ADF so what is the best method to implement it?Thank you,Elias.

  • RELEVANCY SCORE 2.75

    DB:2.75:'Is All Of' Operator For Repeating Value Attributes? zm


    Intranet Client provided a 'Is All Of' operator that, when used against a repeating value attribute, would return only those objects that contained ALL of the values entered (separated by commas) into the search field. Is such functionality available in Webtop 'Advanced Search' (without adding an additional property search row for each value to be searched for)??

    DB:2.75:'Is All Of' Operator For Repeating Value Attributes? zm

    We noticed the same problem. We could see that Webtop only has half of the query clauses that Desktop client' Find Component has. I guess this will have to be a feature request with Documentum. Or else we can edit the Advanced Search Component in webtop.Message was edited by: max_jaison

  • RELEVANCY SCORE 2.75

    DB:2.75:Search Operator 7z


    Hi,I want to search documents on some reach criteria.There are two attributes which are exactly similar and both are of type string.When I select 'attr1' with operator as 'contains' I get null result but if I do the same search with operator as 'in' I get the required documents.But the exactly opposite thing appears with the 'attr2'.Can anyone tell me what is the difference between 'contains' and 'in' operator.Thanks

    DB:2.75:Search Operator 7z

    Hi,Following is the trace :1:# [ 1764 ] Fri Apr 24 06:00:00 2009 692000 ( 0.000 sec) ( 18614 rpc) Res: 'OK'2:# [ 1764 ] Fri Apr 24 06:00:03 2009 552000 ( 0.000 sec) ( 18614 rpc) API get,s11,1100a89880004d0c,user_privileges3:# [ 1764 ] Fri Apr 24 06:00:03 2009 552000 ( 0.000 sec) ( 18614 rpc) Res: '16'4:# [ 1764 ] Fri Apr 24 06:00:03 2009 552000 ( 0.000 sec) ( 18614 rpc) API get,s11,0800a89880000215,_changed5:# [ 1764 ] Fri Apr 24 06:00:03 2009 552000 ( 0.000 sec) ( 18614 rpc) Res: 'F'6:# [ 1764 ] Fri Apr 24 06:00:03 2009 552000 ( 0.000 sec) ( 18614 rpc) API fetch,s11,0800a89880000215,,F7:# [ 1764 ] Fri Apr 24 06:00:03 2009 567000 ( 0.015 sec) ( 18615 rpc) Res: 'OK'8:# [ 1764 ] Fri Apr 24 06:00:03 2009 567000 ( 0.000 sec) ( 18615 rpc) API get,s11,0800a89880000215,i_vstamp9:# [ 1764 ] Fri Apr 24 06:00:03 2009 567000 ( 0.000 sec) ( 18615 rpc) Res: '2432'10:# [ 4924 ] Fri Apr 24 06:00:03 2009 630000 ( 0.000 sec) ( 18615 rpc) API get,apisession,apiconfig,batch_hint_size11:# [ 4924 ] Fri Apr 24 06:00:03 2009 630000 ( 0.000 sec) ( 18615 rpc) Res: '20'12:# [ 4924 ] Fri Apr 24 06:00:03 2009 630000 ( 0.000 sec) ( 18615 rpc) API execquery,s11,1,SELECT r_object_id,text,object_name,r_object_type,r_lock_owner,owner_name,r_link_cnt,r_is_virtual_doc,r_content_size,a_content_type,i_is_reference,r_assembled_from_id,r_has_frzn_assembly,a_compound_architecture,i_is_replica,r_policy_id,score,r_modify_date,summary FROM hug_well_log_doc SEARCH DOCUMENT CONTAINS 'HUG_ABOLT 2_NUCLEAR LOG_30JUN1978' WHERE ((range LIKE '%36%' ESCAPE '\') AND (well_name LIKE '%%' ESCAPE '\')) AND (a_is_hidden = FALSE) ENABLE(TRY_FTDQL_FIRST)13:# [ 4924 ] Fri Apr 24 06:00:05 2009 348000 ( 1.718 sec) ( 18616 rpc) Res: 'OK'14:# [ 4924 ] Fri Apr 24 06:00:05 2009 348000 ( 0.000 sec) ( 18616 rpc) API getlastcoll,s1115:# [ 4924 ] Fri Apr 24 06:00:05 2009 348000 ( 0.000 sec) ( 18616 rpc) Res: 'q1'16:# [ 4924 ] Fri Apr 24 06:00:05 2009 348000 ( 0.000 sec) ( 18616 rpc) API next,s11,q117:# [ 4924 ] Fri Apr 24 06:00:10 2009 348000 ( 5.000 sec) ( 18617 rpc) Res: ' '18:# [ 4924 ] Fri Apr 24 06:00:10 2009 348000 ( 0.000 sec) ( 18617 rpc) API getmessage,s11,319:# [ 4924 ] Fri Apr 24 06:00:10 2009 348000 ( 0.000 sec) ( 18619 rpc) Res: '[DM_FULLTEXT_E_SEARCH_FT_ENGINE_QUERY_PARSE_ERROR]error: "QRServer Error (1201): parsefql: Query Error: line 1:350: unexpected token: range,Error from QRServer"20:21:[DM_FULLTEXT_E_SEARCH_NEW_FAIL]error: "dmFTSearchNew failed with error: QRServer Error (1201): parsefql: Query Error: line 1:350: unexpected token: range,Error from QRServer, error code: -2"22:23:'24:# [ 4924 ] Fri Apr 24 06:00:10 2009 348000 ( 0.000 sec) ( 18619 rpc) API reset,s11,q125:# [ 4924 ] Fri Apr 24 06:00:10 2009 348000 ( 0.000 sec) ( 18619 rpc) Res: ' '26:# [ 4924 ] Fri Apr 24 06:00:10 2009 348000 ( 0.000 sec) ( 18619 rpc) API getmessage,s11,327:# [ 4924 ] Fri Apr 24 06:00:10 2009 348000 ( 0.000 sec) ( 18619 rpc) Res: '[DM_API_E_EXIST]error: "Document/object specified by q1 does not exist."28:29:'30:# [ 1764 ] Fri Apr 24 06:00:10 2009 348000 ( 0.000 sec) ( 18619 rpc) API get,s11,1100a89880004d0c,user_privileges31:# [ 1764 ] Fri Apr 24 06:00:10 2009 348000 ( 0.000 sec) ( 18619 rpc) Res: '16'32:# [ 4924 ] Fri Apr 24 06:00:10 2009 348000 ( 0.000 sec) ( 18619 rpc) API close,s11,q133:# [ 4924 ] Fri Apr 24 06:00:10 2009 348000 ( 0.000 sec) ( 18619 rpc) Res: 'OK'34:# [ 1764 ] Fri Apr 24 06:00:14 2009 239000 ( 0.000 sec) ( 18619 rpc) API trace,s11,0,BrowserTrace.txt35:# [ 1764 ] Fri Apr 24 06:00:14 2009 239000 ( 0.000 sec) ( 18620 rpc) Total Time: 13.547 sec36:# [ 1764 ] Fri Apr 24 06:00:14 2009 239000 ( 0.000 sec) ( 18620 rpc) Total Server Requests: 18620

  • RELEVANCY SCORE 2.75

    DB:2.75:Nokia 6682 "No Operator Found" 38


    I have a Nokia 6682 that was purchased in Canada. It has been unlocked. I am in Australia now and have bought a virgin sim card for it. I am unable to get any service though. I only get "no operator found !" when I search for a network. Does anyone know why?

    Thanks

    DB:2.75:Nokia 6682 "No Operator Found" 38

    The main Australian operators, Optra, Telstra and Vodafone all use 900/1800 - so this phone will only work on the 1800 band in Australia.

    Whether the phone is locked or not is irrelevant, a locked phone will not accept any SIM other than one from the network to which it is locked, so the user wouldn't even get to the stage where the phone searches for a network if it was a locked phone.

  • RELEVANCY SCORE 2.74

    DB:2.74:How To Require The Operator To Enter A Unique Lot Name In A Text Entry Box For Each Batch Run? s9


    I have an application that operates several batch processes simultaneously. The operator is required to enter a unique lot name for each batch that is initiated. I need a way to check to see that the lot name is in fact unique before I allow the operator to launch the batch. There will be a possible 35,000 unique batch names over the 10yr life of this process.

    I can search a text string for the name and, if unique, append the new names to the end of the string. However, I don't think Lookout will handle text strings that long and I need a way to ensure I don't loose the list if Lookout were shut down and restarted for any reason.

    I can log the new names off to Citadel but the limited SQL functionality in Lookout will not let me search the history to see if there is a match.

    I can use a spreadsheet object or a datatable to store the values but again, I have no good way to search the entries from lookout.

    Any suggestions? The simpler the better. Thanks in advance.

    DB:2.74:How To Require The Operator To Enter A Unique Lot Name In A Text Entry Box For Each Batch Run? s9

    Thanks Ryan. I had thought of this approach but had read (or rather, misread) somewhere that the time and interval fields were the only data that could be used in the "WHERE" condition. Guess I should have tesed it anyway. Thanks for your help.

  • RELEVANCY SCORE 2.73

    DB:2.73:How To Pass Values For In Operator Using Idf List 8f



    I have custom search code where I have introduce "IN operator. But don't know how to pass values for IDF list from text box using addValueattrexpression

    DB:2.73:How To Pass Values For In Operator Using Idf List 8f


    Here is the code

    Punitha Kannan wrote:

    I have custom search code where I have introduce "IN operator. But don't know how to pass values for IDF list from text box using addValueattrexpression

    public static boolean addStringToWhereClauseFromTextCtrl(Component component, IDfExpressionSet expressionSet, String docAttr, int boolType, boolean isRepeating, String txtName) { String txtValue = ((Text) component.getControl(txtName, Text.class)).getValue(); // execute only if filename is not empty if(txtValue != null !txtValue.trim().equals("") boolType == 11) { expressionSet.addValueListAttrExpression(docAttr, IDfValue.DF_STRING, boolType, false, isRepeating); return true; } if (txtValue != null !txtValue.trim().equals("") boolType != 11){ expressionSet.addSimpleAttrExpression(docAttr, IDfValue.DF_STRING, boolType, false, isRepeating, txtValue); return true; } return false; }

  • RELEVANCY SCORE 2.72

    DB:2.72:Advanced Search Operator (Filter) - Urgent !! 8p


    Hi,We are running documentum 5.3 SP 2 . We would like to filter out some search operator for advanced search (eg only = and are allow). For the custom attributes which is control by DocApps, it can be done by modify the DocApps. My question will be how about those attributes which is not control by docapps such as "Name", "Owner" etc ?How we can filter the operator for all this attributes?Appreciate your help and thanks in advance.Regards,May Ling

  • RELEVANCY SCORE 2.72

    DB:2.72:Alter Type To Create A Unique Key 1a


    Hi everyone!I am trying to create a unique constraint using DQL. I want the system to validate if a value is unique and I don't want to use BOF. I beleive my syntax is incorrect! I already tried a lot of combinations and search for examples but nothing.I am using something like this:ALTER TYPE "xpto" ADD UNIQUE KEY (xpto_doc_number) REPORT Doc Number must be unique ON VIOLATION ENFORCE BY APPLICATIONMany thanksPaula

    DB:2.72:Alter Type To Create A Unique Key 1a

    I do realize the original post was made two year ago and we're now using 6.5 SP2, but I think the nature of the problem is the same. I can't get DA/WP to recognize the unique attribute.I've tried the following DQL, this one adds the unique value to the type:alter type com_asset drop unique ("com_asset_id");ALTER TYPE com_asset ADD UNIQUE (com_asset_id) REPORT 'Message of your Choice' ON VIOLATION ENFORCE BY APPLICATION PUBLISH;The query went through fine again, I ran data dictionary publishing job, restarted tomcat, and I'm still able to enter in duplicate values in WP.So I tried the following statement, this one adds the unique value to the attribute:ALTER TYPE com_asset MODIFY "com_asset_id" (DROP UNIQUE);ALTER TYPE com_asset MODIFY "com_asset_id" (ADD UNIQUE ("com_asset_id") REPORT 'Message of your Choice' ON VIOLATION ENFORCE BY APPLICATION) PUBLISH;The query went through fine again, I ran data dictionary publishing job, restarted tomcat, and I'm still able to enter in duplicate values in WP.Anyone have any idea on how this is suppose to be done? We implemented a unique index through MAKE_INDEX admin method, but throwing ORA-0001 every time there is a duplicate value is not a good/acceptable validation technique.Message was edited by: Jzi

  • RELEVANCY SCORE 2.72

    DB:2.72:Query Regarding Adding New Search Operator 3z



    Hi everyone,

    We have added a new search operator 'is not' for attribute CITY in account search.We have redefined the method GET_SUPPORTED_OPERATORS.The search opeartor is coming properly in WEB UI screen. But when we are clicking on search button it is giving wrong result.

    I've checked the scenario by adding the search operator through CRMVC_DQ via SM34.The result was same.

    So could anyone please tell me shall I have to implement any other method apart from GET_SUPPORTED_OPERATORS in case of adding new search operator for a search attribute?

    We need the solution urgently.

    Thanks Regards,

    Anirban Ghosh

    DB:2.72:Query Regarding Adding New Search Operator 3z


    Hi everyone,

    We have added a new search operator 'is not' for attribute CITY in account search.We have redefined the method GET_SUPPORTED_OPERATORS.The search opeartor is coming properly in WEB UI screen. But when we are clicking on search button it is giving wrong result.

    I've checked the scenario by adding the search operator through CRMVC_DQ via SM34.The result was same.

    So could anyone please tell me shall I have to implement any other method apart from GET_SUPPORTED_OPERATORS in case of adding new search operator for a search attribute?

    We need the solution urgently.

    Thanks Regards,

    Anirban Ghosh

  • RELEVANCY SCORE 2.72

    DB:2.72:Ir Filter Customization xm


    I want to change the IR default search operator as 'LIKE' instead of 'CONTAINS'. The APEX generates the IR filter query in where clause as below,In default the where clause (I selected a column and give the value in the search field) where (upper("COLUMN_NAME") like '%'||upper(:APXWS_EXPR_1)||'%') ) After Editing the filter and changing the operator as 'Like', where ("COLUMN_NAME" like :APXWS_EXPR_1) ) Is there any way to change the default operator in IR??

    DB:2.72:Ir Filter Customization xm

    I want to change the IR default search operator as 'LIKE' instead of 'CONTAINS'. The APEX generates the IR filter query in where clause as below,In default the where clause (I selected a column and give the value in the search field) where (upper("COLUMN_NAME") like '%'||upper(:APXWS_EXPR_1)||'%') ) After Editing the filter and changing the operator as 'Like', where ("COLUMN_NAME" like :APXWS_EXPR_1) ) Is there any way to change the default operator in IR??

  • RELEVANCY SCORE 2.72

    DB:2.72:Forms Search Giving 3075 Error Missing Operator 91



    Hello, I have a search form and am having trouble with the line of code below. I want to not show results if I enter something in the combo box. What am I missing in the VBA?

    If Me.cboEmployee "" Then
    varWhere = varWhere "([EmployeeID] = Not Like """ Me.cboEmployee "*"") AND "
    End If

    DB:2.72:Forms Search Giving 3075 Error Missing Operator 91

    Not missing; too much.
    varWhere = varWhere "([EmployeeID]Not Like """ Me.cboEmployee "*"") AND "

  • RELEVANCY SCORE 2.71

    DB:2.71:Using Distinct And Sequences dz


    I have a problem that I'm sure has a simple solution.
    I'm trying to insert unique records into one table from another table that has duplicates. However, I cant use the sequence for my primary key with the distinct operator. eg.:

    INSERT INTO unique_table (pkey,fkey,name)
    SELECT DISTINCT seq.nextval, col1, col2
    FROM dup_table;

    it is the combination of fields col1 and col2 that must be unique. Please help.

    DB:2.71:Using Distinct And Sequences dz

    correct, the distinct clause returns unique rows. you could
    create a trigger for your table then just insert your dup_tab
    into the uniq_tab

    insert into uniq_tab (select distinct col1,col2 from dup_tab);

    with the trigger, your dup_tab will be populated with uniq
    rows on col1,col2

    Hope this helps

    Jay

  • RELEVANCY SCORE 2.71

    DB:2.71:Search Not Working zk


    Hi,I have a custom object type of engineering_document with supertype dm_document.It has a repeating attribute imattributesNow, when I try to advance search using property imattributes with the operator IN it works but when I try with operator contains it does not work shows no result.Any idea on this.Raktim

    DB:2.71:Search Not Working zk

    Hi,I have a custom object type of engineering_document with supertype dm_document.It has a repeating attribute imattributesNow, when I try to advance search using property imattributes with the operator IN it works but when I try with operator contains it does not work shows no result.Any idea on this.Raktim

  • RELEVANCY SCORE 2.70

    DB:2.70:Lookup Table Usage xs



    Hi,

    I have noticed that when trying to use a lookup table more than once, I get the following errors;

    - The operator "name" has more than one lookup rule that has a non-unique key. Only one lookup rule per operator is allowed to have a non-unique key.

    - The operator "name" has more than one iterative rule. Only one iterative rule per operator.

    Can someone expand a little on why this is the case?

    My issue is that I have a lookup table that is basically just a reference list, so I am likely to use a number of variations of data retrievel from it, i.e Lookup column A,B return C. Lookup B,F return A. So the number of Keys changes depending on what I am looking up at the time?

    Thanks

    James

    DB:2.70:Lookup Table Usage xs


    I think using the same lookup table multiple times within a single transform with different keys is something that would be very hard to support.

    If the first query against the table returns say 3 rows and the second query against the table returns 4 rows, how many rows does the operator emit? How should the operator combine the records returned from the first query with the records returned from the second query.

  • RELEVANCY SCORE 2.70

    DB:2.70:"Not" Operator In Itunes Search? sk


    Just wondering if anyone knows if there is a "not" operator to exclude a word from your itunes search, say to keep if from picking upi tracks you don't want. This operator would function in a way that would be similar to the "-" operator on google, so you could search for:
    apple -computer
    to get all apple results that did not include the word computer. On iTunes I'd love to do things like search for:
    U2 -Zooropa
    and get all of U2 except Zooropa, but I don't think you can.

    I realize I could make playlists to pinpoint specific sets of songs, but I don't need to save them for posterity, my preferences change so often, I just want a more refined search.

    DB:2.70:"Not" Operator In Itunes Search? sk

    You can see all your U2 songs without Zooropa. Create a smart playlist that has the following rules:

    Artist is U2
    Song (or album) is not Zooropa

  • RELEVANCY SCORE 2.70

    DB:2.70:Intitle Operator In Bing Search Api ks


    Hi,

    I'm having some troubles with the intitle operator. We use this operator in our searches and it was working successfully till today. For instance , the query: intitle:whatever whatever is not returning the same results than yesterday.
    How can be possible ?
    Thanks in advance.
    Best regards,
    Sergio.

    DB:2.70:Intitle Operator In Bing Search Api ks


    Hi again,

    I've seen you've edited your answer adding the link. This is just for saying that the operator intitle:query came back to work fine yesterday but today it's not returning results again. Is there some way to deal with this?.

    Thank you,

    Regards,

    Sergio.

  • RELEVANCY SCORE 2.70

    DB:2.70:Operator Contains Doesn't Work With Custom Property ? zk


    Hi,
    We are using Portal 5.0.3.
    We've been trying to search the Knowledge Directory using the IPortalSearchRequest class.
    We need to use a IFilterClause with the operator "contains" with a custom property, but it doesn't work.
    When we try with the operator "Equals", it works, but not with "Contains".
    Is it supposed to work ? If it is, how can we do it ?

    Thank you
    Filipe Lopes

  • RELEVANCY SCORE 2.70

    DB:2.70:Q: Sql And In-Operator... dc


    Hi there,

    I believe this has been discussed already to a certain extend but I tried forum search and it seems i am unable to enter a reasonable search query (btw. is it possible to automatically use AND as the default operator for search terms?)...

    however...

    My Question:

    Is there any reason not to allow an empty set for the in-operator?

    Motivation:
    I am a developer and when ever I use the in operator, I have to anticipate empty sets, so for each query using the in operator, two different queries needs to be implemented. Or even more, if several in operators are used. This is error-prone annoying and - at least for me - without any reason...

    Comments welcome ;-)

    Regards,
    Peter

    DB:2.70:Q: Sql And In-Operator... dc

    Thanks, that might work for me. Hopefully, this works on not-nullable columns as well, but I do not see why not...

    Regards,
    Peter

  • RELEVANCY SCORE 2.70

    DB:2.70:Escape Operator pd


    Hello Friends,

    I want to search 'E' (whole thing including ' ) in database procedure/function text.
    I am writing query against user_text table to search 'E'
    by using escape character we can search for _,% but how can search for single quot ( ' ) in procedure text?

    Please how can I get this ?
    Reply Soon

    Avinash

  • RELEVANCY SCORE 2.69

    DB:2.69:Find Operator sz



    Hello!

    I have a new N79 phone and I am trying to find an operator in Tokyo, but nothing comes up. I really need to get service and I am sure it is possible, but when search for a network, it says "no operator found".

    My roaming is active and phone seems to be working otherwise.

    Hope someone can help me!

    thanks,

    H-L

    DB:2.69:Find Operator sz

    Your phone will use t-mob 2G/GSM for all voice calls without problems like you said, and having a T-MOB account for your calls in the US is fine. Using 2G/GSM for data is like using dial-up internet and 3G is like high speed. Text messages are data but very small so that doesn't matter but if you are planning to go online from your phone or download music or use nokia maps 3G is much better. I understand your model is N79-3, so for GSM it has all worldwide frequencies, and for 3G it has the American ATT frequencies: 850 and 1900. T-moB USA uses a different freq (750 and 1900 but with a different system I think), and Europe uses 900 and 2100. In short if you only talk/txt you are all set, if you plan to do more with your phone in the US consider ATT, sorry to be such a nerd!!Message Edited by laurensfaber on 22-Mar-2009 02:43 PM

  • RELEVANCY SCORE 2.69

    DB:2.69:How To Overload Left Shift () Operator In C# k3


    It's quite easy to overload left shift operator in c++. I search all around web but could not find any suitable solution.I would like to overload operator in c#. Something like this.        public static void operator (String Value)        {          Console.WriteLine(Value);        }So, when calling from object of any classMyObject Hello World; should print Hello World in console.Is that possible?

    DB:2.69:How To Overload Left Shift () Operator In C# k3

    Hi, bhav
    As Mark described, you do can overload operator in that way.
    But there are some things you should pay attention to:
    1. operator is a two-operands, So you have to give two params
    2. overload operator, you must return a value (void is denied)
    3. it must start with public static as its modifier
    Thank you

  • RELEVANCY SCORE 2.69

    DB:2.69:Word 2007 Search And Replace Logical Operator Or 8c


    Hello all,

    I'm trying to figure out how to run a search for either "TextA" or "TextB". Does Word have support for these types of boolean/logical operators?

    Thanks,
    Rob

    DB:2.69:Word 2007 Search And Replace Logical Operator Or 8c

    If you gave us more information about the identifiers, such as what they have in common and some representaive samples, it might be possible to provide some advice on an appropriate search string.

  • RELEVANCY SCORE 2.69

    DB:2.69:Full Text Search On Run Time Created Parttioned Tables p3


    Hello all,
    The business logic demands to implement table partitioning.The application creates more new partitioned tables at run time based on the configuration and its a continous process on time axis.
    The datetime column is the partitioning column and its part of composite primary key(GUID column and datetime column)to satisfy the partitioning rules.
    Now I have to implement FTS on allthese partitioned run time tables.
    I tried to createfull textindex on thecomposite view refering to all run time tables with union all operator but i failed to create full text index due to the use of Union All operator.
    So I have created one dedicated view for each run time table and created the clustereduniqueindex on GUID column. I used this unique index to create full text index on this view.
    Is it okay to create unique index on a column which is already part of the primary key?
    Now the FTS query is issued against all the views and results are unioned using Union all operator.
    Though the approach is notquite good ,it partly solves the problem.However,the main issue is when new run time table is created.I assume i need to perform the below sub tasks whenever a new table is created
    1.Create table.
    2.Create indexed view refering the above table.
    3.Create full text index on indexed view.
    4.Update the population schedule for the newly created full text index on view
    5.Modify/Expand existing FTS query to search with the newly created view also.

    Can somebody advise me regarding this issue and let me know drawbacks in this approach and suggestions to improve the quality of solution.
    Thanks
    Samba

    DB:2.69:Full Text Search On Run Time Created Parttioned Tables p3

    Hello Russel,
    Thanks for your response on this query.
    We have partitioned tables created on fly over time axisand we have to implement FTS on all indexed views refering to these run time tables.A given FTSquery searches in all the tables and finally results are unioned.
    This approach requires modification to the original FTS query whenever new partitions are created so that search is expanded to newly created tables as well.
    Is there way to handle this scenario in a better way?
    Thanks
    Samba

  • RELEVANCY SCORE 2.69

    DB:2.69:Search A Unique Word In Sentence In A Range Of Columns And If Found Copy The k3


    Hi,

    DB:2.69:Search A Unique Word In Sentence In A Range Of Columns And If Found Copy The k3

    Hi,
    If I understand correctly, you want to find a cell containing a specific word and copy the whole column? To not use VBA, you could do:

    1) Select cells A1:AK1
    2) Press Ctrl+F
    3) Enter the word to be found in Find what:
    4) Press Enter (to Find Next)
    5) Press Shift+Backspace to select only the Active Cell.
    6) Press Ctrl+Space to select the column of the active cell.
    7) Press Ctrl+C to copy the selected column.

    You can then paste it at the desired location with Ctrl+V.

    Hope that helps.

    Cheers
    Rich

  • RELEVANCY SCORE 2.69

    DB:2.69:Search Records With Like Operator x7


    HiI want to find records with like operator like in vb6 we use like thisRs.Find Name like 'Sam%'it search records start with Sam . How can i do it in VB.Net while Name is not Primary key of my tableIn VB.Net We use like thisdt.Rows.Find(Sam)Then it search exactly if there is name=Sam not name starting with Sam

    DB:2.69:Search Records With Like Operator x7

    Hi AgarwalMethod you describe does not work because select method does not exist for rowsMay be i am doowing wrongSee my codePublic Class SchArrival
    Dim vDataTable As New DataTable(Arrivals)

  • RELEVANCY SCORE 2.69

    DB:2.69:Unique Constraint pz


    What does this mean that because of the search mechanism for unique constraints on more than one column, you cannot have identical values in the non-null columns of a partially null composite UNIQUE key constraint.

    DB:2.69:Unique Constraint pz

    thanx kamal u solved my problem again....

  • RELEVANCY SCORE 2.68

    DB:2.68:Sharepoint 2010 Advanced Search Query 3p


    I'm writing a query in the advanced search webpart, I'm trying to use the not equal operator in the /KeywordQuery tag but I receive the following :Cannot save all of the property settings for this Web Part. One or more errors

    have occurred. See below for details.
    The equal operator on the other hand is working as expected when replaced in the query with the not equal operator

  • RELEVANCY SCORE 2.68

    DB:2.68:In Operator For Search xc



    We have customized advanced search screen and operator is being populated by using IDFSimpleattrExpression . To include IN operator instead of IDFSimpleAttrExpression ,IDFValueListAttrExpression is being used. We get IN operatot in the drop down list . when we select IN operatot, DQL is not being created and do no results found.

    Could anyone help me on that?

    Thanks

  • RELEVANCY SCORE 2.68

    DB:2.68:Logical Operator On Advanced Search Screen - Please Help 99


    Hi All,Suddenly all logical operators become 'null' on advanced search screen.I am refering logical operator list box values just next to Properties list box on advanced search screen.thanks

    DB:2.68:Logical Operator On Advanced Search Screen - Please Help 99

    Use DA to check the Docbase config object. It will show the data dictionary locales.

  • RELEVANCY SCORE 2.68

    DB:2.68:Issue With Dynamic Search Criteria In Component Prd01qr sp



    Hi Folks,

    I enhanced search criteria by adding 3 custom fields like f1,f2,f3 to component PRD01QR view is PRD01QR/SearchHelp . Here everything is working fine but here requirement is when I select value from f1 DDLB then f2,f3 should be removed from search criteria (even should not be visible in search view)

    that means standard search view is displaying with 5 fields like

    stand1 operator feild-val

    stand2 operator feild-val

    f1 operator feild-val

    f2 operator feild-val

    f3 operator feild-val

    here problem is when I select f1 then search view should display like

    stand1 operator feild-val

    stand2 operator feild-val

    f1 operator feild-val

    for this one I did lot of changes in

    GET_DQUERY_DEFINITIONS with server event like Dummy .Even in GET_POSSIBLE_FIELDS, DO_PREPARE_OUTPUT tried with this code

    qs = me-get_current_qs( ) .

    CALL METHOD get_selection_param_table

    EXPORTING

    ir_qs = qs

    IMPORTING

    et_selparam_tab = lt_selection_params.

    READ TABLE lt_selection_params INTO ls_selection_params with key

    ATTR_NAME = 'attr_name' low = value'.

    IF SY-SUBRC EQ 0.

    lr_col_params = qs-get_selection_params( ).

    lv_selection_parameter = LR_COL_PARAMS-get_first( ).

    IF lv_selection_parameter is bound.

    WHILE LV_SELECTION_PARAMETER IS NOT INITIAL.

    DATA: LV_NAME TYPE REF TO NAME_KOMP.

    lv_selection_parameter-get_properties( IMPORTING es_attributes = ls_selection_params ).

    IF ls_selection_params-attr_name = 'attr_name' OR

    ls_selection_params-attr_name = 'attr_name'.

    lr_col_params-remove( lv_selection_parameter ).

    lv_selection_parameter = LR_COL_PARAMS-get_current( ).

    ELSE.

    LV_SELECTION_PARAMETER = LR_COL_PARAMS-GET_NEXT( ).

    ENDIF.

    ENDWHILE.

    ENDIF.

    ENDIF.

    Please check this and let me help out on the same.

    DB:2.68:Issue With Dynamic Search Criteria In Component Prd01qr sp


    Hi,

    I think you have to enable AJAX using ajaxDeltaHandling="TRUE" in .htm for this search criteria, as well try with code that you have mentioned.

    Regards,

    Devender

  • RELEVANCY SCORE 2.68

    DB:2.68:What Exacly Does Filtering By The "Like" Operator Do? 77


    I'm using Apex 3.1 and in my interactive report I'm using the "Filter" option from the action menu. What exactly does the "like" operator do?

    For example if I have a string "male" does the like operator search for all words

    %male
    male% or
    %male%

    Thanks!

    DB:2.68:What Exacly Does Filtering By The "Like" Operator Do? 77

    If you test it out you will see that the IRR simply wraps whatever you enter into standard SQL syntax. So, selecting 'Job' 'like' and entering 'MAN' returns no rows against the EMP Table. Changing that to 'Job' 'like' 'MAN%' returns 'MANAGER's and 'Job' 'like' '%MAN' returns 'SALESMAN's (excuse the improper grammar). Your users need to put the % where they want the wildcard. We also mention it in the Help available off the Actions Menu - "The expression is case sensitive and you can use % as a wild card (e.g. STATE_NAME like A%).
    ".

    Hope that helps -

    -- Sharon

  • RELEVANCY SCORE 2.68

    DB:2.68:Why Can't I Save Search Template Using "Or" Operator? x1



    Is there a reason why "OR" operator is not allowed while saving a search template with multiple properties?

    DB:2.68:Why Can't I Save Search Template Using "Or" Operator? x1


    No current plans. Your Account Manager is who you would want to speak to about the roadmap.

  • RELEVANCY SCORE 2.68

    DB:2.68:N70 kk


    When i search i found operator. but when i call any number it show no network. pls help

    DB:2.68:N70 kk

    Friend,
    Confirm that you arent using offline profile given in the phone. Select any profile other than it. Or restart your phone and select network manually. It will surely help.

  • RELEVANCY SCORE 2.68

    DB:2.68:Preventing Entry Duplication In String 9f


    Hello, I have a page of checkboxes.
    When each checkbox is clicked I want a unique value entered
    into a string. The string should build up as multiple checkboxes
    are clicked (the string wil then be submitted to coldfusion for a
    database search).
    I set up the below, however the "+=" operator duplicates
    previous string entries. How can I overcome this duplication ?
    ...or perhaps I have gone about the wrong way to perform this
    ?
    Thanks in advance for any help.

    RELEVANT CODE SEGMENT:
    var selections:String = "";
    myCheckboxListener.click = function() {
    if (checkbox1.selected) {
    selections += "tanks";
    }
    if (checkbox2.selected) {
    selections += "aircraft";
    }
    }

    submitbutton.onRelease = function (){
    trace (selections);
    }

    DB:2.68:Preventing Entry Duplication In String 9f

    oops, i just realized your probably calling
    myCheckboxListener every time a checkbox is clicked.

    don't do that. make myCheckboxListener a function that's
    called in the first line of submitbutton.onRelease and nowhere
    else.

  • RELEVANCY SCORE 2.68

    DB:2.68:Get Error That Show In Operator. aa


    dear all,

    i want to get error description that is show in operator. e.g
    ORA-00001: unique constraint (IRIS.FILE_UK) violated when this error occur the file will move to failed folder.

    thanks
    Naseer

    DB:2.68:Get Error That Show In Operator. aa

    Okay i think I know what you are trying to do , you can acheive this in a package -

    Package will look like --

    Interface (file to table) ------ OK --------- Move/rename the file to file_processed_datetime (use OdiFileMove or OdiFileCopy)
    |
    |
    |
    Not OK --------- Move/rename the file to file_Failed_datetime (use OdiFileMove or OdiFileCopy).

    Thanks
    Dk