• RELEVANCY SCORE 4.67

    DB:4.67:How To Enable Refinement On A Table Column In Endeca c8





    I have a results table. It has a column as Emp_id. I want emp_id to refine the data search. That is if you select any record in the Emp_id column it trigger a refinement in the same way as guided navigation refinement does.
    I clicked on column properties in the preferences, and enable refinement over the column. Now its coming as hyperlink, but clicking on it is not triggering refinement. Is there any other way to go about it?

    DB:4.67:How To Enable Refinement On A Table Column In Endeca c8

    Ok. I have been able to resolve my issue.
    Apparently if your results table is EQL based, you need to have a group by clause on the column you want to enable refinement on.

  • RELEVANCY SCORE 3.32

    DB:3.32:Sharepoint 2010 Search - Based On Tags kx





    Hi,
    I have configured search and done a full crawl.
    i would like to sort the documents based on tags, in the refinement panel i get only Result type, Site, Author Modified Date.
    How can i enable tags in the refinement panel?

    VinodKumar Pottal

    DB:3.32:Sharepoint 2010 Search - Based On Tags kx

    Hi,
    I have enough tagged documents, still i am not getting this in refinement panel.. any idea how to make this work?
    Have modified the refinement webpart to show Number of categories to Display to 20 , but still no luck.VinodKumar Pottal

  • RELEVANCY SCORE 3.27

    DB:3.27:How To Enable An Unused Column Of A Table? 8a





    is it possible to bring back a unused column.

    DB:3.27:How To Enable An Unused Column Of A Table? 8a

    No.

    See the SQL Reference manual for a full description of the effects of 'dropping' a column.
    null

  • RELEVANCY SCORE 3.17

    DB:3.17:How To Add All Site Column Of A Content Type As Refiners In Refinment Panel. kz


    Hi all,
    I have a requirement of refining search results on the basis of site columns of a Content type. I did lots of googling and I only could refine upto mine Content Type. But I need to refine it further on the basis of my site column which belongs to custom
    Content Type. This is my code:
    ?xml version=1.0 encoding=utf-8?
    FilterCategories
    Category
    Title=Site Metadata
    Description=Different types of documents
    Type=Microsoft.Office.Server.Search.WebControls.ManagedPropertyFilterGenerator
    MetadataThreshold=1
    NumberOfFiltersToDisplay=10
    MaxNumberOfFilters=100
    SortBy=Frequency
    SortByForMoreFilters=Name
    SortDirection=Descending
    SortDirectionForMoreFilters=Ascending
    ShowMoreLink=True
    MappedProperty=SitePriorityManagedProperty
    MoreLinkText=show more
    LessLinkText=show fewer
    CustomFilters MappingType=ValueMapping DataType=String ValueReference=Absolute ShowAllInMore=False
    CustomFilter CustomValue=SiteMetadataContentType
    OriginalValueSiteMetadataContentType/OriginalValue
    /CustomFilter
    /CustomFilters
    /Category
    /FilterCategories

    So is it possible in SharePoint 2010 to refine on the basis of all site columns of a Content type?
    my requirement is that whenI add a site column in content type , Refiners get updated and this new column dynamycally added in Refinement Panel.
    If I add a Site Column in Refinement Panel it shows its values and i dont want that. I just want name of all site column of content type in Refinement panel so that i can further refinemy search results.
    Thanks in advance.Lalita Mittal

    DB:3.17:How To Add All Site Column Of A Content Type As Refiners In Refinment Panel. kz

    HI Jack,
    Got the issue...we wereusing hyphen - in managed property thats why it was not refining. When we changed it to character string , refinement panel worked like a charm....
    Thanks for all your help.
    RegardsLalita Mittal

  • RELEVANCY SCORE 3.16

    DB:3.16:Customising Refinement Panel In Sp 2013 aa


    I have added a Refinement panel in the search page. i have added a refiner which is a managed property there and it is associated with 8 crawled properties.
    I am trying to show only 3 crawled properties on the panel and remaining 5 to be added in the properties without showing on the panel.we first tried in the html page i.e refinement display template but could not achieve it.
    Any help?

    DB:3.16:Customising Refinement Panel In Sp 2013 aa

    Yes i did follow those steps from the technet to setup the refinement panel. Currently i have put only one Refiner.
    This Refiner has multiple filetypes [ Filetype1, Filetype2, Filetype3, Filetype4, Filetype5, Filetype6.... Filetype10]. All these appear on the Refinement panel when i do search.

    I am trying to display only 3 Filetypes i.e., Filetype1, Filetype2, Filetype3. Filetype3 consisting of Filetype3, Filetype4, Filetype5,.....Filetype10.
    I am making no headway to achieve this...
    Any help is appreciated..

  • RELEVANCY SCORE 3.12

    DB:3.12:Serach Results Refinement Show Wrong Values Of A Managed Property k1


    Hi,
    I'm creating a custom search result page and set the refinement to display a custom managed property.
    In the refinement panel i see values that doesn't exists to that property...
    what's wrong?
    The managed proiperty has to be mapped to a column which is a site column of type lookup. this is the structure:
    there is a list with a column: filtercolumn. there is a site column named cdgroup which is a lookup to the filtercolumn.
    I mapped my managed property to ows_cdgroup and to cdgroup(text). Should i map it to one of them only? which one?

    keren tsur

    DB:3.12:Serach Results Refinement Show Wrong Values Of A Managed Property k1

    I created a custom managed property and mapped it to ows_linkfilename and now it works :)keren tsur

  • RELEVANCY SCORE 2.98

    DB:2.98:How To Change The Language Of Custom Metadata Properties In Sharepoint 2010 Search Refinement Panel Wp? sa


    I have a problem with refinement panel.i need to show the refinement panel data in multi language,so for that i have installed language pack and did some settings. now i can see the refinement panel data in french also but some custom metadata properties
    are not showing in french.
    i need to make every property in refinement panel to be in bilingual.
    please find below screen shot for reference.
    in that screen shot Deliverable_Type is not showing in french.need to make it french language.

    how can i achieve this?
    please suggest me!

    Ramesh

    DB:2.98:How To Change The Language Of Custom Metadata Properties In Sharepoint 2010 Search Refinement Panel Wp? sa

    I have a problem with refinement panel.i need to show the refinement panel data in multi language,so for that i have installed language pack and did some settings. now i can see the refinement panel data in french also but some custom metadata properties
    are not showing in french.
    i need to make every property in refinement panel to be in bilingual.
    please find below screen shot for reference.
    in that screen shot Deliverable_Type is not showing in french.need to make it french language.

    how can i achieve this?
    please suggest me!

    Ramesh

  • RELEVANCY SCORE 2.98

    DB:2.98:Expander Is Collapsed When Sorting Inner Table Colum sm


    Hi All,
    I have a rdl report on which i have a main table with four columns, each columns have sorting enable true, one column have toggle visibility based on count here expander will appear for Count column, after expanding it will ope a subreport with a table data
    and having sorting enable true.
    When i am trying to make a sort on inner table column(mrn and count), expander become collapsed and sub report hide itself. How to stop hiding the subreport when sorting the header??????

    DB:2.98:Expander Is Collapsed When Sorting Inner Table Colum sm

    thanks for reply, so we can not overcome with this problem in ssrs 2005??

  • RELEVANCY SCORE 2.97

    DB:2.97:Enabling Specific Elements In A Column 13



    Hopefully this is a simple one, but I can't seem to enable / disable specific elements within table?

    I want to programmatically enable editing of specific items within a single column. Whenever I try to set the enable flag on or off it makes this change to the entire column.

    Is this a limitation of the table or can someone suggest a way around this.

    thx.

    DB:2.97:Enabling Specific Elements In A Column 13


    Add a boolean attribute "Enabled" under the data source node of the table. If this is a model node, add a bnon-singleton/b value node (card=1:1, selection=1:1) and add the attribute to the value node.

    Bind the "enabled" property of the table cell editor (e.g. InputField" to attribute "Enabled".

    Then you can enable/disable the editor in row at index i by setting the value of attribute "Enabled" in node element at index i.

    Armin

  • RELEVANCY SCORE 2.94

    DB:2.94:Search Refinement And Faceted Navigation c3


    I'm not really sure how to explain this accurately but here I go anyway:
    Say I have a term set that looks something like this in my term store:

    ChiefsDirectors

    IT Director

    InfrastructureServices
    Ops DirectorHR Director

    I then make a list with a field that maps to this term set so items can be tagged with the terms in this term set. I've created a managed property that maps to this field and also set the term set to be used for faceted navigation. I also setup search results
    and refinement web parts and this is where I get confused as to how the refinement web part works. After including the managed property as a refinement option, if I perform a search that results in items that are tagged with Services for example, the refinement
    webpart will show Services (25) or however many items in the results are returned with the associated tags. If you click on services, it shows all the results that are tagged as services, and the refinement gives you the option to switch back to
    showing all results.
    How I am trying to get it to work however, is similar to something like how (for example sake) home depot search works (see image below).

    Doing a search on home depot for a chair (http://www.homedepot.com/s/chair?NCNI-5) will give you the different departments, and clicking each department drills down into the refinement while still showing
    the parent term. So for example, if you go into Decor, you'll be presented with more terms, but decor and All Departments are still shown, instead of just All as in SharePoint. In this case, instead of getting a refinement that looks something
    like this when fully expanded:

    All (78)

    IT Director (20)

    Services (6)

    I get this:

    All (78)

    Services (6)

    No matter how far down the term exists in the term set, the refinement doesn't display a hierarchy similar to the home depot example. My question is this: is it possible (and if so, how?) to get the refinement panel to work in a manner similar to the home
    deport example above?
    Thanks!

    DB:2.94:Search Refinement And Faceted Navigation c3

    Hi,
    According to your post, my understanding is that you wanted to custom Search refinement and faceted navigation.
    You can work with FAST Search for SharePoint and Multivalued Properties, please refer to

    http://searchunleashed.wordpress.com/2011/08/19/working-with-fast-search-for-sharepoint-and-multivalued-properties/
    In addtion, you can custom Content Enrichment Web Service Callout. For more information:
    http://msdn.microsoft.com/en-us/library/jj163968.aspx
    Here is a similar thread for you to take a look at:
    http://social.technet.microsoft.com/Forums/sharepoint/en-US/495270dc-2eaf-4046-9be3-c9a09ae96d92/getting-multivalued-managed-properties-to-refine-as-a-list-of-single-values?forum=sharepointsearch

    More infomation:
    Configure refiners and faceted navigation in SharePoint Server 2013:

    http://technet.microsoft.com/en-us/library/jj679902.aspx#BKMK_MapCPtoRefinableMP
    Best Regards,
    Linda Li

    We
    are trying to better understand customer views on social support experience, so your participation in this
    interview project would be greatly appreciated if you have time.
    Thanks for helping make community forums a great place.

  • RELEVANCY SCORE 2.90

    DB:2.90:Problem With Updating The Refinement Web Part In Sharepoint Search - Missing Edit Page Link aj


    Hi,

    I am trying to remove the Authors part from the refinement web parton a SP2013 site where i am site collection admin.
    After searching for instructions how to do it, it was listed everywhere thati should go to the search results page and click edit page.
    I am on the XXXXX/_layouts/15/osssearchresults.aspx page But the edit page link is missing:

    I couldnt add the image, but it contains only these:
    Shared with...
    Add a page
    Add an app
    Site contents
    Change the look
    Site settings

    Can you please tell me what i am doing wrong? Do i have to enable some additional features for it?

    Thank you!

    DB:2.90:Problem With Updating The Refinement Web Part In Sharepoint Search - Missing Edit Page Link aj

    Hi Dinko,
    You are trying to editwebparts in thelayout pages which i would notrecommend and i think you cannot edit layout pages, i would suggeste to make sure you have admin privelages and a createcustom
    search result page and make it default search page for the site, you can then edit the page and edit the refinement webpart panle and remove the Category.
    For more details check below link
    http://johnrossjr.wordpress.com/2011/03/24/customizing-the-refinement-panel-for-sharepoint-2010-search/Raghavendra Shanbhag | Blog: www.SharePointColumn.com
    Please click Propose As Answer if a post solves your problem or Vote As Helpful if a post has been useful to you.
    Disclaimer: This posting is provided AS IS with no warranties.

  • RELEVANCY SCORE 2.90

    DB:2.90:Extending Out Of Box Refiners In Sharepoint Site ka


    Hi All,
    Please let me know how to extend the refinement panel in search centre site? After extending the refinement panel, I need to get that click event on clicking any refiner value? Waiting for reply. Thanks!Sharath Kumar R

    DB:2.90:Extending Out Of Box Refiners In Sharepoint Site ka

    You can use Refinement Filter Generator, check this blog post
    http://www.chaholl.com/archive/2011/03/29/building-a-custom-refinement-filter-generator-for-sharepoint-2010.aspx
    http://multipleselect.codeplex.com/
    If you are looking only for customizing refinement panel

    http://www.andrewalaniz.com/2011/02/search-refinement-managed-property.htmlRaghavendra Shanbhag | Blog: www.SharePointColumn.com
    Please click Propose As Answer if a post solves your problem or Vote As Helpful if a post has been useful to you.
    Disclaimer: This posting is provided AS IS with no warranties.

  • RELEVANCY SCORE 2.89

    DB:2.89:Nested Metadata Tags And Search Refinement Panel sz


    hi,

    i have created a nested termset to which i have mapped as a metadata column in a list.

    the termset is basically location.. Country:State:City.

    Now in my refinement panel want to have this location broken up into 3 distinct pieces. I want the end user to have the ability to filter their results by Country, State or City. But of the box with a nested metadata column it only would show the cities
    in the refinement panel.

    can i use nested termset in this manner or do i have to break it up into 3 distinct terms.. country, state and city? if i break it up, can i enforce it so when the user selects country and then goes on to set the next state column, it will only show states
    for that country?

    mercihikin, bikin, coding machine

    DB:2.89:Nested Metadata Tags And Search Refinement Panel sz

    I have the same issue as mj. We use the MMS because it can push down term changes to columns in all site collections enterprise wide, but in the enterprise search refinement panel it only shows the lowest level of the terms not the nested term set. If anyone
    has gotten this to work it would be a great help.
    Thanks.
    TJB

  • RELEVANCY SCORE 2.89

    DB:2.89:Sp2010 - Search Refinement dj


    I have a problem in the Refinement panel of All Sites search page.
    I have configured a scope for populating NewsGator results. I'm now able to display NewsGator related results on search page, however the refinement part in the All Sites is not working for NewsGator related results. I'm now customizing the refinement
    panel.
    Can anyone tell me the exact crawled property name for Sites in the refinement panel?Thanks, Raja

    DB:2.89:Sp2010 - Search Refinement dj

    Hi Varun,
    I don't have any MappedProperty in name sitename. If you have that in your environment, can you please let me know the crawled property mapped to sitename?Thanks, Raja

  • RELEVANCY SCORE 2.88

    DB:2.88:Get User Name From Login Id Using Xslt da


    Hi,
    I have my Data Stored in External Database which is SQL Server. In one of my table I have created By Column which store log-in id for that user.
    I have displaying that user id in Refinement Panel while searching in External Content Type.
    The search return me the login id in refinement Panel. Ex
    Item Created By
    vijay12345
    What I want is
    Item Created By
    Vijay Singh
    Is their any way to display User name from AD or SharePoint WRT to login id stored in ECT.
    Regards
    Vijay

    DB:2.88:Get User Name From Login Id Using Xslt da

    check this
    http://blogs.msdn.com/b/joshuag/archive/2008/06/03/getting-the-current-user-name-or-id-in-sharepoint-using-sharepoint-designer-no-code.aspx

  • RELEVANCY SCORE 2.88

    DB:2.88:Hide Refinement Panel Web Part When There Are No Results In Search Core Results Web Part 3z


    How can i Hide Search Refinement Panel when there is no results in Search Core Results web part. These two web parts are customize and deployed in site. But refinement panel behave like if there are n o results it will only showing a messege. i want to
    hide this web part when there are no results.?

    DB:2.88:Hide Refinement Panel Web Part When There Are No Results In Search Core Results Web Part 3z

    Hi,
    Try with JavaScript and JQuery to check the search results count in search core results web part and hide the refinement panel if the count is zero.
    Add a content editor web part on search results page to run the script when the page/document is loaded.

    I hope this helps.
    Best Regards
    Ramesh

  • RELEVANCY SCORE 2.88

    DB:2.88:Refinement Panel With Drilldown 3z


    My term set is set up as a hierarchy. My client wants the search refinement panel to be able to drill down into. Is this possible? I set up a column and gave it a type of managed metadata, but the refinement panel is static as if I was
    using a flat list.

    DB:2.88:Refinement Panel With Drilldown 3z

    Yep that you definately can do using a custom filter and a custom range.
    Have a look at:
    http://todd-carter.com/?tag=/SharePoint2010;Search;Refinersabout half way down the page Todd creates a custom range mapping filter that includes the values and a title.
    So in your case you would specify the CustomValue attribute as daily and the Original Value at 1.
    This way users will see the CustomValue on the refinement panel (daily) but the actual search will return results where the value = 1 which is what you want.
    Cheers
    Blog:www.sharepointanalysthq.com

  • RELEVANCY SCORE 2.86

    DB:2.86:I Want To Add Refinement Webpart In Sharepoint-Hosted Apps? sp


    If added then i need to choose refiners to which i have created managed metadata fields in a list based on taxonomy field type, I know that refinement webpart works only when the managed metadata field gets crawled up in search services application in central
    admin?so it is possible to add refinement webpart?

    Thanks,

    DB:2.86:I Want To Add Refinement Webpart In Sharepoint-Hosted Apps? sp

    I don't think its possible but if you can describe us your scenario a bit more (the business requirement)we might be able to offer you some alternatives.

    ThanksProgram Manager, Office Developer Platform.

  • RELEVANCY SCORE 2.85

    DB:2.85:Refinement Panel Webpart Customization 1f


    Hi,
    I want to customize the OOB serach Refinement Panel webpart.How to add a custom fields in Refinement Panel webpart and tell me the ways of customizing the OOB refinement panel webpart.If possible send the code samples.Thanks in advance.
    Regards,
    Praveen R

    DB:2.85:Refinement Panel Webpart Customization 1f

    Hi Praveen,
    Please take a look at these articles:

    Refinement Panel Overview
    Using the Refinement Web part in SharePoint 2010
    Creating a custom Refinement Filter GeneratorUpdate
    Add Custom Category to Search Refinement Panel
    Dmitry
    Lightning
    Tools Check out our SharePoint tools and web parts

  • RELEVANCY SCORE 2.85

    DB:2.85:Bug Report - Oob Site Column Articlestartdate Is Crawled According To Gmt0 Not User/Server Timezone x9


    This issue can be reproduced easily on any SP2013 farm (on-premise) and I heard Sharepoint online do not have this problem.
    Issue: Site column Article Date with fieldname ArticleStartDate is crawled as GMT 0 regardless what timezone your web application, site setting, user setting andOS are set. Also when you submit a search you need to use GMT 0
    otherwise you will get wrong result. I believe it is bug because other datetime columns like Modifiedhave handled timezone issue very well.

    To reproduce: On a SP2013 farm (on-premise), check your timezone settings (in my environment it is GMT8). Then create a site collection and enable its Publishing Infrastructure feature. Then you will see some site columns are setup including Article
    Date (field name ArticleStartDate). Now create a custom content type and add some columns including Article Date to it. Create some sample items using the custom content type and remember fill in the value for Article Date.
    By default it should allow you pick a Date only. After save the change you should see Article Date is saved like 2014-06-18 00:00:00 if check with powershell.
    After create some sample items start a full crawl. You will see find two crawled property ows_q_DATE_ArticleStartDate and ows_ArticleStartDate appear in Search Service Application - Search Schema. There are some existing managed
    properties mapping to those crawled properties like ArticleStartDateOWSDATE (which is TEXT datatype).
    Here you can create some new managed property or use existing. Apply search using those properties to test. In my lab, I createdNewsArticleDate as managed property andmapping to ows_ArticleStartDate.Then Icreate a blank
    page and add a Search result and refinement panel webpart and start some search. In the refinement panel added in the managed properties setup in previous steps. In the querystring I typed in something like /search.aspx?k=newsarticledate=YYYY/MM/dd

    It is what I see:

    1. As you can see in the refinement panel, because I am at GMT8 and crawled index at GMT 0, the sample data 2014-06-18 00:00:00 will become 2014-06-17 16:00:00.
    2. Hence, in order to search out 2014-06-18 00:00:00 item I have to input 2014-06-17 in search query! (in SP2013 the time part are ignored)
    3. By using the powershell provided by Ivan Josipovic(http://gallery.technet.microsoft.com/office/Get-Crawled-Property-names-9e8fc5e0), I can see the items
    ows_ArticleStartDate is 2014-06-18 00:00:00.
    I hope it is actually not a bug. Please let me know if my setting is wrong. Thank you!

  • RELEVANCY SCORE 2.85

    DB:2.85:Issue In Rendering Datetime Field In Refinement Panel c8


    HI
    I have my custom datetime site column and I have mapped that field to search managed property and enable refinement.In refinement webpart I have selected slidebargraph option for display as like other datetime field but the issue is this field doesnot show
    data like one week ago,or one daya ago but show in 2013 or up() 2012-2013.It is very weird why is happening for custom datetime field
    Am I missing something?

    DB:2.85:Issue In Rendering Datetime Field In Refinement Panel c8

    The settings could not be saved because of an internal error: The managed property Datev1wasaddedDate[0-9][0-9] has an invalid name: The following invalid characters were used: '[', ']'.

    I am getting this error when I give the PropertyName for Manageproperty asmentioned above.

    I guess I amdoing something wrong, can you please let us know where to add this propertyname and what are the steps. If you can give the steps in details it would begreat.

  • RELEVANCY SCORE 2.84

    DB:2.84:Can We Have Multiselect Dimension/Refinements Values In Endeca? sp


    hi,i have one requirement related to multiselection of refinement values. For example: say refinement "SelectMe" have three values say1 selectMe12 selectMe23 selectMe3.on front end i need to use checkbox on these refinement values. if we use checkboxes, then user can check multiple checkboxes at a time.but as per my knowledge we can select only one refinement value at a time in endeca, so that we can send its dimension id as selection.can we achieve this through endeca directly? Please suggest on this.thanks,vijay

  • RELEVANCY SCORE 2.84

    DB:2.84:Multiple Dependent Table Type Value Sets Based On A Single Table. f8


    I need to create table dependent value sets.

    lets suppose the example.

    Table--1 Table-2 Table-3 Table-4 Table-5 Table-6
    ------- --------------- ------------ ----------
    Column 2 ------- Column 2
    Column 3 ------------------------------ Column 3
    Column 4-------------------------------------------------- Column 4
    Column 5------------------------------------------------------------------- Column 5
    Column 6----------------------------------------------------------------------------------- Column 6
    Column 7
    Column 8
    Column 9
    Column 10
    ...

    ...

    ...

    Column 30

    So i want to create 6 values sets based on 6 tables and above are the column mappings.
    Table 2,3,4,5,6 are dependent on Table-1.

    So how to do that?

    DB:2.84:Multiple Dependent Table Type Value Sets Based On A Single Table. f8

    I need to create table dependent value sets.

    lets suppose the example.

    Table--1 Table-2 Table-3 Table-4 Table-5 Table-6
    ------- --------------- ------------ ----------
    Column 2 ------- Column 2
    Column 3 ------------------------------ Column 3
    Column 4-------------------------------------------------- Column 4
    Column 5------------------------------------------------------------------- Column 5
    Column 6----------------------------------------------------------------------------------- Column 6
    Column 7
    Column 8
    Column 9
    Column 10
    ...

    ...

    ...

    Column 30

    So i want to create 6 values sets based on 6 tables and above are the column mappings.
    Table 2,3,4,5,6 are dependent on Table-1.

    So how to do that?

  • RELEVANCY SCORE 2.84

    DB:2.84:Expanding Tables Downward *Sometimes* Autofills Rows sa


    I have a table where column 1 is date, column 2 is a sumif calculation from another table, and column 3 is another calculation. The table is about 19 rows.

    I drag the table downward and column2 gets autofilled, the others don't.

    Why? And how do I control that behavior.

    I'd like to have that functionality sometimes, and not others. But I don't know how to turn it on or off.

    Related question:

    I have a chart that depends on a table. There's a data point plotted for each row. When I drag the table downward to create a new row, that new row is automatically added to the chart - the chart expands rightward (well actually, the chart's dimensions stay the same, but everything inside it squooshes to make room for the new data on the right side of the chart). But I created another chart off based off of another table, and I can't duplicate that functionality.

    It appears to be something about how the table is formatted. Because if I create a brand new chart for Table 1, expanding Table 1 downward expands the chart. If I create a brand new chart for Table 2, expanding Table 2 downward does not expand the chart.

    What did I do with Table 1 to enable that functionality? (I like that functionality and want to enable it on my second table.)

    DB:2.84:Expanding Tables Downward *Sometimes* Autofills Rows sa

    Thanks - anyone have ideas on how the chart growth is controlled? I like it when the chart automatically grows to handle new data rows.

  • RELEVANCY SCORE 2.83

    DB:2.83:Custom Refinement Panel For All Users 3j


    Hi
    i made a custom refinement panel with custom properties everything works fine but only the users that modify the panel can see the custom properties added in the refinement panel. What i need to do to enable the custom refinement panel for all the users?

    DB:2.83:Custom Refinement Panel For All Users 3j

    Hi
    i made a custom refinement panel with custom properties everything works fine but only the users that modify the panel can see the custom properties added in the refinement panel. What i need to do to enable the custom refinement panel for all the users?

  • RELEVANCY SCORE 2.82

    DB:2.82:Create A Custom Search Refinement Filter Web Part x7


    Hi all,
    We need to create a refinement filterthat displays an hierarchical structure (based on managed metadata). As far as I could check it is not supported by the default refinement filter and I found some comments that it is just possible creating
    a custom refinement web part.
    Could you please send me some reference on how to create a custom refinement filter web part? I could not find any reference regarding this. Themost simmilarwas this

    http://www.chaholl.com/archive/2011/03/29/building-a-custom-refinement-filter-generator-for-sharepoint-2010.aspx, that seems not to provide what we need.

    Thanks!

    Sergio

  • RELEVANCY SCORE 2.82

    DB:2.82:How To Use Refinement With Custom Search Code In Sharepoint 2010 a9


    Hi folks,
    I have built a custom search box search results page using KeywordQuery. I am successfully able to query SharePoint and get the required results. But not able to get the refinement working (for OOTB as well as custom managed properties).
    I came across some links where it says refinement is only available for FAST search using customization, but did not find any official statement.

    My logic - I am doing this the way SharePoint does, based on the URL query string(s), where -
    k = search query
    s = scope
    r = selected refinement

    I tried using below line, but it does not return any results.
    keywordQuery.Refiners = author;
    keywordQuery.RefinementFilters.Add(author=\USER NAME\);

    If any of you have came across such scenario or have any ides, please help.

    DB:2.82:How To Use Refinement With Custom Search Code In Sharepoint 2010 a9

    Thanks Dennis. The links you shared confirmed that the Refinement properties are available for FAST search only.

    I created my own logic to read all the refinement parameters (clicked by the user from the Refinement Panel) from the query string r=[refiners here] and then extract every refiner and pass them as a query parameter again in the query string k=[query] [refinement
    parameter 1] [refinement parameter 2] ....

  • RELEVANCY SCORE 2.80

    DB:2.80:Create A List Of Documents Libraries 89



    I how can i create a list of Documents Libraries created on Subsite?!

    On SubSite HomePage of (Department) i would like to put this list here users can find a specific document library and refinement your search.

    Thanks for help

    DB:2.80:Create A List Of Documents Libraries 89

    Hi,

    Here is the PowerShell script which can get you Files-Folders-Libraries:

    #Get all lists in farm
    Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

    #Get the Site collection
    $Site= Get-SPSite http://sharepointsite

    $outputPath = “c:\Portallist.csv”

    Function GetMyFiles($Folder)
    {

    Write-Host “in : “$Folder.Name
    foreach($file in $Folder.Files)
    {
    Write-Host “`t” $file.Name
    Add-Content -Path $outputPath -Value “ File Name : $($file.Name)”

    }

    #Loop through all subfolders and call the function recursively
    foreach ($SubFolder in $Folder.SubFolders)
    {
    if($SubFolder.Name -ne “Forms”)
    {
    Write-Host “`t” -NoNewline
    Add-Content -Path $outputPath -Value “ Folder Name : $($SubFolder.Name)”
    GetMyFiles($Subfolder)

    }
    }

    }
    #Loop throuh all Sub Sites
    foreach($Web in $Site.AllWebs)
    {
    Write-Host “—————————————————–”
    Write-Host “Site Name: ‘$($web.Title)’ at $($web.URL)”
    Add-Content -Path $outputPath -Value “Website : $($web.Title)”
    foreach($list in $Web.Lists)
    {
    #Filter Doc Libs, Eliminate Hidden ones
    if(($List.BaseType -eq “DocumentLibrary”) -and ($List.Hidden -eq $false) )
    {
    Write-Host “——————————————-” “” $List.RootFolder
    Add-Content -Path $outputPath -Value “ Library : $($List.RootFolder)”
    GetMyFiles($List.RootFolder)

    }
    }
    }

    https://imughal.wordpress.com/2013/01/29/iterating-through-all-document-libraries-folder-and-item-using-powershell/

    thxiffi

  • RELEVANCY SCORE 2.79

    DB:2.79:Customise Search Refinement Panel When Searched pm


    How can i customise the Refinement panel when searched.How can i hide all the links in the left side in the search refinement panel.Below is the image of the refinement panel and left side are the links which i want to hude except one.

    DB:2.79:Customise Search Refinement Panel When Searched pm

    Hi Reddy,
    The _layouts/Osssearchresults.aspx(in your screenshot) is not a web part page which is not editable, if you want to customize the refinement panel, you need to create a custom Osssearchresults page as your requirement. Or use a Enterprise Search Center site
    search result page(i.e. results.aspx) for the site collection and then customize the refinement panel, here are some related posts,
    http://social.technet.microsoft.com/Forums/en-US/sharepointsearchlegacy/thread/eb76715d-47b9-4cb2-a498-6d115e46ed08/
    http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2010/12/09/configuring-contextual-search-to-use-search-center.aspx
    ThanksDaniel Yang
    TechNet Community Support

  • RELEVANCY SCORE 2.79

    DB:2.79:Please Can You Help Me Now Quickly Quickly pf


    I have a table and this table has column that has duplicate values
    but now I want to add unique constraint on this column , but I don't want to validate the previos data (found in the column)
    I cannot create this constraint
    I can create it with disable option, but how I can enable it
    I wrote ALTER TABLE test ENABLE NOVALIDATE unique(id2);
    where id2 is the desired column
    but I saw this error ORA-02299: cannot validate (HR.CONS) - duplicate keys found
    and I want to save the found data in the column
    please help me

    thanks

    DB:2.79:Please Can You Help Me Now Quickly Quickly pf

    This, and other options, are demonstrated on the CONSTRAINTS page of Morgan's Library at www.psoug.org.

    Consider NOVALIDATE RELY if you are doing what it now appears you are doing.

  • RELEVANCY SCORE 2.78

    DB:2.78:What's The Best Way To Calculate Table Usage In Mb? z8


    Given a table structure, and knowing it will receive 30.000 new entries on each month, how do I calculate the table growth in kb?
    Also, how can I calculate initial disk ocupation from the table?
    Is there an equation or formula that I can apply using column definition as params?

    That's one of the tables on my application I have to calculate:

    CREATE TABLE "LOG_PESQUISA"
    ("COD_LOG_PESQUISA" NUMBER(10,0) NOT NULL ENABLE,
    "TXT_PCHAVE" VARCHAR2(100),
    "IND_DIGITAL" NUMBER(1,0) NOT NULL ENABLE,
    "VLR_TOTALFISICO" NUMBER(9,0) NOT NULL ENABLE,
    "VLR_TOTALDIGITAL" NUMBER(9,0) NOT NULL ENABLE,
    "IND_FISICO" NUMBER(1,0) NOT NULL ENABLE,
    "TXT_CODIGO" VARCHAR2(50),
    "TXT_BOOLEAN_TYPE" VARCHAR2(3),
    "IND_DATA" NUMBER(1,0) NOT NULL ENABLE,
    "DAT_INI" DATE,
    "DAT_FIM" DATE,
    "COD_COLECAO" NUMBER(10,0),
    "COD_CREDITO" NUMBER(10,0),
    "VLR_EDICAO" NUMBER(5,0),
    "IND_TAMANHO" VARCHAR2(2),
    "IND_PUBLICADAS" NUMBER(1,0) NOT NULL ENABLE,
    "IND_SOBRAS" NUMBER(1,0) NOT NULL ENABLE,
    "IND_LUI" NUMBER(1,0) NOT NULL ENABLE,
    "IND_AUI" NUMBER(1,0) NOT NULL ENABLE,
    "COD_USU_INC" VARCHAR2(30) NOT NULL ENABLE,
    "DAT_INC" DATE NOT NULL ENABLE,
    "ID_CREDITO" NUMBER(10,0),
    "IND_PCHAVE" NUMBER(1,0) NOT NULL ENABLE,
    "IND_HEADLINE" NUMBER(1,0) NOT NULL ENABLE,
    "IND_LEGENDA" NUMBER(1,0) NOT NULL ENABLE,
    CONSTRAINT "LOG_PESQUISA_PESQUISA_PK" PRIMARY KEY ("COD_LOG_PESQUISA") ENABLE
    )
    /

    DB:2.78:What's The Best Way To Calculate Table Usage In Mb? z8

    The most accurate approach would be to

    1) Create the table
    2) Load it with some sample data. Make sure that the sample data is as close to reality as possible (i.e. if txt_pchave will be 90 characters 20% of the time, 50 characters 50% of the time, 10 characters 20% of the time and NULL 10% of the time, make sure your sample data reflects that).
    3) Query DBA_SEGMENTS to see how big the table is

    SELECT segment_name table_name, sum(bytes)/1024/1024 MB
    FROM dba_segments
    WHERE segment_name = 'LOG_PESQUISA'4) Multiply by the number of rows that you really expect. You might load 3,000 records in step 2, for example, so you'd multiply by 10 to get the size if you loaded 30,000 records.

    You can extend this to look at the size of the index(es) relatively easily. If you are doing more than straight inserts, you would also want to simulate that to account for things like row migration, empty blocks, etc.

    Justin

  • RELEVANCY SCORE 2.78

    DB:2.78:Unable To Delete Default Refiners In People Refinement Webpart In Sharepoint 2010 k7


    Hi All,
    I want to customize the out-of-the-box People Refinement Panel on a
    people search results page.
    But I cannot see how to remove the default refiners like Result Type, Site, modified date etc.. in the
    People Refinement Panel.
    Please help me out. Thanks in advance :)

    DB:2.78:Unable To Delete Default Refiners In People Refinement Webpart In Sharepoint 2010 k7

    Hi Sairam,

    After you do a search on people scope, on the people results page, go to site actions-click edit page. Then you will
    see the people refinement panel web part, click edit web part, expand refinement section, filter category definition, click … to the definition. Try to copy the text to notepad or vs, remove one category tag which refiner you want to remove based on the title.
    Like remove view:
    Category
    Title=View Description=View matches by
    Type=Microsoft.Office.Server.Search.WebControls.RankingModelFilterGenerator
    MetadataThreshold=3 NumberOfFiltersToDisplay=3
    ShowMoreLink=False MappedProperty=/
    What's important, you should also uncheck the use default configuration.
    For more information about customize refinement web part:
    http://johnrossjr.wordpress.com/2011/03/24/customizing-the-refinement-panel-for-sharepoint-2010-search/

    Best Regards.

    Kelly Chen
    TechNet Community Support

  • RELEVANCY SCORE 2.78

    DB:2.78:Enable Cdc On One Column z8


    Hi, can cdc be enabled on just one column in a table?

    LISA86

    DB:2.78:Enable Cdc On One Column z8

    Not really- the list of monitored columns must include those in the primary key (or unique index) at a minimum - plus any informational columns of interest.

  • RELEVANCY SCORE 2.77

    DB:2.77:Select List Enable / Disable In Tabular Form 31


    Hi,

    I have created report on (ACT_COA_SEGMENT_MAS) table and this is master table , and created link on this report, when i click on report link, control moves to tabular form that is based on detail table (ACT_SEGMENT_VALUES_MAS)

    In master table there is column,

    SEGMENT_ID number primary key;
    QUALIFIER varchar2(1);

    If in master table qualifier column value is 'N' then

    then in detail table (ACT_SEGMENT_VALUES_MAS) column account type cannot be null and column should enable.
    If in master table QUALIFIER column value other than 'N' then Account column in detail table should disable . and value should not be enterable.
    and ACCOUNT_TYPE column in deatil table is a select list.

    How i can do this?

    Thanks Regards
    Vedant

    Edited by: Vedant on Jan 10, 2013 10:14 PM

    DB:2.77:Select List Enable / Disable In Tabular Form 31

    Vedant wrote:
    If in master table qualifier column value is 'N' then

    then in detail table (ACT_SEGMENT_VALUES_MAS) column account type cannot be null and column should enable.
    If in master table QUALIFIER column value other than 'N' then Account column in detail table should disable . and value should not be enterable.
    and ACCOUNT_TYPE column in deatil table is a select list.

    How i can do this?One way - sadly a bit of work - would be to use APEX_APPLICATION_ITEM to generated the detail items as a manual tablular form where you can control the disabled property when generating the tabular form fields using CASE statements, writing manual PL/SQL processes and the built-in APEX_ITEM collection to manually perform insert/update/delete operations on submit. Check the documentation for the full syntax of using APEX_ITEM functions to generate HTML items.

    An example from the Oracle docs looks like
    SELECT
    empno,
    APEX_ITEM.HIDDEN(1,empno)||
    APEX_ITEM.TEXT(2,ename) ename,
    APEX_ITEM.TEXT(3,job) job,
    mgr,
    APEX_ITEM.DATE_POPUP(4,rownum,hiredate,'dd-mon-yyyy') hiredate,
    APEX_ITEM.TEXT(5,sal) sal,
    APEX_ITEM.TEXT(6,comm) comm,
    deptno
    FROM emp
    ORDER BY 1where the disabled property could be specified in the unlisted fifth argument to APEX_ITEM.TEXT. The first item to the APEX_ITEM calls is a number defining the G_FXX global variables so that 1 identifies the item later as apex_application.g_f01(9) - 9 being symbolic for a collection identifier -, ename as apex_application.g_f02(i),m and so on. The G_F99 items can be reference on submission in Pl/SQL processes through looping, something like (this example assumes all array items are populated - under some circumstances they may not be)

    for i in 1..apex_application.g_f01.count loop
    update my_table set sal = apex_application.g_f05(i) where empno = apex_application.g_f01(i);
    end loop;Edited by: riedelme on Jan 11, 2013 7:12 AM

  • RELEVANCY SCORE 2.76

    DB:2.76:Table Cell Renderer d7


    Hi,
    I have a JTable with 2 columns. One of the column is editable. But depending on a checkbox selection outside the table, I need to make the column noneditable, i.e. if the checkbox is selected the column is editable else the column is non-editable.
    To enable this I have rendered the column as below:

    // rendered the column
    col2.setCellRenderer(new EnableCellRenderer(flag)); //flag is either true or false

    class EnableCellRenderer extends DefaultTableCellRenderer {
    boolean isEnable;

    public EnableCellRenderer(boolean enable) {
    isEnable = enable;
    }

    public Component getTableCellRendererComponent(JTable table, Object value,
    boolean isSelected,
    boolean hasFocus, int row, int column) {
    setEnabled(isEnable);
    return super.getTableCellRendererComponent(table, value, isSelected,
    hasFocus, row, column);
    }
    }This is working fine but whats happening is when the column is disabled(I am not able to edit which is fine), it is not getting greyed out,
    I mean the backgroung color is still white. Is there any way how I can disable the column as well as grey out the column.

    Thanks

    DB:2.76:Table Cell Renderer d7

    I would override the isCellEditable(...) method of JTable. Something like:
    if (column == ??? !isEnabled)
    return false;
    else
    return true;

  • RELEVANCY SCORE 2.75

    DB:2.75:Sharepoint 2010 Search Refinement Panel- String;# For Calculated Column xz


    I have a calculated column for Report Year that shows on the refinement panel as for example string;#2014. I saw a post to hard code it using the custom filter

    https://social.technet.microsoft.com/Forums/en-US/260afea2-45e4-41f6-879d-bff7a7ac7e8f/using-calculated-columns-in-the-search-refinement-panel?forum=sharepointgeneralprevious
    But is there a way other than hard coding since forme the report year span back from 1970 to 2015. So I have to hard code for those many years.

    DB:2.75:Sharepoint 2010 Search Refinement Panel- String;# For Calculated Column xz

    Hi Wendy, We are using SharePoint 2010. Is there a fix for this for SharePoint 2010.

  • RELEVANCY SCORE 2.75

    DB:2.75:How To Enable Fga In 9i c8


    Hi,

    Oracle database version : 9.2.0.8
    OS: Linux4

    as per client requirement we need to enable Fine Grain Auditing.

    So please provide the process to enable FGA in 9.20.8 database and also provide procedure how to enable FGA on particular table or particular column on a table.

    Also let me know what are the views to get the Audit info on that column.

    It's too Urgent please update ASAP.

    Thanks,
    Naveen.

    DB:2.75:How To Enable Fga In 9i c8

    Thank u very very very much Brother!!!!!!!!!! for ur immediate response

  • RELEVANCY SCORE 2.75

    DB:2.75:How To Create Content Type Search Scope Depending On Each Site Collection? js


    Hello
    I am using Sp2010 Standardrd version. I want to display site collection's related contentype in search refinment panel. How can I do this?
    I also try to add manual scope for specific content type with the help of following article, but scopes are not appearing in refinement panel.
    http://www.glynblogs.com/2011/01/create-a-content-type-search-refinement-panel-in-sharepoint-2010.html
    Is there blog or article, where I can find article step-by-step for creating content type search scope in refinement panel manually or thru the code?
    Regards
    Avi

    DB:2.75:How To Create Content Type Search Scope Depending On Each Site Collection? js

    Hello Avi
    I saw your xml, there is nothing wrong with your xml. There are basically 3 reason to know why are the Refiners are not showing.

    A full crawl has not been executed after the managed property has been created.The result set is not big enough to contain data for the relevant column to make the refiner meaningful, please upload more documents at least 10-20 and thne do the full crawl againThe refiners are shown in the order they are defined in the XML. For example, if the new refiner category is placed as category number 7, but the refinement panel is configured to show only the first six categories, it will not be displayed in the panel
    (if the first six categories are shown).
    Please review above points and let me know this works for your or not.
    Ashish KanoongoAshish Kanoongo, MCP, MCSD, MCTS http://akanoongo.blogspot.in/

  • RELEVANCY SCORE 2.75

    DB:2.75:Fk Constraint 38


    Hello ..
    I had this problem before .. but for some reason .. I am still missing foreign keys which need disabling before I can extend a PK to include an extra column in Ora 9.2.

    I am running the following to pick up all FK's that reference my table ..

    select 'alter table '||table_name||' disable constraint '||constraint_name||';' from all_constraints where owner = 'ADM_USER' and constraint_type = 'R' and r_constraint_name in
    ( select constraint_name from all_constraints where table_name = 'REF_CURRENCY');

    and then enable them after tinkering with the PK..

    PK is presently just one column iso_code .. so I also make a unique index on iso_code after dropping the Pk to satisfy the existing data.

    What FK's am I missing?

    Here is the listing .. .
    -- disable all foreign keys
    alter table CLN_ACCOUNT disable constraint FK_ACCT_CRCY_ALT;
    alter table CLN_ACCOUNT disable constraint FK_ACCT_CRCY_PORTFOLIO;
    alter table CLN_ACCOUNT disable constraint FK_ACCT_CRCY_ACCOUNT;
    alter table CLN_CREDIT disable constraint FK_CRDT_CRCY_CAPITAL;
    alter table CLN_FACILITY_FOR_ACCOUNT disable constraint FCAC_CRCY_AVAILABILITY;
    alter table CLN_FACILITY_FOR_ACCOUNT disable constraint FK_FCAC_CRCY_LIMIT;
    alter table CLN_FACILITY_FOR_ACCOUNT disable constraint FK_FCAC_CRCY_UTILISATION;
    alter table CLN_MANDATE disable constraint FK_MNDT_CRCY_ALT;
    alter table CLN_MANDATE disable constraint FK_MNDT_CRCY_CREDIT_LIMIT;
    alter table CLN_MANDATE disable constraint FK_MNDT_CRCY_MANDATE;
    alter table CLN_MANDATE disable constraint FK_MNDT_CRCY_CREDIT_UTIL;
    alter table CLN_PORTFOLIO disable constraint FK_PTFL_CRCY_ALT;
    alter table CLN_PORTFOLIO disable constraint FK_PTFL_CRCY_CREDIT_LIMIT;
    alter table CLN_PORTFOLIO disable constraint FK_PTFL_CRCY_PORTFOLIO;
    alter table CLN_PORTFOLIO disable constraint FK_PTFL_CRCY_CREDIT_UTIL;
    alter table CLN_POSITION disable constraint FK_POSN_CRCY_ASSET;
    alter table CLN_POSITION disable constraint FK_POSN_CRCY_PTF;
    alter table CLN_UTILISATION_FOR_ACCOUNT disable constraint FK_UTAC_CRCY_UTILISATION;
    alter table FTN_CASH_MOVEMENT disable constraint FK_CMVT_CRCY_ACCOUNT;
    alter table FTN_LIFE_ASSURANCE disable constraint FK_LASS_CCY;
    alter table FTN_LIFE_ASSURANCE_POSITION disable constraint FK_LASSP_ASSCCY;
    alter table FTN_LIFE_ASSURANCE_POSITION disable constraint FK_LASSP_CCY;
    alter table FTN_SECURITY_MOVEMENT disable constraint FK_SMVT_CRCY_ACCOUNT;
    alter table FTN_SECURITY_MOVEMENT disable constraint FK_SMVT_CRCY_CLIENT;
    alter table FTN_SECURITY_MOVEMENT disable constraint FK_SMVT_CRCY_SETTELEMNT;
    alter table FTN_SECURITY_MOVEMENT disable constraint FK_SMVT_CRCY_QUOT_ASSET;
    alter table FTN_SECURITY_MOVEMENT disable constraint FK_SMVT_CRCY_ASSET;
    alter table FTN_SECURITY_MOVEMENT disable constraint FK_SMVT_CRCY_ACCT;
    alter table PAY_PAYMENT_FX disable constraint FK_PAY_FX_CCY_FROM;
    alter table REF_ASSET disable constraint FK_ASST_CRCY_LOCAL;
    alter table REF_ASSET disable constraint FK_ASST_CRCY_PRICE;
    alter table REF_CREDIT_AUTHORITY disable constraint FK_CRAU_RCURR;

    -- disable PK Constraint on REF_CURRENCY

    alter table REF_CURRENCY drop constraint PK_CURRENCY;

    -- Create new PK for REF_CURRENCY
    alter table REF_CURRENCY ADD constraint PK_CURRENCY PRIMARY KEY (ISO_CODE, ANNULLED_IND);

    -- Create new constraint for FK's to refer to
    alter table REF_CURRENCY ADD constraint ISO_CODE_U UNIQUE (ISO_CODE);

    -- enable all foreign keys
    alter table CLN_ACCOUNT enable constraint FK_ACCT_CRCY_ALT;
    alter table CLN_ACCOUNT enable constraint FK_ACCT_CRCY_PORTFOLIO;
    alter table CLN_ACCOUNT enable constraint FK_ACCT_CRCY_ACCOUNT;
    alter table CLN_CREDIT enable constraint FK_CRDT_CRCY_CAPITAL;
    alter table CLN_FACILITY_FOR_ACCOUNT enable constraint FCAC_CRCY_AVAILABILITY;
    alter table CLN_FACILITY_FOR_ACCOUNT enable constraint FK_FCAC_CRCY_LIMIT;
    alter table CLN_FACILITY_FOR_ACCOUNT enable constraint FK_FCAC_CRCY_UTILISATION;
    alter table CLN_MANDATE enable constraint FK_MNDT_CRCY_ALT;
    alter table CLN_MANDATE enable constraint FK_MNDT_CRCY_CREDIT_LIMIT;
    alter table CLN_MANDATE enable constraint FK_MNDT_CRCY_MANDATE;
    alter table CLN_MANDATE enable constraint FK_MNDT_CRCY_CREDIT_UTIL;
    alter table CLN_PORTFOLIO enable constraint FK_PTFL_CRCY_ALT;
    alter table CLN_PORTFOLIO enable constraint FK_PTFL_CRCY_CREDIT_LIMIT;
    alter table CLN_PORTFOLIO enable constraint FK_PTFL_CRCY_PORTFOLIO;
    alter table CLN_PORTFOLIO enable constraint FK_PTFL_CRCY_CREDIT_UTIL;
    alter table CLN_POSITION enable constraint FK_POSN_CRCY_ASSET;
    alter table CLN_POSITION enable constraint FK_POSN_CRCY_PTF;
    alter table CLN_UTILISATION_FOR_ACCOUNT enable constraint FK_UTAC_CRCY_UTILISATION;
    alter table FTN_CASH_MOVEMENT enable constraint FK_CMVT_CRCY_ACCOUNT;
    alter table FTN_LIFE_ASSURANCE enable constraint FK_LASS_CCY;
    alter table FTN_LIFE_ASSURANCE_POSITION enable constraint FK_LASSP_ASSCCY;
    alter table FTN_LIFE_ASSURANCE_POSITION enable constraint FK_LASSP_CCY;
    alter table FTN_SECURITY_MOVEMENT enable constraint FK_SMVT_CRCY_ACCOUNT;
    alter table FTN_SECURITY_MOVEMENT enable constraint FK_SMVT_CRCY_CLIENT;
    alter table FTN_SECURITY_MOVEMENT enable constraint FK_SMVT_CRCY_SETTELEMNT;
    alter table FTN_SECURITY_MOVEMENT enable constraint FK_SMVT_CRCY_QUOT_ASSET;
    alter table FTN_SECURITY_MOVEMENT enable constraint FK_SMVT_CRCY_ASSET;
    alter table FTN_SECURITY_MOVEMENT enable constraint FK_SMVT_CRCY_ACCT;
    alter table PAY_PAYMENT_FX enable constraint FK_PAY_FX_CCY_FROM;
    alter table REF_ASSET enable constraint FK_ASST_CRCY_LOCAL;
    alter table REF_ASSET enable constraint FK_ASST_CRCY_PRICE;
    alter table REF_CREDIT_AUTHORITY enable constraint FK_CRAU_RCURR;

    OUTPUT..
    -- disable all foreign keys
    alter table CLN_ACCOUNT disable constraint FK_ACCT_CRCY_ALT
    Table altered

    alter table CLN_ACCOUNT disable constraint FK_ACCT_CRCY_PORTFOLIO
    Table altered

    alter table CLN_ACCOUNT disable constraint FK_ACCT_CRCY_ACCOUNT
    Table altered

    alter table CLN_CREDIT disable constraint FK_CRDT_CRCY_CAPITAL
    Table altered

    alter table CLN_FACILITY_FOR_ACCOUNT disable constraint FCAC_CRCY_AVAILABILITY
    Table altered

    alter table CLN_FACILITY_FOR_ACCOUNT disable constraint FK_FCAC_CRCY_LIMIT
    Table altered

    alter table CLN_FACILITY_FOR_ACCOUNT disable constraint FK_FCAC_CRCY_UTILISATION
    Table altered

    alter table CLN_MANDATE disable constraint FK_MNDT_CRCY_ALT
    Table altered

    alter table CLN_MANDATE disable constraint FK_MNDT_CRCY_CREDIT_LIMIT
    Table altered

    alter table CLN_MANDATE disable constraint FK_MNDT_CRCY_MANDATE
    Table altered

    alter table CLN_MANDATE disable constraint FK_MNDT_CRCY_CREDIT_UTIL
    Table altered

    alter table CLN_PORTFOLIO disable constraint FK_PTFL_CRCY_ALT
    Table altered

    alter table CLN_PORTFOLIO disable constraint FK_PTFL_CRCY_CREDIT_LIMIT
    Table altered

    alter table CLN_PORTFOLIO disable constraint FK_PTFL_CRCY_PORTFOLIO
    Table altered

    alter table CLN_PORTFOLIO disable constraint FK_PTFL_CRCY_CREDIT_UTIL
    Table altered

    alter table CLN_POSITION disable constraint FK_POSN_CRCY_ASSET
    Table altered

    alter table CLN_POSITION disable constraint FK_POSN_CRCY_PTF
    Table altered

    alter table CLN_UTILISATION_FOR_ACCOUNT disable constraint FK_UTAC_CRCY_UTILISAT
    Table altered

    alter table FTN_CASH_MOVEMENT disable constraint FK_CMVT_CRCY_ACCOUNT
    Table altered

    alter table FTN_LIFE_ASSURANCE disable constraint FK_LASS_CCY
    Table altered

    alter table FTN_LIFE_ASSURANCE_POSITION disable constraint FK_LASSP_ASSCCY
    Table altered

    alter table FTN_LIFE_ASSURANCE_POSITION disable constraint FK_LASSP_CCY
    Table altered

    alter table FTN_SECURITY_MOVEMENT disable constraint FK_SMVT_CRCY_ACCOUNT
    Table altered

    alter table FTN_SECURITY_MOVEMENT disable constraint FK_SMVT_CRCY_CLIENT
    Table altered

    alter table FTN_SECURITY_MOVEMENT disable constraint FK_SMVT_CRCY_SETTELEMNT
    Table altered

    alter table FTN_SECURITY_MOVEMENT disable constraint FK_SMVT_CRCY_QUOT_ASSET
    Table altered

    alter table FTN_SECURITY_MOVEMENT disable constraint FK_SMVT_CRCY_ASSET
    Table altered

    alter table FTN_SECURITY_MOVEMENT disable constraint FK_SMVT_CRCY_ACCT
    Table altered

    alter table PAY_PAYMENT_FX disable constraint FK_PAY_FX_CCY_FROM
    Table altered

    alter table REF_ASSET disable constraint FK_ASST_CRCY_LOCAL
    Table altered

    alter table REF_ASSET disable constraint FK_ASST_CRCY_PRICE
    Table altered

    alter table REF_CREDIT_AUTHORITY disable constraint FK_CRAU_RCURR
    Table altered

    -- disable PK Constraint on REF_CURRENCY

    alter table REF_CURRENCY drop constraint PK_CURRENCY
    ORA-02273: this unique/primary key is referenced by some foreign keys
    -- Create new PK for REF_CURRENCY
    alter table REF_CURRENCY ADD constraint PK_CURRENCY PRIMARY KEY (ISO_CODE, ANNUL
    ORA-02260: table can have only one primary key
    -- Create new constraint for FK's to refer to
    alter table REF_CURRENCY ADD constraint ISO_CODE_U UNIQUE (ISO_CODE)
    ORA-02261: such unique or primary key already exists in the table
    -- enable all foreign keys
    alter table CLN_ACCOUNT enable constraint FK_ACCT_CRCY_ALT
    Table altered

    alter table CLN_ACCOUNT enable constraint FK_ACCT_CRCY_PORTFOLIO
    Table altered

    alter table CLN_ACCOUNT enable constraint FK_ACCT_CRCY_ACCOUNT
    Table altered

    alter table CLN_CREDIT enable constraint FK_CRDT_CRCY_CAPITAL
    Table altered

    alter table CLN_FACILITY_FOR_ACCOUNT enable constraint FCAC_CRCY_AVAILABILITY
    Table altered

    alter table CLN_FACILITY_FOR_ACCOUNT enable constraint FK_FCAC_CRCY_LIMIT
    Table altered

    alter table CLN_FACILITY_FOR_ACCOUNT enable constraint FK_FCAC_CRCY_UTILISATION
    Table altered

    alter table CLN_MANDATE enable constraint FK_MNDT_CRCY_ALT
    Table altered

    alter table CLN_MANDATE enable constraint FK_MNDT_CRCY_CREDIT_LIMIT
    Table altered

    alter table CLN_MANDATE enable constraint FK_MNDT_CRCY_MANDATE
    Table altered

    alter table CLN_MANDATE enable constraint FK_MNDT_CRCY_CREDIT_UTIL
    Table altered

    alter table CLN_PORTFOLIO enable constraint FK_PTFL_CRCY_ALT
    Table altered

    alter table CLN_PORTFOLIO enable constraint FK_PTFL_CRCY_CREDIT_LIMIT
    Table altered

    alter table CLN_PORTFOLIO enable constraint FK_PTFL_CRCY_PORTFOLIO
    Table altered

    alter table CLN_PORTFOLIO enable constraint FK_PTFL_CRCY_CREDIT_UTIL
    Table altered

    alter table CLN_POSITION enable constraint FK_POSN_CRCY_ASSET
    Table altered

    alter table CLN_POSITION enable constraint FK_POSN_CRCY_PTF
    Table altered

    alter table CLN_UTILISATION_FOR_ACCOUNT enable constraint FK_UTAC_CRCY_UTILISATI
    Table altered

    alter table FTN_CASH_MOVEMENT enable constraint FK_CMVT_CRCY_ACCOUNT
    Table altered

    alter table FTN_LIFE_ASSURANCE enable constraint FK_LASS_CCY
    Table altered

    alter table FTN_LIFE_ASSURANCE_POSITION enable constraint FK_LASSP_ASSCCY
    Table altered

    alter table FTN_LIFE_ASSURANCE_POSITION enable constraint FK_LASSP_CCY
    Table altered

    alter table FTN_SECURITY_MOVEMENT enable constraint FK_SMVT_CRCY_ACCOUNT
    Table altered

    alter table FTN_SECURITY_MOVEMENT enable constraint FK_SMVT_CRCY_CLIENT
    Table altered

    alter table FTN_SECURITY_MOVEMENT enable constraint FK_SMVT_CRCY_SETTELEMNT
    Table altered

    alter table FTN_SECURITY_MOVEMENT enable constraint FK_SMVT_CRCY_QUOT_ASSET
    Table altered

    alter table FTN_SECURITY_MOVEMENT enable constraint FK_SMVT_CRCY_ASSET
    Table altered

    alter table FTN_SECURITY_MOVEMENT enable constraint FK_SMVT_CRCY_ACCT
    Table altered

    alter table PAY_PAYMENT_FX enable constraint FK_PAY_FX_CCY_FROM
    Table altered

    alter table REF_ASSET enable constraint FK_ASST_CRCY_LOCAL
    Table altered

    alter table REF_ASSET enable constraint FK_ASST_CRCY_PRICE
    Table altered

    alter table REF_CREDIT_AUTHORITY enable constraint FK_CRAU_RCURR
    Table altered

    Regards
    Jag

    DB:2.75:Fk Constraint 38

    Thanks .. yep I knew it was something that simple ..

  • RELEVANCY SCORE 2.74

    DB:2.74:How To Disable/Enable A Column On Standard Table 3p


    Hi all,

    How to disable or enable a column on row level based on another column? It is a standard page. Cannot add switcher via personalization.

    Regards.

    Anil

    DB:2.74:How To Disable/Enable A Column On Standard Table 3p

    Hi all,

    How to disable or enable a column on row level based on another column? It is a standard page. Cannot add switcher via personalization.

    Regards.

    Anil

  • RELEVANCY SCORE 2.74

    DB:2.74:Refiners Coverage Report px


    Hi all,
    I would like to know how can I create a report based on the refiners coverage.
    For example, I want to know how many values exists for one category in relation with all crawled items.
    - 100.000 items crawled
    - Category = MetadataField

    Value1 = 45.457Value2 = 21.332Value3 = 14.356...ValueN = 784NoValue = 1.538
    All these values represent in fact the counts which exists in Refinement Panel.
    However, there is no refiner value for items which have NoValue. (How can we include this, in order to appear in Refinement Panel?)
    Many thanks for any ideea.

    OvidiuG

    DB:2.74:Refiners Coverage Report px

    Hi all,
    I would like to know how can I create a report based on the refiners coverage.
    For example, I want to know how many values exists for one category in relation with all crawled items.
    - 100.000 items crawled
    - Category = MetadataField

    Value1 = 45.457Value2 = 21.332Value3 = 14.356...ValueN = 784NoValue = 1.538
    All these values represent in fact the counts which exists in Refinement Panel.
    However, there is no refiner value for items which have NoValue. (How can we include this, in order to appear in Refinement Panel?)
    Many thanks for any ideea.

    OvidiuG

  • RELEVANCY SCORE 2.74

    DB:2.74:Search Refinement Panel Customization Not Showing All The Metadata Choices That It Should c1


    hi all,

    i'm relatively new to sharepoint and
    i madesome customizations torefinement panel on search page. specifically i added a few metadata columns to the refinement panel. in some cases those columns
    in their libraries allow people to select multiple answers. so a single document might have 3 or 4 or 5 entries in that one choice column.

    now for the issue, in the refinement panel, it appears to be working...in other words, i see my new metadata and i see documents being found. however, a
    single document is not showing up in all of the 'metadata' choice options that it should show up in.
    here's the specifics...

    this is thexml for that first refinement category.
    Category Title=Subject/Service Area Description=What Subject or Service Area is the document categorized under?

    Type=Microsoft.Office.Server.Search.WebControls.ManagedPropertyFilterGenerator MetadataThreshold=1

    NumberOfFiltersToDisplay=8 MaxNumberOfFilters=0 SortBy=Frequency SortByForMoreFilters=Name

    SortDirection=Descending SortDirectionForMoreFilters=Ascending ShowMoreLink=True

    MappedProperty=ServiceAreaSubjects MoreLinkText=show more LessLinkText=show fewer ShowCounts=Count/

    it seems to be working except ....

    Subject/Service Area in use allows people to select multiple options. so a documentbe labeled as:a) seniors/aging; b) youth/afterschool; c) food
    meals on wheels (where items between the; are separate Subject/Service Area). In the example belowthe first document in the search result senior nutrition programhas the following properties for subject/service area:
    food-meals on wheels/seniors; seniors/aging; seniors services.

    In the refinement panel (above) it doesn'tdoesnt show foodmeals on wheels at all.

    I have the MetadataThreshold=1, so Im confused. ANY guidance would be greatly appreciated!!

    Thank you so much for any tips or points you have time to give.

    paige
    Paige Teegarden

    DB:2.74:Search Refinement Panel Customization Not Showing All The Metadata Choices That It Should c1

    Ifthat cateogry tag (.Set Type=Microsoft.Office.Server.Search.WebControls.TaxonomyFilterGenerator) needed to be changed, wouldn't it have not worked at all?
    as it is and my original post shows, i am getting refinements based on my managed categories. it just isn't picking up all of the choices that are selected for a particular document.
    am i missing something?

    Paige Teegarden

  • RELEVANCY SCORE 2.74

    DB:2.74:Custom Refinement Filters - Empty Value z7


    I'm trying to edit the refinement panel and now I need to create a filter that shows all the empty values of a column.
    For example I have a column date and this column is sometimes empty.
    How can create two predifinedfilters where the first (=Yes)will show all the items with a date and another filter (=No)where Iget all the items with no date?
    So something like this:

    I tried with

    CustomFilter CustomValue=No (empty date)
    OriginalValue/OriginalValue
    /CustomFilter

    or

    CustomFilter CustomValue=No (empty date)
    OriginalValue xsi:nil=true/
    /CustomFilter

    Butwithout succes...

    DB:2.74:Custom Refinement Filters - Empty Value z7

    Hi Qiao Wei,

    Tnx for the reply but I don't think you understood my question. I don't have problems with getting results, this is working fine. But now I want to work with predifined filters and not the default filters. Where one ofmy predifinedfilters (No
    (empty date))should have all the items where my date is empty.

    I'm sure I have enough results (more then 10.000 for each filter).

    So my question is, how to filter on empty values in a custom filter?

    Is it clear now or do you need more information?

  • RELEVANCY SCORE 2.74

    DB:2.74:Refinement Panel Count mj


    Hi,
    I'm having a problem with the count in the Refinement Panel for manage property that mapped to the multiple value field (multiple choice/lookup). - this error also happen for single value metadata column type.
    I use the custom refinement panel from chahollhttp://www.chaholl.com/archive/2010/08/20/creating-a-custom-refinement-filter-generator.aspxbut
    I found this problem also occurs with the sharepoint default refinement panel webpart too.
    For example when I do the search first it shown the refinement item with count=5 and about 300 results. After I click the refinement item (which is 5) then it changed to 6 and show 6 results. I've set the accuracy index to 500, not sure if there is any other
    setting that need to change ? or thisbehavioris expected from the refinement panel ?
    Regards.

    rus

    DB:2.74:Refinement Panel Count mj

    Thanks for the links but it doesn't answer why the count shown in not sync at the first place. It seem the deep refinement from the FAST search is the solution for this matter. Since I don't have it so I can't test it either.rus

  • RELEVANCY SCORE 2.74

    DB:2.74:Dynamically Disable/Enable A Button Based On Currentrow 8m


    I wanted to disable/enable a button in a table based on currentRow.
    Based on this thread:
    http://swforum.sun.com/jive/thread.jspa?forumID=123threadID=54119

    I know that I can bind the disable property to the resultset column that is
    of boolean type. However I am using oracle and it doesn't support boolean.

    How do I convert the column data in JSC?

  • RELEVANCY SCORE 2.74

    DB:2.74:Accessing User Profile Using Shared Services 8a


    I have got two Virtual Machines fully loaded with SharePoint 2010. Machine 1 will consume user profile services from Machine 2. I already have made the necesary changes using Central Admin. Machine1 is using Machine 2 UPS.

    I want to create a Refinement Panel in Machine 1 and create a sub type in Machine 2. The Sub type will have custom user properties. How do I access user properties using shared services and show them on the Refinement Panel in Machine 1. Is it simply the
    matter of making changes to XML file - webpart - Edit Webpart - Refinement - Filter Category Definition (as you would do had the UPS been local)?

    Thanks for your help.
    Cheers
    Mayank

    DB:2.74:Accessing User Profile Using Shared Services 8a

    I have got two Virtual Machines fully loaded with SharePoint 2010. Machine 1 will consume user profile services from Machine 2. I already have made the necesary changes using Central Admin. Machine1 is using Machine 2 UPS.

    I want to create a Refinement Panel in Machine 1 and create a sub type in Machine 2. The Sub type will have custom user properties. How do I access user properties using shared services and show them on the Refinement Panel in Machine 1. Is it simply the
    matter of making changes to XML file - webpart - Edit Webpart - Refinement - Filter Category Definition (as you would do had the UPS been local)?

    Thanks for your help.
    Cheers
    Mayank

  • RELEVANCY SCORE 2.74

    DB:2.74:Rest Query Refinement Limitation: 1000 Refinements Per Refiner 3k


    I work on custom search experience based on SharePoint Search and get data from SharePoint using REST POST queries.
    According to documentationQuery Refinement in SharePoint 2013, i should be able to specify number of refinement items that
    I want to receive from search engine like this
    managedPropery(filter=5000/1/*)
    but when number of bins (5000 in example) is larger than 1000 - server return only first 1000 item.
    How to bypass this limitation? My managed property has much more unique values.

    DB:2.74:Rest Query Refinement Limitation: 1000 Refinements Per Refiner 3k

    Hi,
    The limiation of this caseis 1000, so after my search. I think maybe you can onlydo a custom search to by passit. In sharepoint seetings , I didn't find any way to change this limiation.If you have any qusetion about this development,you can
    ask any question in development forum, or open a case to microsoft.
    PaulShui
    Microsoft Online Community Support

    Please remember to click “Mark as Answer?on the post that helps you, and to click “Unmark as Answer?if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread

  • RELEVANCY SCORE 2.74

    DB:2.74:Search Refinement Panel - Filter Between/After/Before s1


    In the refinement panel after a search, is it possible to have something like the refinement on a list?
    That for example we have a date column, and at the moment the refinement is like this:
    Date:
    Any date
    2/05/2012
    10/06/2013
    15/02/2010
    11/10/2010
    Show more
    In the refinement we don't want to filter on every result but more like show me everything between 2011 and 2012 or show me everything after 2012

    DB:2.74:Search Refinement Panel - Filter Between/After/Before s1

    Hi,
    I saw this solution too, but isn't it possible that the user can choose his own filter like key filters on a list?

  • RELEVANCY SCORE 2.73

    DB:2.73:Faceted Navigation For Bcs External Content Type 3z


    Is it possible to use Faceted Navigation for BCS external content type search results refinement?
    I would like the search result page to show different refinement options based on different refinement categories. This TechNet article says I can use the Faceted Navigation to achive it.

    http://technet.microsoft.com/en-us/library/jj679902.aspx
    However, as the BCS external content type items can't be tagged, I can't get the refinemable managed property to work in Faceted Navigation configuration. This is what I get:

    Then I am curious how I can get it to work...

    DB:2.73:Faceted Navigation For Bcs External Content Type 3z

    The search refiner workson managed property. Have you created managed property for the crawled property corresponding to your external content type column?

  • RELEVANCY SCORE 2.73

    DB:2.73:Search Refinement By Document Subfolder For Unc Share Content Source 3k


    On the SharePoint 2010 search results page any content matched to a UNC file share content source had automatic hierarchical search refinment by subfolder location. How do I recreate this in SharePoint 2013?

    DB:2.73:Search Refinement By Document Subfolder For Unc Share Content Source 3k

    On the SharePoint 2010 search results page any content matched to a UNC file share content source had automatic hierarchical search refinment by subfolder location. How do I recreate this in SharePoint 2013?

  • RELEVANCY SCORE 2.73

    DB:2.73:Sharepoint 2010 Refinement Panel And Managed Metadata Issue 9z


    Ok, this is my first post. I have been doing a lot of research on this. I have2 questions and1 issue:
    1. Does it matter if the managed metadata column is multivalued when using the refinement panel? Are there any known issues with that?
    2. Does it matter if the managed metadata has a deep nested taxonomy when using the refinement panel? Again, any known issue concerning that?
    Now if the answer to these two questionsare No, then here is my issue:
    I created a content type declaritively in VS 2010. This content type has 4 mulit-valuedmanaged metadata columns. This content type is deployed and being used. All is well so far. The problem is that these values in those fields don't show up in the
    refinement panel. Now after extensive research I come to find out that when you create a content type this way and not through the UI, there are a lot of missing pieces and parts. And it is too late to fix the content type as it is already being used. Here
    are the things I should have done:
    1. Named the note field a certain way. (example, if mymanaged metadatafield was named Department, then I should have named my note field DepartmentTaxHTField0, at least that is how I understand it)
    2. Add these two fields to my content type:
    FieldRef ID=f3b0adf9-c1a2-4b02-920d-943fba4b3611 Name=TaxCatchAll/

    FieldRef ID=8f6b6dd8-9357-4019-8172-966fcd502ed2 Name=TaxCatchAllLabel/

    3. Add the following event receivers:
    Receiver

    NameTaxonomyItemSynchronousAddedEventReceiver/Name

    TypeItemAdding/Type

    AssemblyMicrosoft.SharePoint.Taxonomy, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c/Assembly

    ClassMicrosoft.SharePoint.Taxonomy.TaxonomyItemEventReceiver/Class

    SequenceNumber10000/SequenceNumber

    /Receiver

    Receiver

    NameTaxonomyItemUpdatingEventReceiver/Name

    TypeItemUpdating/Type

    AssemblyMicrosoft.SharePoint.Taxonomy, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c/Assembly

    ClassMicrosoft.SharePoint.Taxonomy.TaxonomyItemEventReceiver/Class

    SequenceNumber10000/SequenceNumber

    /Receiver
    Now updating the content type just seems to be out of the question once it is in use. That's been my experience atleast.
    So I guess my questions is, am I screwed as far as using the refinement panel, or is there a way to fix this?
    I can't find anybody else who has this same issue and was able to fix it, so I don't expect too many responses if any, but I'm at the end of the rope with this one.
    Thanks in advance.
    J

    DB:2.73:Sharepoint 2010 Refinement Panel And Managed Metadata Issue 9z

    Hi Ravi,
    I created the metadata columns for a content type that is being used by a document library.
    I have a feature that consumes the term store items. That all works.
    JoeJoe

  • RELEVANCY SCORE 2.73

    DB:2.73:Remove Duplicates Values In A Refiner In Refinement Panel k7


    Hi,

    I have a content search webpart which return some search results.
    Now i have added a refinement panel and added a refiner which is a site column say (ProductName). ProductName contains a constant value like (Television)

    But, in refinement panel Television is showing twice. Ideally it should come once.
    And also total 30 results are coming , 28 under first and 2 under second.
    How to remove duplicate value from refiner ?

    Please remember to click 'Mark as Answer' on the post that helps you or Vote As Helpful

    DB:2.73:Remove Duplicates Values In A Refiner In Refinement Panel k7

    HI,
    There were no hidden characters.

    I deleted the refinement webpart and inserted a new one
    and than added new refiners. It worked now!!!!!Please remember to click 'Mark as Answer' on the post that helps you or Vote As Helpful

  • RELEVANCY SCORE 2.73

    DB:2.73:Search In A Straight Table Chart mx



    Hello

    I have a straight table chart with a single dimension (customer name) and several expressions (sales amount, time consumed and so on). This table serves as filter through which the user selects a customer and then gets a detailed analysis using other objects on the sheet.

    Everything is fine, besides the fact I dont see to be able to find how to enable the search for that customer name column...

  • RELEVANCY SCORE 2.72

    DB:2.72:Refinement Panel Doesnt Show On Some Search Page Results m1


    I have a portal at http://mymoss, when I enter search keywords in the search box (scope= all sites) and hit search, I get search results in the center of a page without the Refinement Panel, the url in the browser is
    http://mymoss/searchcenter/pages/results....

    When I return back to portal page, chose scope = This site: My Portal, results are displayed to the left as a list as well, the url in the browser is
    http://mymoss/_layouts/OSSearchResults.......

    But when I click on one of the tabs to go to a document library or team site, enter the same keywords, I get a list of result and Refinement Panel displayed to the left. the url in the browser is
    http://mymoss/MyLibrary/_layouts/OSSearchResults.......

    1st question, why 1st 2 pages doesn't show Refinement Panel , I would like to know how to add the Refinement Panel in those 2 cases.
    2nd, when I amn in a the 3rd case where Refinement Panel is displayed, clicking on Site action, I don't have Edit page as for the case 1 and 2.

    Is Refinement Panel is a webpart or a somehting needs to be configured somewhere?
    I am really confused with this different ways of rendering and different url each time.

    Thanks for your help

    DB:2.72:Refinement Panel Doesnt Show On Some Search Page Results m1

    after battling 2 days, it all came down to MetadataThreshhold property. I didn't have enough items to display on the library and when I set the value to 1 I was able to retrieve my results. hope it helps
    by the way, metadataThreshholds indicates the results returned by the filter.
    Category Title=Module Description=Filter by Module Type=Microsoft.Office.Server.Search.WebControls.ManagedPropertyFilterGenerator MetadataThreshold=1 NumberOfFiltersToDisplay=4
    MaxNumberOfFilters=20 SortBy=Frequency SortByForMoreFilters=Name SortDirection=Descending SortDirectionForMoreFilters=Ascending ShowMoreLink=True
    MappedProperty=module MoreLinkText=show more LessLinkText=show fewer /

  • RELEVANCY SCORE 2.72

    DB:2.72:How To Add A Refinement To Contentbysearchwebpart? df


    Hi folks,
    I've derived acustom controlfrom ContentBySearchWebPart. Is there a possibility to extend my custom Content Search Web Part (CSWP)with a refiner based on a content type property?
    To explain it in more detail: I'm trying to extend the standard CSWP with a custom refinement, for example as radio button list that is placed right above the search results.
    Is it possible? Could someone give me a hint how to achieve this?

    Thanks!

    DB:2.72:How To Add A Refinement To Contentbysearchwebpart? df

    Hi Miles,
    thank you for your answer.
    I want to add a custom refinement inside my Content Search Web Part. Unfortunately the OOTB refinements aren't a solution for me, because the page will get multiple of these CSWP and the refinements should be a litle part of them.
    Regarind the second option, yes, I saw the possiblity to extend my search query server side, but I need to provide kind of a UI (e.g.) radio buttons as you suggested inside of CSWP and to react if user changed the value. This is actually my challenge.
    My actual solution is to place several instances of the CSWP on the page, hide all of them inside of a tab control using by jQuery tabs and to show only one of the web parts when changing tab.
    But I don't like this solution, because it is static, not dynamically extendable and it produce unnecessary load on server and client.

  • RELEVANCY SCORE 2.72

    DB:2.72:Specifying Multiple Refinement Targets In Refinement Webpart ,So That It Can Filter Mutiple Content Search Webparts sx


    Hi,
    Say, If I have 3 content search webparts on a page and 1 Refinement webpart. How can I make the Refinement webpart filter the content in all 3 content search webparts on that page.

    For example: say one content search webpart displays imagesonly. 2nd content search webpart displays only word documents and 3rd content search webpart displays only PDF documents. Now if I select a refiner in Refinement
    webpart say Training it should be able to refine the content in all 3 content search webparts to show only images, word docs, pdf related to Training

    Thanks in Advance

    DB:2.72:Specifying Multiple Refinement Targets In Refinement Webpart ,So That It Can Filter Mutiple Content Search Webparts sx

    Hi!
    Maybe you have come up with a solution for this already but I met a similar challenge and solved it without any code by using query rules, result blocks and result tables in the CSWP.
    You can read about it in my blog:
    http://johanerixon.wordpress.com/2014/10/28/filtering-multiple-search-webparts-from-one-refinement-panel
    /Johan

  • RELEVANCY SCORE 2.72

    DB:2.72:Simple Questions On Tables ca


    Hi,can u tell me how to disable checkbox that comes with the table, and how to change back ground color of a particular column. How to enable sort function for each column ? Is there any standard functionality to do this?.Thanks.Sunita.

  • RELEVANCY SCORE 2.71

    DB:2.71:Add Document Library Name To Refinement Panel On Sharepoint 2010 Search ps


    Hi All,
    Can you please help me how can I add document Library names or path in refinement panel in SharePoint 2010 search.
    Thanks in Advance.

    AbhijitAbhijit Sil

    DB:2.71:Add Document Library Name To Refinement Panel On Sharepoint 2010 Search ps

    I created a workaround for getting the Document Library name in the refinement Panel.
    I have added a hidden column to Document Library and set its default value to be the document library name.
    Then create a Managed Property for the same and add to the search scope.
    Add the Managed property to the Refinement Panel.....and refinement panel will start displaying the Document Library name for the searched documents.

    Abhijit Sil

  • RELEVANCY SCORE 2.71

    DB:2.71:Refinement Panel In Sharepoint 2010 7a


    I have added the refinement panel web part in the search result page and the refine result is showing in a popup div.
    The user select a different set of refinement from the popup div, I need to resubmit the original query and update the result in the popup div.
    How do I acheive this? Please help

    DB:2.71:Refinement Panel In Sharepoint 2010 7a

    If you notice, when a user clicks on a refinement panel link, it reloads the page, but this time with an additional querystring parameter with a key of r, such as r=author%3D%22AuthorName%22 (in the previous case, if you unescape that, it says r=author:AuthorName.)
    At any rate, if you can pass the URL of the link they click on to the underlying (parent) page, you should be fine.Blog:
    blog.beckybertram.com |
    RSS | @beckybertram |
    SharePoint 2010: Six-in-One

  • RELEVANCY SCORE 2.70

    DB:2.70:Selecting From Different Rows kc


    Hi all,

    The database is Oracle10g.

    I want to select one column from one row of a table, based on a condition, and the second column of the second row of that first row of the same table.

    There should be an order by clause to enable it so that I can talk about first row and second row.

    For example : select ename , job from emp where deptno = 20; . And here the column ename is for the first employee of deptno 20 , and job is the column for the second employee in the same deptno.

    How to achieve this ?

    Thank you very much indeed

    DB:2.70:Selecting From Different Rows kc

    I think you want this.

    SQL create table test as select rownum id,'ROW '||rownum r from all_objects where rownum=5;

    Table created.

    SQL select * from test order by id;

    ID R
    ---------- --------------------------------------------
    1 ROW 1
    2 ROW 2
    3 ROW 3
    4 ROW 4
    5 ROW 5

    SQL select id,r,lead(r,1) over (order by id) next_r from test order by id;

    ID R NEXT_R
    ---------- ---------- ----------
    1 ROW 1 ROW 2
    2 ROW 2 ROW 3
    3 ROW 3 ROW 4
    4 ROW 4 ROW 5
    5 ROW 5The feature you are looking for is analytic functions. You can read about them here: http://download.oracle.com/docs/cd/B19306_01/server.102/b14223/analysis.htm#sthref1684

  • RELEVANCY SCORE 2.70

    DB:2.70:Manged Property Based On Calculated Column 8k


    Hi,
    I set a refiner based on a managed property.
    the managed property is mapped to the crawled property which is based on a document library calculated column with a formula:
    =In Process .
    In refinement panel i see
    string;#In Process
    instead of just display:
    In Process

    why is it so?

    keren tsur

    DB:2.70:Manged Property Based On Calculated Column 8k

    How can i achieve this with a managed metadata column? it has to be the same value automatically for all items in the library and when the document is moved between libraries - to get the new value based on the new document library where the document iskeren tsur

  • RELEVANCY SCORE 2.70

    DB:2.70:Enable/Disable Buttons In A Table (Report) as


    Hi,
    I have a table with an associated form generated by the Report wizard. I want to disable or hide the edit icon on the primary key column on a per row basis depending on the value in another column (in this case the Status column). How do I do it? I've experimented a bit but I can't work out how to reference the value in one column from another column.

    Thanks,

    Steve

  • RELEVANCY SCORE 2.70

    DB:2.70:How Do You Use A Refinement Panel Without Having A Search Box To Type Into? sz


    I want to display results and have a refinement panel based on my taxonomy. I do not want to have a search box though. I want to search a list and not give users the ability to search anything, just filter the current list.

    Is this possible? I just want the refinement panel and to show all items in my list in the middle of the page. I don't want to use a list view though since I want more control on the way the page displays.nonam

    DB:2.70:How Do You Use A Refinement Panel Without Having A Search Box To Type Into? sz

    I need same functionality to be implemented in my site.
    Did you get any solution for this?

    Inderjeet Singh....

  • RELEVANCY SCORE 2.70

    DB:2.70:Sharepoint 2013 Content Search And Refinement Panel a9


    I am using SharePoint 2013 Enterprise search. My search page has a Search Textbox, Refinement Panel and the search results web part.
    When I perform a content search my matching search results are displayed, I then can use the refinement panel to further refine my results based on the content search results. Perfect, no problem there.
    BUT, if I start my search using a refinement panel and then want to search content (Using my textbox search) that is based on the results from my refinement panel, I cant. Once I do a textbox search the results are for all matching documents not just the
    results from my initial refinement results.
    Is there a way around this?
    Thanks.

    DB:2.70:Sharepoint 2013 Content Search And Refinement Panel a9

    Thanks for your help. So should I override SearchBoxEx?

  • RELEVANCY SCORE 2.70

    DB:2.70:In How Far Does Wm Have A Limitation To 28 Characters For Column Names. kx


    When tying to enable versioning on a table the WM says that certain columns have more than 28 characters.
    For regular tables column names can be at least as long as 31 characters.
    Is this somehow possilble in WM as well?

    Best regards,

    Alex

  • RELEVANCY SCORE 2.69

    DB:2.69:Refine On Webapplication kc


    Hi,
    We would like to enable the refinement on webapplication. Currently we have 3 webapplications:
    https://webapp1.domain.com
    https://webapp2.domain.com
    https://webapp3.domain.com
    All contain data for different kind of products. When we search and a result gets hits from any of these webapplications, we would like to be able to refine the results (through the refinement panel) to any of the 3 webapplications.
    I tried to add a managed property bound to the WebApplication crawled property and use this one, but it yields no results.
    Kind regards,
    Jeroen

    Blog: Skavi

    DB:2.69:Refine On Webapplication kc

    leave it this way it's been filled by the content enrichment use it as mentioned above

    1-create different content source for each webapp
    2- change the property to be refinable
    3-execute full crawling
    Hope that helps|Amr Fouad|MCTS,MCPD sharePoint 2010

  • RELEVANCY SCORE 2.69

    DB:2.69:Refinement Token In Sharepoint 2013 ja


    Hi All,
    The requirement is that on click of a button,redirection to a urlshould happen. Theredirection url will be present in a list and the same is accessed via code.

    Here the redirection url contains refinement parameter as
    r: [{n:mangeproperty,t:[\ǂǂ47444d53\],o:OR,k:false,m:{\ǂǂ47444d53\:refinervalue}}]
    The refinement token ǂǂ47444d53 is present in the url. My doubt is whether refinement token will change?
    Will the refinement token change in any case likecrawling or if it is moved to some other environment.?
    If it is changing means, then we cannot make use of refinement token in the url. Is there any other option?
    Please suggest.

    DB:2.69:Refinement Token In Sharepoint 2013 ja

    Hi Sharath,
    The ǂǂ47444d53 should be a user name in the Refinement web part which is used to refine the search results.
    Per my knowledge, the value will not change for the same user name in different SharePoint environment.
    And for other managed properties, such as FileType, the values used to refine the search results will not change either.
    Best regards.
    ThanksVictoria Xia
    TechNet Community Support

  • RELEVANCY SCORE 2.69

    DB:2.69:Custom Refinement Panel Problem dx


    I have set up a custom refinement panel following the instructions on this blog:
    http://www.sharepointanalysthq.com/2010/10/custom-refinement-filters-in-sharepoint-2010/
    http://www.sharepointanalysthq.com/2010/06/adding-search-refiners-in-sharepoint-2010/

    When I search for something, I see the custom refinement options on the panel with the counts next to them, however when I click any of the custom mappings, the next page says:We did not find any results...
    Already did full crawl twice, but I don't understand why this is happening.
    Does anybody have a clue?
    Thanks

    ceren

    DB:2.69:Custom Refinement Panel Problem dx


    Yes, already checked that but no luck.

    My columns are lookups, I am wondering if that might be the reason for this? Is there a limitation on lookup columns to be used as managed property ?ceren

  • RELEVANCY SCORE 2.69

    DB:2.69:How To Most Effectively Taverse A Table Column dp



    I have a table "template" which is used in various "instances". All instances have checkboxes in the second column (for record-delete).

    What would be the most effective way of traversing the table and check if at least one checkbox is selected (to enable a "delete" button)?

    DB:2.69:How To Most Effectively Taverse A Table Column dp


    I have a table "template" which is used in various "instances". All instances have checkboxes in the second column (for record-delete).

    What would be the most effective way of traversing the table and check if at least one checkbox is selected (to enable a "delete" button)?

  • RELEVANCY SCORE 2.69

    DB:2.69:Search With Respect To A Column Value, Refinement Of Results j3


    How can I use a Document Library column for search refinements? In a document library I've created a column MyCategory (it's text or a multi-value field). When I search a document I want to refine the search by the values of this column. For example before search: if MyColumn is a text column I want to appear it in the dropdown box and provide a value for it. If it's a multi-value field I want to choose a specific value. If nothing is specified I want to refine my search results like it's possible with the author field (the links on the left side in the search center).

    DB:2.69:Search With Respect To A Column Value, Refinement Of Results j3

    On your Search Results page, have you customized the XML in the Refinements Panel Web Part? This needs to happen in order to connect the search refinements with the custom Managed Propertyyou made in Central Admin. Here's a post that may
    help:
    http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/2a90452e-c682-4394-be67-cea975dee651
    However, if the custom column in your document library permits multiple values, the refinements panel won't parse each value as a separate refinement. I'm looking for a solution to that now and have posted a question here:

    http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/f40a62cb-9dba-47bf-a868-0835a8d084d2
    Hope this helps!

  • RELEVANCY SCORE 2.68

    DB:2.68:How To Add Custom Category In Sharepoint Search Refinement 1c


    Hello
    In refinement panel, Ihavemodified the refinement panel web part XML and add a new catetory to display the conenteypeand it is displaying perfect as mentioned below
    Content Type
    Any Content Type
    Document
    Risk Assessment
    Compliance
    Now I want add to display in different manner as mentioned below, How can I display
    Content Type
    Any Content Type
    Document
    My ClassifiedContent Type(I want to display this as heading and custom content types underneath)
    - Risk Assessment
    - Compliance
    Please let me know how can I achieve this?
    Regards
    Avi

    DB:2.68:How To Add Custom Category In Sharepoint Search Refinement 1c

    Hello
    Thanks for the url.I already mentioned that I have already implemented this, now I want to display in different style as mentioned below.
    Let me know if you have any ohter idea.
    Regards
    Avi

  • RELEVANCY SCORE 2.68

    DB:2.68:Can I Add List And Library Links When Searched In Refinement Panel.. ak


    How can i customise Refinement Panel in such a way that when searched i can have Library and Lists Links on the left hand side of the refinement panel when searched..What changes should be made to the xml refinement panel coding to get the addrss of lists
    and libaries on the refinement panel when searched..

    DB:2.68:Can I Add List And Library Links When Searched In Refinement Panel.. ak

    How can i customise Refinement Panel in such a way that when searched i can have Library and Lists Links on the left hand side of the refinement panel when searched..What changes should be made to the xml refinement panel coding to get the addrss of lists
    and libaries on the refinement panel when searched..

  • RELEVANCY SCORE 2.68

    DB:2.68:Multiple Refinementfilters p1


    I'm using the REST Search API on SharePoint 2013. I'm trying to specify 2 refinement filters: owstaxIdPractice:equals(L0|#0af2f6e66-cea0-44f6-9423-9ba5b3bc5a6e|Insurance) and SiteType:equals(Project). I can search successfully
    by either one but can't figure out how to combine them. What is the syntax for multiple refinement filters on a querystring?

    Ray Riopel

    DB:2.68:Multiple Refinementfilters p1

    On a related note, when using GUIDs for refinement filter is it possible to have it act like a Label filter when using :equals()? The following *will* return the correct GUID plus child terms:
    Skills:#e96633a8-408d-4dd4-831e-f252a901cc6e
    However, it seems to do an exact match and won't match on any field that has multiple terms.-DdJ

  • RELEVANCY SCORE 2.68

    DB:2.68:How To Hide Folder And Page Content Type From Search Refinement Panel Web Part 11


    Hello
    I followed following article to display the content type and it works perfectly. Here I noticed that Folder and Page content type are also displaying in left panel of search refinement panel and users are getting confused. How Can I hide these content type?
    http://www.glynblogs.com/2011/01/create-a-content-type-search-refinement-panel-in-sharepoint-2010.html

    Regards
    Avi

    DB:2.68:How To Hide Folder And Page Content Type From Search Refinement Panel Web Part 11

    Hello Jaydeep
    Can you suggest some example?
    Secondly any idea why these (page and folder) are appearing as refiners, logically it should not?
    Avi

  • RELEVANCY SCORE 2.68

    DB:2.68:How To Apply Refinement Filters Through Api xz


    Hi AllI have a certain requirements where in i need to apply RefinementFilters through API in Endeca studio 3.0.I went through different docs on endeca studio and could see Provided QueryFunction filter classesIn this doc that its mentioned to create refinement filter as RefinementFilter refinementFilter = new RefinementFilter("1999", "Year");I am able to create the object and i am applying this to the request as refinementFilter .applyToDiscoveryServiceQuery(query.getDiscoveryServiceQuery());But what this is doing is, its filtering the data , but not showing the refinement in the breadcrumbs. I have tried lot of different ways but i am stuck at this part. Can some one please explain what i am doing wrong and how to fix this?

    DB:2.68:How To Apply Refinement Filters Through Api xz

    I asked my dev resource again - it looks like what you have is correct, but somehow the Breadcrumbs component is not being refreshed when you load the page. It may require additional debugging.That's pretty much all the help I can provide from here.If it still doesn't work, you may want to contact support for more extensive help.Or if someone else on the forum has more experience with custom development in Studio, they may have a better idea.

  • RELEVANCY SCORE 2.67

    DB:2.67:When Searched In Team Site In Search Box How Can I Change And Customise The Refinement Panel When Searched z3


    When searched in search box in Sharepoint team site it redirects to Refinement Panel page.I want to change the look of the refinement panel by deleting few options on the left side and adding lists and libraries to the refinement panel so that when the
    user searches he will be able to view the list and library required on the Refinement Panel Page..How to do this task???

    DB:2.67:When Searched In Team Site In Search Box How Can I Change And Customise The Refinement Panel When Searched z3

    Please have a look at this link:
    http://johnrossjr.wordpress.com/2011/03/24/customizing-the-refinement-panel-for-sharepoint-2010-search/

    Kind Regards Bjoern
    http://spviking.com
    Twitter: Follow @bjoern_rapp

  • RELEVANCY SCORE 2.67

    DB:2.67:How To Add A Refinement On Contenttype On A Search Center? fp


    Hi,
    I'm trying to add a refinement filter based on content type on a search site.
    However, I get the following error message when I try it:
    Property doesn't exist or is used in a manner inconsistent with schema settings.

    Here is the XML that I'm adding to the Filter Category Definition property on the refinement web part. The XML itself should be fine, because if I change MappedProperty=ContenType to i.e. MappedProperty=Author, it works great.
    Category Title=Content Type Description=Content Type Type=Microsoft.Office.Server.Search.WebControls.ManagedPropertyFilterGenerator MetadataThreshold=5 NumberOfFiltersToDisplay=4
    MaxNumberOfFilters=20 SortBy=Frequency SortByForMoreFilters=Name SortDirection=Descending SortDirectionForMoreFilters=Ascending ShowMoreLink=True
    MappedProperty=ContentType MoreLinkText=show more LessLinkText=show fewer /

    ContentType is a managed propety out of the box, so I can't see what could be wrong here.
    Any help would be very appreciated.
    Thanks,
    Chris

    DB:2.67:How To Add A Refinement On Contenttype On A Search Center? fp

    I looked into this before, and wrote a post on it:
    http://www.sharepoint.bg/radi/post/SharePoint-2010-Search-Some-Managed-Properties-cannot-be-included-in-queries.aspx
    The only workaround that I know is detailed here:
    http://social.technet.microsoft.com/Forums/en-US/sharepoint2010programming/thread/d4e168b5-0d5a-4cf5-aec0-682ec21ec896
    Hope this helps!SharePoint 2010 MCM. Feel free to contact me http://www.sharepoint.bg/radi

  • RELEVANCY SCORE 2.66

    DB:2.66:How To Show The Properties List Of A Refinement Panel On Page Load? cd


    How to prevent the show more and show the properties list right when the page is load (so it'll be open and user won't need to open the show more link)

    DB:2.66:How To Show The Properties List Of A Refinement Panel On Page Load? cd

    How to prevent the show more and show the properties list right when the page is load (so it'll be open and user won't need to open the show more link)

  • RELEVANCY SCORE 2.66

    DB:2.66:Add Contentsource As A Refinement xp


    Hi guys, i've been having a issue these couple of hours and i don't know if it's even possible on sp2013,

    i've been playing allot with sp2013 refinement, and i've wanted to know if there is a way to add the content Source as a refinement in the result page?

    let's say i have 5 different content source, and i want to refine my search by sources. Is there a easy/hard way to do it?

    Thank you

    Yohann

    DB:2.66:Add Contentsource As A Refinement xp

    try to change the content source managed property and set Refinable Yes then you can find it when you choose refiners from the Refinement webpart properties

    label for=ctl00_PlaceHolderMain_ctl09_ctl01_refinerTypeDropDownList style=font-family:inherit;font-size:inherit;color:inherit;vertical-align:middle;Refinable/label

  • RELEVANCY SCORE 2.66

    DB:2.66:Enterprise Search Results Page Should Have Custom Refinement Panel And Custom Search Result Web Part mj


    My Requirement is to have Enterprise Search Result page without Search core Results Web Part (OOB Search results web part), however It should display my Custom Webpart search results and custom Refinement Panel.

    Currently I tried adding custom metadata properties to the refinement panel and I am able to see my custom refiners in the Refinement Panel webpart, click on any filters in Refinement panel refines the results and displayed in both of my OOB Search Core
    Results webpart and my Custom Webpart search results.

    However if I remove my OOB Search Results webpart, the refinement panel shows empty and displays the same search Results in my Custom Webpart.

    How do I display my same refinement panel for my custom webpart also which was displayed when I had my OOB search box results also?

    How is Search Core Results webpart linked to refinement panel?

    DB:2.66:Enterprise Search Results Page Should Have Custom Refinement Panel And Custom Search Result Web Part mj

    Hi Ramesh,
    The Search Core Results web partis linked totheRefinement Panelvia the Cross-Web Part query ID. This is set in the Results Query Options section of thetool pane, in both the Search Core Results and Refinement Panel web parts.
    Does your custom web part inherit from the OOB core search results?

    David Wilborn MSFT

  • RELEVANCY SCORE 2.66

    DB:2.66:Write Back In Obiee 11g : Unable To Check "Enable Write Back" sd


    Hi all!
    I have a table on presentation, i want to make a table in analysis with function "Write back". But in criteria, when i choose "column properties" -- "write back" tab -- i can not check "Enable write back". I have granted privileges "write back" to user
    Please tell me how to configure to make it.
    Thanks so much.

    Edited by: OBIEE.vn on Jan 6, 2011 7:54 PM

    DB:2.66:Write Back In Obiee 11g : Unable To Check "Enable Write Back" sd

    Guys,

    In addition to my last statement be sure that the LightWriteBack element tag is leveraged in your instanceconfig.xml file.

    Edited by: Christian Screen on Apr 30, 2011 7:57 PM

  • RELEVANCY SCORE 2.66

    DB:2.66:Refinement For Sitename fz


    Hello everyone,
    I have installed SP2013 search and it works fine. However, using SharePoint 2010 I had the ows_sitename property which allowed me to do a refinement on the results page for the sites AND folder of the fileshare. Now in SharePoint 2013 I have set up the Webpart
    to use this Property again but it doesn't allow me to navigate down to the regarding folder in the fileshare. Only sites are shown.
    What is wrong here? What has changed? Is there a way to do a refinement on the fileshare folders in SP2013?
    Thanks!
    Regards
    Christian

    DB:2.66:Refinement For Sitename fz

    Hey Guys,
    I might have to create a new question but i am hoping you guys can help me. I have two search content source in SharePoint 2013. One for all site in sharepoint and one for file share. I want to give the users the ability to select the content source that
    they want to use for search. Basically a refinement that it only shows them search result from file share. i used to this with search scope in SP2010. I have been playing around with result source and query builder to set this up with no success. Could you
    guys lead me in right direction?

  • RELEVANCY SCORE 2.66

    DB:2.66:Trouble With Negative Refinement Filters And Data Source On Oid 2.3 s3


    Hi

    I'm having trouble using the negative refinement filters on a data source with Information Discovery 2.3

    Here's the data source configuration

    {
    "baseFunctions": [
    {
    "attributeKey": "COMPANY",
    "attributeValue": "PROMO",
    "class": "com.endeca.portal.data.functions.NegativeRefinementFilter"
    },
    {
    "class": "com.endeca.portal.data.functions.RecordFilter",
    "recordFilter": "OR(OID_RECORD_TYPE:RES,OID_RECORD_TYPE:DEF)"
    }
    ],
    "datastoreName": "datastorename",
    "name": "ABC",
    "port": "7770",
    "server": "XYZ"
    }

    When I reach a Dashboard page where all the portlets are using this datasource, the record filter is applied as expected. However, for the negative refinement filter, while it does appear in the breadcrumb portlet, it has no effect on the data set. The guided navigation still shows the value as a possible dimension and I can see in my results table that the data was not removed by the negative refinement filter. I tried to restart Tomcat, with no effect.
    If I go in the guided navigation and define negatively this value, on the COMPANY dimension, the data gets filtered out and I get 2 negative refinements to show up in the breadcrumb for the same value (!)

    Is there something I'm missing to configure the negative refinement filter?

    Thank you

    DB:2.66:Trouble With Negative Refinement Filters And Data Source On Oid 2.3 s3

    Anytime, glad that worked. Definitely a tricky issue...the info you provided in your question was a huge help so thanks for being so detailed!

    Regards,

    Patrick Rafferty

  • RELEVANCY SCORE 2.65

    DB:2.65:Sharepoint Search Refinement Panel d8


    Hi
    I am creating acustom Advanced search webpart in Sharepoint 2010. I want to add the custom refinement panel for the same. How to acheive this.

    DB:2.65:Sharepoint Search Refinement Panel d8

    Hi Thomas,
    Thanks for your response. The links provided here explain how to customise the refinement panel using XSLT.
    But i want to create a custom webpart for example, i would like to show the refinement values in multiple dropdowns, in this case,i am using Keyword query class to get the results but how to get the refinements for the results. Thanks.

  • RELEVANCY SCORE 2.65

    DB:2.65:How To Get Table Column Name From View Column Name p3


    Hi,

    I am having a view defined on a table. The view contains 2 columns which are created from single column of table.
    How to get table column name ?

    Thanks in advance.
    Ambarish.

    DB:2.65:How To Get Table Column Name From View Column Name p3

    Hi,

    I think, you can check the CREATE VIEW SQL of that particular view and find out the Column of the table

    Thanks

  • RELEVANCY SCORE 2.65

    DB:2.65:How To Filter On Aggregate? k1


    In the GettingStarted sample, user try to filter the products with certain number of total sale quantity. How can this be done? The Order Quantity filter on Products page is misleading. It filters out the individual order line, not the total sale quantity.

    This refinement should be one step in the information discovery. User want to do some refinement, like time frame, before this step. And the user want to do further refinement, like sale geography, after this step.

    Thanks

  • RELEVANCY SCORE 2.64

    DB:2.64:Jtables-Enable/Disable Column Moving Based On The Column Index as


    I am trying to create a JTable that displays 5 columns in a fixed order.
    I want to disallow the rearangement of these 5 columns, but I also want to allow users to add columns to this base set and allow them to rearange the order. I've found how to enable/disable column movement for an entire table, but not how to do this on a per column basis. Does anyone have any ideas on how to do this?

    Thanks for any help.

    Shanewill3

    DB:2.64:Jtables-Enable/Disable Column Moving Based On The Column Index as

    Well, the not very helpful answer: I'd start to manipulate with the TableColumnModel, and perhaps redefine the moveColumn method. However, it most likely needs some research, and IMHO, it probably doesn't prevent the user to pull the column to a new position, but the column will return.

    A more helpful answer:

    http://codeguru.earthweb.com/java/

    There, if you follow the swing, then the JTable link, you'll find many small code snippets. Among them, on the second or third page, you'll find one where the author manages to add fixed (I mean, always visible) rows to his table look. He does that by actually using two parallel tables, and I'd think you might consider using the same idea for your problem.

  • RELEVANCY SCORE 2.64

    DB:2.64:Insert Into Table. pc


    i want insert rows in table b having 5 columns from table a having 3 columns how to achieve that ?

    eg..

    table a

    column 1
    column 2
    column 3

    table b

    column 1
    column 2
    column 3
    column 4
    column 5...

    i used beloc script

    insert into usename.table b @dblink ( column 1,column 2,column 3) select column 1,column 2,column 3 from table a

    but i m gettin error

    ORA-01400: cannot insert NULL into

    plz suggest.

    Edited by: user511621 on Feb 4, 2010 11:23 PM

    DB:2.64:Insert Into Table. pc

    Hi,

    insert into usename.table b @dblink ( column 1,column 2,column 3) select column 1,column 2,column 3 from table aYour Column1,column2,column3 in table a , one of them is null and the table on the remote db i.e tableb has a constraint of not null.
    Either provide values for null column as suggested above by Massimo or select the data which is not null like

    insert into usename.table b @dblink ( column 1,column 2,column 3) select column 1,column 2,column 3 from table a
    where column1 is not null;
    /*assuming table b has a not null constraint on column 1 and tehre are null values in column 1 of table a */Cheers!!!
    Bhushan

  • RELEVANCY SCORE 2.64

    DB:2.64:Refinement Panel Drill Down Content Types And Sub Content Types c7


    Hi,
    I am busy with a question of a customer regarding filtering and drilling down on Content Types in a refinement panel of the SharePoint Enterprise Search.
    I defined allready the primary refinement, but the customer also would like to filter based on the Content Type and show the Sub Content Types of this Content Type.
    I don't know if there is a simple way to resolve this question, or do I have to develop a custom Refinement Panel Web Part?
    Regards

    DB:2.64:Refinement Panel Drill Down Content Types And Sub Content Types c7

    Andre,
    If you mean is there some way for the refinement panel to magically know which content types inherit from your specified content type then the answer is no. The CustomFilters element can only specify three Data Types:
    CustomFilters
    MappingType=ValueMapping|RangeMapping
    DataType=Date|Numeric|String
    ValueReference=Relative|Absolute
    ShowAllInMore=True|False
    ...
    /CustomFilters
    So if you want automatic discovery of inherited content types, youwill probably need to write your own refiner -unless you can get a custom managed property to return the content type ID insteadof the content type name. In that case,
    you would be able to use arelative ValueReference and specify ranges like 0X101.. since all child content typeIDsstart with the same characters as the parent. Another way you could dothis (which is not at all practical) would
    be to maintain a strict naming convention, like Documents, Documents - Legal, Documents - HR etc.
    Two more things I'll mention here:

    If your document type hierarchy doesn't change that often and you don't mind mirroring your document type structures in XML, simply apply it to the Refinement Schema like so:
    CustomFilter CustomValue=Document
    OriginalValueDocument/OriginalValue
    OriginalValueDocument - Legal/OriginalValue
    OriginalValueDocument - HR/OriginalValue
    /CustomFilter
    and that will do just what you want but you would have to make sure to update your xml each time a change to the content hierarchy was changed.

    Writing your own refiner wouldn't be that hard because of the property of content type IDs whichI've already mentioned.

    I hope that helps. If you need any more information or want assistance with a custom refiner, I suggest you open a Service Request with us.

    Adam

  • RELEVANCY SCORE 2.64

    DB:2.64:Search Refinement Panel: Range Mapping Of String Values jk


    We are crawling different fileshares and therefore upon searching the refinement panel shows me a refinement option for this (sitename - website).
    The problem is that the fileshare names are not very usable for the user, so I want to rename them. I want to change the Filter Category Definition.
    The problem is that all the search results have a specific path so I need to do some sort of RangeMapping. But as soon as I change the MappingType to RangeMapping I get a crash.
    How can I bring the Refinement Panel to work on strings with DataRange Mapping Type?
    Thank you.

    DB:2.64:Search Refinement Panel: Range Mapping Of String Values jk

    You will need a code solution for this. You need to build a custom ManagedPropertyFilterGenerator to parse your file share paths into something useful for users. An excellent blog post by Charlie Holland gives you step by step.
    http://www.chaholl.com/archive/2011/03/29/building-a-custom-refinement-filter-generator-for-sharepoint-2010.aspxBlog | SharePoint Field Notes Dev Tool |
    ClassMaster

  • RELEVANCY SCORE 2.64

    DB:2.64:Is There A Way To Limit The Search Results To Return Only The Item That Have The Keyword In The Title? 91


    I have an SP Enterprise installation and I am trying to limit the results to return the items that have 2011 in only the Title Column. I would like to use the refinement for this.
    How I envision this working:
    User enters 2011 into search box
    Results return everything with 2011
    User clicks Title in Refinement and only the items with 2011 in the title are returned to narrow the search results.

    Is this possible?
    Stephanie M Applebee

    DB:2.64:Is There A Way To Limit The Search Results To Return Only The Item That Have The Keyword In The Title? 91

    Hi Seven,

    Please see my previous reply, it doesn't produce the results I am looking for. But thanks anyway, I solved it by extending the CoreResults webpart and using the query string in the URL.Stephanie M Applebee

  • RELEVANCY SCORE 2.64

    DB:2.64:Create Search Refiner For List Name In Sharepoint 2013 aj


    Hi everybody!

    How could I create a search refiner for list name in SharePoint 2013?? I think I can create a search refiner for list ID but how could I show list name base on list id to users in refinement webpart??

    DB:2.64:Create Search Refiner For List Name In Sharepoint 2013 aj

    you can create your custom Manged property and use content enrichment to fill the managed property
    http://blogs.msdn.com/b/richard_dizeregas_blog/archive/2013/06/19/advanced-content-enrichment-in-sharepoint-2013-search.aspx

    Hope that helps|Amr Fouad|MCTS,MCPD sharePoint 2010

  • RELEVANCY SCORE 2.64

    DB:2.64:Import A Column From An Excel Spreadsheet, Then Enable/Disable Boolean Controls In A Cluster Based On Imported Values x1


    Greetings all. I have an application I've been developing and refining for some time. Part of it entails an interactive periodic table of elements where the user can selectmultiple elements to include in a multi-element chemical standard. The part I'm having difficulty with now is disabling multiple elements within the periodic table. Specifically, what the scientist wants is to be able to reference an excel inventory that they keep of available on-hand single-element standards. I need to be able to read in column A of that spreadsheet, build a distinct array of those elements listed (some are listed more than once) and then disable the boolean controls in my periodic table for those elements not in the array (or enable those elements which are in the array, whichever makes themost sense). This way, the analyst cannot select elements in the periodic table for which thay have no on-hand inventory. I see how to enable or disable all controls ina boolean cluster, and I see how to enable/disable a single control, but I'm looking for an elegant way to import the excel column, build an array of thsoe values and then enable only those values. Any help is always appreciated. Thanks again.

    DB:2.64:Import A Column From An Excel Spreadsheet, Then Enable/Disable Boolean Controls In A Cluster Based On Imported Values x1

    hi

    try this




    Gaurav kCLD Certified !!!!!Do not forget to Mark solution and to give Kudo if problem is solved.

  • RELEVANCY SCORE 2.64

    DB:2.64:Refinement Panel And Paging 7f


    Hi,

    In my search results I have page web part and a refinement panel. The refinement panel is set up to refine on a 'Category' field that is a managed property on my site. This is working really well but what I've noticed is that when I do a search with a large
    result set, not all of the 'Categories' are shown on the first page of the refinement panel.
    I get different refinements on different pages which leads me to believe that the refinement panel web part is only looking at refinement fields on a page-per-page level. This is a problem as my users don't only want to realise that they could have refined
    the results to a refinement that is only showing up on the 4th page, for example.
    Is there a way that I can get the refinement panel to show ALL of the refinements in the entire search result set instead of just on a page per page level?

    Thanks
    Michael

    DB:2.64:Refinement Panel And Paging 7f

    Many thanks for posting your solution - Iwas really puzzled by this until I read your post. I found that I had to set it to 500 as wellto get the counts accurate when using ShowCounts=true to show the count of items in each categoryLars Nielsen http://discoverlars.wordpress.com

  • RELEVANCY SCORE 2.64

    DB:2.64:How Can I Extend Refinement Panel(Refinementwebpart Class) And Develop My Custom Refinement Panel? 9j


    I needcustom refinement webpart ,that has to 1)refine based on result and 2)refinement has to be categorized and displayed. 3)Which also have to work as accordin control.
    soi'm tring to extent Refinement WebPart class and trying to develop custom webpart using visual studio.
    can anyone tell me what should i do to achieve this?.[finding hard which function to override and what function will give you the data source and on]
    I already spend ample time in this. :(

    DB:2.64:How Can I Extend Refinement Panel(Refinementwebpart Class) And Develop My Custom Refinement Panel? 9j

    See:
    http://www.chaholl.com/archive/2010/08/20/creating-a-custom-refinement-filter-generator.aspx
    If you need to go further and create a new refinement webpart (as opposed to a filter generator) please get back to me.
    Ch. - My Blog |
    SharePoint 2010 Application Development - My Book

  • RELEVANCY SCORE 2.63

    DB:2.63:Access Denied On Init.Debug.Js After Selecting Refineres In The Multi Refinement Panel fs


    Hi,
    After selecting some refiners in the multi refinement panel andclicking apply button a javascript errors occurs in the page stating
    Acces is denied Init.debug.js HostURl/_layouts/15/init.debug.js?rev=.This is the behaviour in the OOB refinement panel.Is there a way to remove this javascript error.
    Thanks,
    Saranya.

    DB:2.63:Access Denied On Init.Debug.Js After Selecting Refineres In The Multi Refinement Panel fs

    http://social.technet.microsoft.com/Forums/windows/en-US/8fbd1c97-8ebb-4a4b-90e0-988c0e7bf5da/javascript-runtime-errors-in-initdebugjs?forum=sharepointdevelopment
    try to remove custom items one by one to find out the problematic one. For example, you can remove the custom js file one by one or removing bootstrap js file and so on. The most probable reason is some syntax error in your custom js file.
    If this helped you resolve your issue, please mark it Answered

  • RELEVANCY SCORE 2.63

    DB:2.63:How Do I Customise The Refinement Panel For The Main Site Search Results Page jp


    How do I customise the Refinement Panel for the main Site Search Results Page. I have successfully achived this for a Basic Search Centre to allow filtering on Creation Date by editing the web part and editing the Filter Category Definition to include
    new fileds. However the main Site Search Results Page does not allow me to edit it. Any ideas would be gratefully received. Cheers Ross

    DB:2.63:How Do I Customise The Refinement Panel For The Main Site Search Results Page jp

    Excellent. Glad it worked out for you.Corey Roth blog: www.dotnetmafia.com twitter:
    @coreyroth

  • RELEVANCY SCORE 2.63

    DB:2.63:Managed Property In Refinement - Why Not Use The Automatically-Created Site Column Managed Property fk


    Hi,
    I read that although SharePoint 2013 automatically creates managed property for site column (OWS_Q_TEXT_COLUMNNAME) - in the refinement i should use a managed property and map to the ows_columnname. why?
    what's the difefrence?
    what is best - to create a new managed property (and set it as refinable) or use the OOB Refinementstring0, Refinementstring1 etc.)?

    keren tsur

    DB:2.63:Managed Property In Refinement - Why Not Use The Automatically-Created Site Column Managed Property fk

    You are probably talking about this blog post.
    http://blogs.technet.com/b/tothesharepoint/archive/2013/11/11/how-to-add-refiners-to-your-search-results-page-for-sharepoint-2013.aspx
    The reason you want to use the ows_columnname crawled property is because it is of the correct data type. The other is always text. If the site column is a date or a decimal then using the OWS_Q_TEXT... crawled property,will cause the refiner not to display
    the appropriate control, for example a slider control for a date type refiner.
    http://sharepointfieldnotes.blogspot.com/2013/05/understanding-and-getting-sharepoint.htmlBlog | SharePoint Field Notes Dev Tools |

    SPFastDeploy | SPRemoteAPIExplorer

  • RELEVANCY SCORE 2.63

    DB:2.63:Add Metadata Property To Search Refinement Panel? xa


    Hi,
    I have created a site column and then added that site column as metadata property in Central admin.
    After that i made changes in xml of refinement panel which as below
    Category Title=Category Description=category of item Type=Microsoft.Office.Server.Search.WebControls.ManagedPropertyFilterGenerator MetadataThreshold=5 NumberOfFiltersToDisplay=1 MaxNumberOfFilters=4 SortBy=Frequency SortDirection=Descending
    SortByForMoreFilters=Name SortDirectionForMoreFilters=Ascending ShowMoreLink=True MappedProperty=CategoryMap MoreLinkText=show more LessLinkText=show fewer CustomFilters MappingType=ValueMapping DataType=String ValueReference=Absolute
    ShowAllInMore=False CustomFilter CustomValue=A OriginalValueB/OriginalValue/CustomFilter /CustomFilters/Category
    when i add a new category to xml of refinement panel and start full crawl even then metadata property is not visible on refinement panel
    thanks,
    Gaurav

    DB:2.63:Add Metadata Property To Search Refinement Panel? xa

    When the refiner is not showing in the Search Center there are a few things to check.

    Make sure to fully crawl the content after creating the managed property and confirm the crawled property contains
    values.Make sure there is enough data which uses in this case the language. In the above XML the value of the
    MetadataThreshold attribute is set to 3. This means the number of results that must contain a value to display the
    filter generator under the filter category is set to 3.Uncheck Use Default Configuration in the webpart properties of the Refinement Panel, section Refinement.In the webpart properties of the Refinement Panel in the section Refinement a value is displayed for Number of
    Categories to Display. If the number of categories exceeds this number and the new category is defined last in the XML,
    itwon’t show up.
    reference:
    http://www.itidea.nl/index.php/search-refiners-part-1-expanding-the-ootb-search-refinement-panel/

    MCTS,MCPD Sharepoint 2010. My Blog- http://sharepoint-journey.com

    If a post answers your question, please click Mark As Answer on that post and Vote as Helpful

  • RELEVANCY SCORE 2.63

    DB:2.63:How To Add Hierarchical Refiners In Fast Search 2010 With Managed Metadata? zj


    Hi,
    I would like to add hierarchical refiners to my SP2010 farm with FAST Search for SP2010. I have a hierarchical taxonomy.
    Example
    Region: World - Europe - Western Europe - Germany - Cologne
    My documents' contenttype has a column of type Managed Metadata and the documents have the appropriate values (cities)than in the field Region.
    How to display on the results page the refiners in a hierarchical manner with some kind of treeview on the refinement panel?
    Thanks
    Sven

    DB:2.63:How To Add Hierarchical Refiners In Fast Search 2010 With Managed Metadata? zj

    Hi John,
    I do not have a solution yet, but Raymond replied to your thread here:
    http://social.technet.microsoft.com/Forums/en-US/fastinternetesp/thread/4da1007b-a6c0-462b-bc9c-d2055cf59a4f
    It seams that he uses jQuery components to build the tree.
    Sven

  • RELEVANCY SCORE 2.63

    DB:2.63:Search Refinement Panel Displaying Terms Along With Term Ids 8a


    Hello
    I am having an issue with how the terms are being displayed in the search refinement panel. The terms are displaying along with weird long ID's. How do I fix this issue. Here is some background:

    Running FAST Search with SharePoint 2010 EnterpriseThe refinement panel Filter Category Definition was customized so that I am calling specific managed properties instead of using the generic ones in the refinement panel. This issue seems to be limited to this specific site collection as I have done this
    with other collections and have no issues.The refinement panel is a on web part page not a standard OSSSearch or FAST results search page.Here is a picture of the error:

    Any ideas? Let me know if you need more info.

    DB:2.63:Search Refinement Panel Displaying Terms Along With Term Ids 8a

    The category configuration we had correct, it was the full crawl that was the issue. We deleted the managed properties once again, did a full crawl and then they showed up. Now everything is working. Thanks for your help.

  • RELEVANCY SCORE 2.63

    DB:2.63:Sharepoint Refinement Panel s3


    Hi,
    I am working on Sharepoint Search Results page. I want to populate my own items in the refine ment panel from the database,without editing XLST in refinement panel configuration. Because i have lot of Data Sources in the FAST server. I need to sisplay data
    Sources Info in the Refinement panel Dinamically..

    How to do this...

    DB:2.63:Sharepoint Refinement Panel s3

    This might help?
    http://johnrossjr.wordpress.com/2011/03/24/customizing-the-refinement-panel-for-sharepoint-2010-search/Regards | Aaron www.aaron-rendell.co.uk | SharePoint Consultant | Microsoft Gold Partner - Silversands, Poole, Dorset, England