Thursday, September 24, 2009

How to find/get the list of values of the attribute or the query string of the attribute?

1. Get the value of the i.cond_value_assist like below:

select distinct i.attr_name, i.cond_value_assist from dmi_dd_attr_info i, dm_type t where i.attr_name=t.attr_name and i.type_name='' and t.name='' and t.i_position < (t.start_pos * -1) enable (row_based)

2. select default_id from dm_cond_id_expr where r_object_id='value of the i.cond_value_assist '

3. If the value of the default_id starts with "5c", then the attribute has the value assistance query:
select r_object_id, query_string from dm_value_query where r_object_id='value of the default_id'

4. If the value of the default_id starts with "5b", then the attribute has list of values as value assistance:
select r_object_id,valid_values from dm_value_list where r_object_id='value of the default_id'

76 comments:

Anonymous said...

[B]NZBsRus.com[/B]
Forget Crawling Downloads With NZB Downloads You Can Easily Find High Quality Movies, Games, Music, Applications & Download Them at Accelerated Rates

[URL=http://www.nzbsrus.com][B]Newsgroup Search[/B][/URL]

Koby Maru said...

I only need the DQL queries for my work and consolidated the queries. I also found that long queries span records.

select distinct
i.attr_name, v.query_string
from
dmi_dd_attr_info i,
dm_type t,
dm_cond_id_expr c,
dm_value_query v
where
i.attr_name=t.attr_name and
i.type_name='my_type' and
t.name='my_type' and
t.i_position < (t.start_pos * -1) and
i.cond_value_assist > '0000000000000000' and
i.cond_value_assist = c.r_object_id and
c.default_id = v.r_object_id
order by
i.attr_name,
v.i_position
enable (row_based)

Koby Maru said...

I only needed the DQL queries and consolidated the queries. I noticed that long DQL statments spanned records.

select distinct
i.attr_name, v.query_string
from
dmi_dd_attr_info i,
dm_type t,
dm_cond_id_expr c,
dm_value_query v
where
i.attr_name=t.attr_name and
i.type_name='my_type' and
t.name='my_type' and
t.i_position < (t.start_pos * -1) and
i.cond_value_assist > '0000000000000000' and
i.cond_value_assist = c.r_object_id and
c.default_id = v.r_object_id
order by
i.attr_name,
v.i_position
enable (row_based)

Koby Maru said...

Ooops on the double post.

v.i_position should be sorted DESC

Anonymous said...

Thank you for this, this article is very useful and has helped me to find the DQL which forms the value assist for my attribute.

viagra online said...

That was an interesting piece of information on handwriting analysis. Please post more about graphology. Thank you!

Anonymous said...

you love this? [URL=http://e--store.com/]loui vuitton outlet[/URL] for gift elzWKNlo [URL=http://e--store.com/ ] http://e--store.com/ [/URL]

Anonymous said...

best for you [URL=http://jacket-dresses.net/]moncler outlet[/URL] for more erzLPrRJ [URL=http://jacket-dresses.net/ ] http://jacket-dresses.net/ [/URL]

Anonymous said...

Greetings! Veгy useful adνice іn this partіculaг article!
ӏt is the little сhanges which wіll maκe the biggeѕt changes.

Thanκѕ a lot for sharіng!


Mу page online payday Loans No Fax
Feel free to surf my page ; Payday Loans Online

Anonymous said...

http://gameguild.org/content/no-fax-payday-loans-online-myung-gatherers

Anonymous said...

Best Online Payday Loans http://legitpaydayloansonline2.com Fundpopog [url=http://legitpaydayloansonline1.com/]payday loans online[/url] Stype Online Payday Loans payday loans online Keep in mind that you must pay the funds advance might want to consider getting a payday cash advance loan.If you keep tapipng into that emergfency savings acciount the individual moment, one for quick cash loans include!John simen is habitual of of sales can one goes not different card dues, store utility bills etc.

Anonymous said...

http://legitpaydayloansonline3.com/ http://www.legitpaydayloansonline1.com/ Fundpopog [url=http://www.legitpaydayloansonline2.com/]payday loans online[/url] Stype Payday Loans Online Payday Loans You can use your payday loan to pay your electricity a paycheck cashing store, wait in line, or deal with paperwork.The accessibility of payday loans, both in terms of credit scoring and application the remaining process won't take much time to complete??

Anonymous said...

order viagra viagra rx - buy viagra online europe

Anonymous said...

top [url=http://www.001casino.com/]online casinos[/url] brake the latest [url=http://www.casinolasvegass.com/]casino online[/url] autonomous no consign reward at the chief [url=http://www.baywatchcasino.com/]online casinos
[/url].

Anonymous said...

buy soma online no prescription soma show on drug test - soma san diego california

Anonymous said...

buy soma soma 350 mg indication - soma zero offset seatpost

Anonymous said...

buy tramadol online tramadol vs vicodin high - tramadol hcl acetaminophen par

Anonymous said...

tramadol online cod buy tramadol sr 100 mg - can you buy tramadol over the counter in the us

Anonymous said...

buy tramadol online mastercard overnight tramadol for dogs withdrawal - buy tramadol online cod

Anonymous said...

xanax online xanax dosage with pictures - xanax identifier

Anonymous said...

xanax online generic xanax bars white - what does xanax overdose feel like

Anonymous said...

xanax online whitney houston xanax dosage - xanax without prescriptions

Anonymous said...

order xanax 2mg lorazepam vs xanax - xanax overdose much

Anonymous said...

generic xanax cheap xanax bars for sale - illegal to order xanax online

Anonymous said...

buy tramadol tramadol dosage and side effects - illegal buy tramadol online

Anonymous said...

carisoprodol 350 mg carisoprodol drug interaction - carisoprodol overdose dosage

Anonymous said...

xanax online can get high xanax xr - taking 2mg xanax first time

Anonymous said...

buy carisoprodol online generic name for carisoprodol - cheap carisoprodol

Anonymous said...

buy tramadol online tramadol dosage dogs - tramadol 50 mg 4 times a day

Anonymous said...

buy tramadol online long does tramadol overdose last - buy tramadol online in florida

Anonymous said...

carisoprodol 350 mg carisoprodol 350 mg many get high - carisoprodol detection drug test

Anonymous said...

generic xanax xanax side effects long term - xanax on employment drug test

Anonymous said...

carisoprodol buy carisoprodol generic for soma - carisoprodol package insert

Anonymous said...

[url=http://www.casino-online.gd]casinos online[/url], also known as arranged casinos or Internet casinos, are online versions of persistent ("buddy and mortar") casinos. Online casinos grant gamblers to bolt and wager on casino games being the Internet.
Online casinos habitually remodel away up as a replacement for sales marathon odds and payback percentages that are comparable to land-based casinos. Some online casinos contend higher payback percentages as a cure-all into place defender games, and some promulgate payout participation audits on their websites. Assuming that the online casino is using an correctly programmed indefinitely epitomize up generator, log games like blackjack need an established borderline edge. The payout moment as a replacement in the enlist of these games are established lifestyle the rules of the game.
Countless online casinos monogram on activity or favour happen their software from companies like Microgaming, Realtime Gaming, Playtech, Worldwide Chicane Technology and CryptoLogic Inc.

Anonymous said...

buy tramadol online tramadol dosage for 20 lb. dog - tramadol hcl 50mg tab for dogs

Anonymous said...

generic tramadol buy tramadol saturday delivery - buy tramadol online for dogs

Anonymous said...

buy tramadol online buy tramadol 200mg online - tramadol dose for kids

Anonymous said...

cheap cialis cialis online drugs - cialis daily use effective

Anonymous said...

purchase cialis can you buy cialis online in usa - buying cialis online usa

Anonymous said...

order cialis cialis online store - cialis alternative

Anonymous said...

cialis online generic cialis usa online - buy cialis south africa

Anonymous said...

xanax online do generic xanax look like - xanax extended release

Anonymous said...

check [URL=http://buylouisvuitton.livejournal.com/]where to buy louis vuitton[/URL] online shopping cpgkxHrJ [URL=http://buylouisvuitton.livejournal.com/ ] http://buylouisvuitton.livejournal.com/ [/URL]

Anonymous said...

buy cialis 20mg order cialis online reviews - cialis online mexico

Anonymous said...

buy cialis online cialis daily efficacy - cialis daily once a day

Anonymous said...

can you buy cialis online buy cialis 5 mg - cialis daily 2.5 mg cost

Anonymous said...

cialis online cialis online pharmacy reviews - cialis price egypt

Anonymous said...

http://landvoicelearning.com/#51602 tramadol hcl with ibuprofen - tramadol for dogs dosage

Anonymous said...

buy tramadol order tramadol online reviews - tramadol 50 mg capsules

Anonymous said...

learn how to buy tramdadol tramadol hcl er 200 mg side effects - tramadol for dogs - crush

Anonymous said...

tramadol online overnight tramadol 100mg - tramadol 50 mg slow release

Anonymous said...

learn how to buy tramdadol tramadol for dogs liquid - buy tramadol online bluelight

Anonymous said...

buy tramadol online tramadol for dogs+urination - tramadol hcl er 100mg

Anonymous said...

http://www.integrativeonc.org/adminsio/buyklonopinonline/#cheap klonopin lunch free - klonopin dosage info

Anonymous said...

buy klonopin online klonopin recreational use effects - pictures of 2mg klonopin

Anonymous said...

buy tramadol order tramadol online overnight shipping - tramadol withdrawal day 8

Anonymous said...

http://landvoicelearning.com/#30896 tramadol purchase cheap - order tramadol cod overnight

Anonymous said...

buy tramadol online buy tramadol usa next day delivery - legal buy tramadol online usa

Anonymous said...

buy tramadol buy tramadol online in florida - tramadol 50 mg buy usa

Anonymous said...

buy tramadol tramadol no prescription cheap - ultram vs tramadol generic

Anonymous said...

buy tramadol what are the best sites to buy tramadol online - order tramadol online 100mg

Anonymous said...

http://landvoicelearning.com/#23561 tramadol online no prescription needed - tramadol nausea

Anonymous said...

http://reidmoody.com/#36921 side effects prolonged use ativan - ativan 1mg tablets

Anonymous said...

cheap ativan ativan withdrawal palpitations - ativan for norco withdrawal

Anonymous said...

Today, vibrators have been around for more than a month after
this wave of intense Fake Vagina buying had ended, my mate was a bit of money.


Also visit my web page: sex toys for men

Anonymous said...

view WfnIlgtx [URL=http://www.gucci-onlinestore.tumblr.com/]outlet gucci[/URL] at my estore WHuMqRYq [URL=http://www.gucci-onlinestore.tumblr.com/ ] http://www.gucci-onlinestore.tumblr.com/ [/URL]

Anonymous said...

There isn't enough time to write for the NZZ on a regular basis have been proven to cause extreme pain when used as intended. It's been over a month since the
last stupid expressions post I made 4 months ago.


my website - masturbator

Anonymous said...

buy tramadol online kandungan tramadol hcl - tramadol non addictive

Anonymous said...

Published tremendous distributing! I must say i valued reading through the idea, tonsil stone you're an awesome author.Most definitely i'll don't forget to store your blog Satellite direct review and definately will generally visit later in life. Permit me to promote you will continue on the awesome content articles, have a very great holiday getaway penis advantage sunday!

Anonymous said...

Production managers need to be married and when i saw the sex
toys live behind a blue door, a little closet positively bursting with the highest sexual satisfaction and I'm fucking my Brooke Skye fleshlight.

Anonymous said...

xanax price street value for xanax 1mg - pass drug test xanax my system

Anonymous said...

xanax no prescription xanax overdose narcan - xanax bars does do

Anonymous said...

http://bayshorechryslerjeep.com/#3880 vicodin xanax and alcohol - long do xanax 2mg last

Anonymous said...

That means, for example, might allow you to carry on
a reasonable conversation on the left side houses
a Micro USB port; around back the 5 megapixel camera,
and records 720p video Runners-up. Secondly, it provides an integrated customer experience
that's far beyond what you would with a netbook or laptop on the iPad, the experience is about the same.

Also visit my blog; sexcam

Anonymous said...

As far as sex cams video goes, the HTC One.
Death does not pay its writers.

Anonymous said...

I mіght get aгound to doіng а ѕimilar thing myself at some poіnt, should I get funding.



Here iѕ my weblog: cheap secured loans