search from dimension value

(0) Share

Report

Posted on by mohammed.mqi

2,050

Greetings everyone

i have table name PayrollExpencesTrans and it relation with DimensionAttributeValueCombination

and i want search about Partial from the dimension value from PayrollExpencesTrans table

i want search about this value (M09001)

so i did like this

select firstOnly  payrollExpencesTrans
            where dimensionAttributeValueCombination.DisplayValue like "*" this.text() "*"
            exists join dimensionAttributeValueCombination where payrollExpencesTrans.LedgerDimension==dimensionAttributeValueCombination.RecId;

but still give me nothing

any idea how can i solve this problem

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Hi mohammed,

You can use DimensionAttricuteLevelValueAllView instead and query based on ValueCombinationRecId -

select firstOnly payrollExpencesTrans join dimensionAttributeLevelValueAllView where dimensionAttributeLevelValueAllView.ValueCombinationRecId == payrollExpencesTrans.LedgerDimension where dimensionAttributeLevelValueAllView.DisplayValue == this.text();

Was this reply helpful? Yes No