Author Topic: Finding Segment date serach field in AG  (Read 3576 times)

Anand

  • Jr. Member
  • **
  • Posts: 20
    • View Profile
Finding Segment date serach field in AG
« on: April 07, 2017, 02:11:26 AM »
Hi

Please help on how to find Segment (date) field for an AG which is having multiple date fields using ODWEK. Also the corresponding folder field to which the segment field is mapped. I have an idea like get all the AG fields and use the mask values to find the Segment Date field { mod(mask/4,2) = 1  }. Thanks in advance.


Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Finding Segment date serach field in AG
« Reply #1 on: April 07, 2017, 04:37:43 PM »
Hi.

Can you give us some more information about what you're trying to achieve?  Most of the time, you want to make this a required field in the folder configuration, so that end users are forced to enter a date (or date range) in order to send a query to the server.

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

Anand

  • Jr. Member
  • **
  • Posts: 20
    • View Profile
Re: Finding Segment date serach field in AG
« Reply #2 on: April 10, 2017, 12:58:08 AM »
Hi JD

We have a common search portal which is to search across all the repositories (CMOD, P8 etc). Search portal holds GUID, Segment date and AG name in DB from CMOD. For retrieval, Search portal provides the above values (not field names) to CMOD. We have one to one folder AG mapping. GUID field name is same across all AGs & folders. Only difficulty is to find the Segment date field name in OD and corresponding mapping in folder to set the search criteria. Hope this explains the scenario better.

Thanks
« Last Edit: April 10, 2017, 03:55:37 AM by Anand »

rgator

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: Finding Segment date serach field in AG
« Reply #3 on: July 10, 2017, 07:34:35 AM »
Anand,
Did you ever figure out a way to query the appgroup to find out what field is marked as the segment field?
I need to do the same thing as we possibly might have to unload and then reload a bunch of reports..
When we do the reload we want to be sure to load the report back with the original date that was specified
in the segment field..  I'm guessing I'll have to query the appgroup to get the segment field.. than take that
field and query the application to get the proper format of that date...
If you figured out how to get the segment date field I'd appreciate it if you let me know... thanks

I found how to get the segment field by pulling from the arsag and arsagfld tables...
The segment field has a mask value of 6...
« Last Edit: July 10, 2017, 09:58:59 AM by rgator »

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Finding Segment date serach field in AG
« Reply #4 on: July 12, 2017, 09:27:16 AM »
For future reference, check the wiki for details on IBM CMOD tables:  https://cmod.wiki/index.php?title=Content_Manager_OnDemand_Database_Tables

Also, individual values must be a power of 2 -- the "6" provided by rgator below represents both "Segment" and "Updatable".

Search for "bit masks" or "vectored fields" to understand how the arsasagfld table's mask field is formatted.

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

Alessandro Perucchi

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1002
    • View Profile
Re: Finding Segment date serach field in AG
« Reply #5 on: October 13, 2017, 03:06:11 PM »
Just for info, until IBM doesn't change the format of the database, the field you search it the following for the segment field:

BITAND(MASK, 4)=4
Alessandro Perucchi

#Install #Migrations #Conversion #Educate #Repair #Upgrade #Migrate #Enhance #Optimize #AIX #Linux #Multiplatforms #DB2 #Windows #Oracle #TSM #Tivoli #Performance #Audits #Customizing #Availability #HA #DR #JavaApi #ContentNavigator #ICN #WEBi #ODWEK #Services #PDF #AFP #XML